Customer Statements

PeterC67

Afternoon all,

When we run customer statements for the end of the month, we use the following options

In our mind this should produce a statement for the customers position as at the statement date.

However if we run the statements on the 2-3rd of the month and there have been receipts on those accounts, then they do not produce a statement.

Why? As the position at the 31.08.23 is an outstanding amount.

Acctd4

Hi Peter

Are you able to screenshot a specific example ?

" ... if we run the statements on the 2-3rd of the month and there have been receipts on those accounts ..."

Are you meaning that it doesn't produce Statements if there's nothing outstanding (due to Payments being received) or are you referring to it not displaying Sales Receipts ? NOTE: Statements generate Accounts Receivable activity only, so Sales Receipts will not be reflected.

Your selections above will only generate a Statement for customers who have had activity & have open invoices over $ 1. Is this what you're querying ?

PeterC67

For example

@ 31.08.2023 Customer1 has a balance of $50

02.09.2023 Customer1 makes a payment of $40

03.09.2023 Print statements dated as per the screenshot above, and Customer1 receives no statement. Which is fundamentally incorrect as they had a balance @ 31.08.23

Acctd4

Were there any invoices or payments dated in the statement period, or is the $ 50 just a carried forward balance ?

If this is the case, unticking the "with no account activity" filter should resolve that: