Report Designer help

Question

Hi All 
 
 I am trying to amend the invoices and credits by customer report so that it shows the carriage charge invoiced. 
 
 I have added the expression to calculate the carriage charge which it has done but i notice that if the invoice has more than one line, it adds the carriage charge onto each line and i cant figure out how to stop that as it throws out the figures completely as only one lot of &pound;450 was charged

Can anyone help????

Rajeev Arora · Answer

Carriage is charged at the Invoice level not the item level, so you will probably be looking for a carriage cost per invoice and then a total for each customer. 
 Ken's method gets you the carriage cost per invoice - you add a field with expression INVOICE.CARR_NET to the INVOICE_NUMBER footer and make sure the Function property is set to none. 
 The next step is to also give this new field a name in the Property window - I called mine InvCarrNett . You'll use this name to get the carriage cost total per customer. 
 Now add a field to the ACCOUNT_REF footer with the expression InvCarrNett . Basically you are referring this field back to the one you created above. In the properties window for this new field set the Evaluate Section property to INVOICE.INVOICE_NUMBER Footer and the Reset Section property to INVOICE.ACCOUNT_REF Footer . This should get you the desired result. Here's some screenshots of how I did it with some practice data:

Sage 50 Accounts

Report Designer help

COMMUNITY

COMPANY

PARTNERS

SUPPORT & TRAINING