M Message codes not printing

[Heath]

Hi all,

I have this Message codes not printing issue when I add the STOCK.UNIT_WEIGHT variable to my Proforma invoice template.
As soon as I remove the variable then preview the report the Messages print.

Any ideas?

Sage Line 50 Accounts Pro 2010 V16.00.17.0154

Heath

[brucedenney]

The issue is that the stock table is linked in as soon as you use something from it in your case the weight, there is no matching record in the stock table for the M product code, so it cant find the weight and it returns nothing.

This is easy to fix.

Editing your layout in the report designer
Click on the root of the layout (Green folder looking icon) in the report explorer
In Properties find the "Data Source" section, find the option "Include records with no transactions" change it from False to True

save your report and you are done.

[Heath]

Hi Bruce,

Thanks for the reply.
I had already changed the "Data Source" section, option "Include records with no transactions" from False to True as that is what I thought, but it still not printing out the messages.
Can I make an expression or filter to force the include Messages?
Or have you another idea?

Heath.

[brucedenney]

Either you have altered something somewhere from the original layout that has broken it. (The only obvious thing I can think of is the Data Join between the item and the stock table.)

or

the layout has been corrupted in some strange way.

I could look at it, but I would have to charge for my time.

I suggest you check the joins.

Check the logic by taking a standard sage layout adding in the unit_weight field and then test it. If it works, customise the layout to that you already have setup