Sage Line 50 Settlement Discounts

[jd.smithuk]

We have a customer setup to receive a settlement discount of 3% for prompt payment, when I post an invoice the goods total is discounted and carriage isnt thats exactly what I want to happen and everything in the world is rosey. BUT credit control use a report called Customer invoices with Settlement terms and this shows a different discount as it also discounts the carriage (what it actually does is work the discount out from the Audit_header Net_amount (hence the problem). the report name is CSTISETT.SRT


Can anyone think of a way round this I cant see a carriage field on the audit header.

Thanks in hope

JD

[johndon68]

As you have found, there is no carriage on the AUDIT_HEADER table just the Net and Tax amounts.

Assuming that the carriage is being entered into the Footer details on the invoice, you could amend the report and use the AUDIT_SPLIT table as this would allow you to exclude transactions with the details of 'Carriage'.

John