Customer Statements

[clairjones123]

On producing customer statements, I have selected all customer records before processing.

When the statements are produced, the total column adds up all invoices from all previous customer statements.

To explain:

A001 has two invoices of £100 each, giving a cumulative total of £200, this is correct.

However, A002 has an invoice of £50, this should give a total for A002 of £50, it is actually showing £250 (the £200 from A001)

I can only assume that the field name is incorrect, but cannot find a setting to change, the field name is AUDIT_SPLIT.FOREIGN_AGED_BALANCE

The total at the bottom of the page is correct for each customer.

Many Thanks for any help!

Clair

[brucedenney]

What version of Sage 50?

[clairjones123]

Hi Bruce,

I'm using Sage 50 accounts plus 15.01.18.0190

Thanks for your reply

Clair

[brucedenney]

If you find the total on the layout and look at the properties for it find >Behaviour and look for > Reset Section
the reset section determines when the "summing" is reset to 0 and started again. Seems it is set incorrectly.

[clairjones123]

Bruce, once again, you are a star

Many Thanks

Clair

[pauljj]

Hi Bruce, i had the same issue initially, in the Header Number Footer section, my AUDIT_SPLIT.FOREIGN_AGED_BALANCE is reset to HEADER_NUMBER footer, as is the same for the debit and credit fields.

However, when running multiple statements, while the total on each statement for each customer is correct, the running totals against each split are an exact sum of the debit/credit fields for each line, and i thought this "balance" would increment for each line on the statement.
so
item1 - £50 debit - balance £50
item2 - £75 debit - balance £125

total amount due - £125

I know i had that working yesterday, but ran into the same issue as clairjones123 (again this part is fixed)

i have uploaded the layout i'm working on.
As always your advice is much appreciated.
Thanks
Paul

CUS_STATEMENT-PRACTICE.layout

[brucedenney]

The AUDIT_SPLIT.FOREIGN_AGED_BALANCE is a sum of all the splits that have preceded this section printing, it is reset to zero each time you start a new header.

I think you just want to have a rolling balance for the customer so instead of resetting to 0 each time you get a new header, you want to reset each time you get a new customer.

On the properties of that field look for the "Reset Section" change it from HEADER_NUMBER footer to ACCOUNT_REF footer it should then reset each time you get a new customer rather than each time you get a new header.

You also need to set the "Is Cumulative" to Yes rather than Automatic

[pauljj]

Morning Bruce,

That's perfect thank you!!!

I had tried that account ref reset as that was making sense with what you've been educating me with over all my posts
It was the Is cumulative function i was missing. I know i had been looking at it, reading it and then totally ignoring it, the answer was right in front of my face.

Thank you so much again, i have a happy accounts dept