Skip to main content
Question

Customer Statement of Account Based on Invoice Date Instead of Due Date

  • July 17, 2025
  • 1 reply
  • 14 views

Forum|alt.badge.img

Hi Community,

 

Is it possible to run customer statement of account report based on invoice date instead of due date of invoice.

for example: If an invoice is dated as 07/02/2025 and due date as 07/31/2025, it should be shown in 1-30 bucket rather than Not Due bucket.

Any views?

1 reply

Furkan Zengin
Ultimate Hero (Partner)
Forum|alt.badge.img+21
  • Ultimate Hero (Partner)
  • 765 replies
  • July 17, 2025

Hello ​@SagarAgarwal 

The aging is always based on due date. But i suggest you to create a BR report from FACT_CUSTOMER_OPEN_BALANCE. There you can create the bucket with invoice date. If you need it in PDF, BR reports can be exported as PDF by default.

Change on Customer Statement of Account will require a modification.

Hope this helps

Furkan