Report Designer help

SUGGESTED

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 £450 was charged

Can anyone help????

  • 0

    I've created what you need but literally copied the Carriage Nett figure from the Invoice file and put it in the invoice number footer section. Ensure that the "Function Setting" is set to None for the carriage field.

    I hope that's what you're after...If you need sub-totalling for the carriage by customer then that's where I get lost; Adding fields that need to accumulate to an exisitng report doesnt happen automatically.

  • 0

    Hi Ken 

    Thank your help with this, it seems to be the subtotaling that is the issue as even if i put the carriage in the invoice foot section which then only shows one lot of carriage, when it totals the carriage it still calculates it as 10x 450 so i'm not sure how to get around this really 

  • 0
    SUGGESTED

    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: