Report design for a sales order - Carriage

Posted By Leon Kedward-Jones over 7 years ago

I have a sales order template and the values in it were erroneous. These do not go to clients and as they are for internal use only have never been fixed however I would like to resolve this.

I have changed the Net, Tax and gross figures successfully but carriage is an issue! The carriage in the footer is reporting a value which is equal to the carriage cost multiplied by the number of item lines.

For example:

£10 carriage on a single line invoice = £10

£10 carriage on a 8 line invoice = £80

This figure should be static at whatever carriage rate is used.

Looking at report templates Sages uses SALES_ORDER.FOREIGN_CARR_NET but this does the same. I have also tried SALES_ORDER.CARR_NET but again no joy.

Can anyone please advise what the issue might be?

Thanks

Steven Holden over 7 years ago

Hi Leon,

It sounds like the most likely cause of this problem is that the variable you have added has been set with the function of 'sum'.

This automatically happens when you add a variable to a footer section as it treats it as a total. However as you know the carriage figure is for the whole invoice and would not need to total per line.

To resolve this, edit your layout and select the variable in question. In the Properties pane, (select View > Properties if this is not showing by default) selection Function and change it from Sum to None.

Then save your layout and try previewing it again. If the issue still continues, please let me know.

Thanks,

Adam
Cancel
Vote Up 0 Vote Down

Sign in to reply

Cancel
Steven Holden over 7 years ago

Thanks Adam. Great help
Cancel
Vote Up 0 Vote Down

Sign in to reply

Cancel

Sage 50 Accounts

Report design for a sales order - Carriage

COMMUNITY

COMPANY

PARTNERS

SUPPORT & TRAINING