On the customer statement you see the invoices, and a total, and if a payment was applied the total is decreased, but the payment is not listed. Is there a way to expose/show/display the payments that took place in the statement period?
Solved
Payments on a statement
Best answer by smilner3
Hi Justin,
That's expected behavior for the Open Item statement type, which is almost certainly what those customers are set to.
Open Item lists only documents still open as of the statement date. When a payment fully applies to an invoice, both close — so neither one appears. A partial payment leaves the invoice open at its reduced balance, which is exactly what you're describing: the total drops, but nothing on the statement explains why.
To confirm that's what you're looking at: open one of those customers on Customers (AR303000) and check the Statement Type field in the billing/financial settings. If it says Open Item, that's your answer. It inherits from Customer Classes (AR201000) unless someone overrode it on the customer.
The fix is the other statement type: Balance Brought Forward.
It lists every document dated within the cycle period — invoices and payments — with the prior outstanding balance carried at the top. That's the format that shows activity rather than just what's still open.
Set it in either place:
- Customer Classes (AR201000) → Statement Type, under Default Print and Email Settings on the General Settings tab (sets the class default)
- Customers (AR303000) → same field, if you only want it for specific customers
Two things to know before you flip it:
- On-demand statements require Open Item. If anyone uses More ▸ Statements ▸ Generate on Demand for these customers, that capability goes away.
- Statements are snapshots. Changing the type won't retroactively alter statements you've already prepared. Regenerate from Print Statements (AR503500) → Action = Regenerate Statement, or per customer at AR303000 → More ▸ Statements ▸ Regenerate Last Statement. Otherwise it takes effect on the next cycle.
One related setting worth checking while you're in there: Age Credits on AR Preferences (AR101000). With it on, unapplied payments and credit memos are included on statements and in aging. That helps for money sitting on account, but it won't surface payments already applied to an invoice — so it's not a substitute for Balance Brought Forward.
If you need to stay on Open Item for other reasons, the practical options are customizing the Customer Statement (AR641500) report or sending a payments-in-period GI alongside the statement.
+1Hi Justin,
That's expected behavior for the Open Item statement type, which is almost certainly what those customers are set to.
Open Item lists only documents still open as of the statement date. When a payment fully applies to an invoice, both close — so neither one appears. A partial payment leaves the invoice open at its reduced balance, which is exactly what you're describing: the total drops, but nothing on the statement explains why.
To confirm that's what you're looking at: open one of those customers on Customers (AR303000) and check the Statement Type field in the billing/financial settings. If it says Open Item, that's your answer. It inherits from Customer Classes (AR201000) unless someone overrode it on the customer.
The fix is the other statement type: Balance Brought Forward.
It lists every document dated within the cycle period — invoices and payments — with the prior outstanding balance carried at the top. That's the format that shows activity rather than just what's still open.
Set it in either place:
- Customer Classes (AR201000) → Statement Type, under Default Print and Email Settings on the General Settings tab (sets the class default)
- Customers (AR303000) → same field, if you only want it for specific customers
Two things to know before you flip it:
- On-demand statements require Open Item. If anyone uses More ▸ Statements ▸ Generate on Demand for these customers, that capability goes away.
- Statements are snapshots. Changing the type won't retroactively alter statements you've already prepared. Regenerate from Print Statements (AR503500) → Action = Regenerate Statement, or per customer at AR303000 → More ▸ Statements ▸ Regenerate Last Statement. Otherwise it takes effect on the next cycle.
One related setting worth checking while you're in there: Age Credits on AR Preferences (AR101000). With it on, unapplied payments and credit memos are included on statements and in aging. That helps for money sitting on account, but it won't surface payments already applied to an invoice — so it's not a substitute for Balance Brought Forward.
If you need to stay on Open Item for other reasons, the practical options are customizing the Customer Statement (AR641500) report or sending a payments-in-period GI alongside the statement.
Trying this. So far, this looks like it may solve our issue. At the very least it jumps us forward significantly!!
Login to the community
No account yet? Create an account
Social Login
Login with your Acumatica accountEnter your E-mail address. We'll send you an e-mail with instructions to reset your password.