Small and medium business | Business Central, N...

Previous months outstanding not on statement for Feb

(4) Share

Report

Posted on by MS-03120953-0

387

We running customer statement with Balance method for Feb. Previous month unpaid invoices not displayed

Any reasons why

Thank

Categories:

Microsoft Dynamics NAV

I have the same question (0)

All responses (6)

Answers (0)

AndrewThomas81 216 on at

Like (0)

Report
Copy link

Link copied!

What date ranges are you specifying?

Can you screen shot the parameters for the report and the open entries.

Was this reply helpful? Yes No
MS-03120953-0 387 on at

Like (0)

Report
Copy link

Link copied!

We have invoices oustanding from last year...but the statement only displays the Feb transactions in the entries...it also displays over due entries below that

We need invoices not overdue from past months to display in Feb statement...we have 120 days and 90 days customers

Was this reply helpful? Yes No
Suggested answer

AndrewThomas81 216 on at

Like (0)

Report
Copy link

Link copied!

Do the transactions include if you change the start date to an earlier date?

Was this reply helpful? Yes No
Suggested answer

OussamaSabbouh 11,101 Super User 2026 Season 1 on at

Like (1)

Report
Copy link

Link copied!

Hello ,

Most likely the date filter/statement period is set to February only, so the statement is only listing transactions within that period and your older unpaid invoices fall outside the range (they may still be included in the balance, just not shown as lines). If you want all prior unpaid invoices to print, run the Customer Statement with Statement Style = Open Items (this is the standard way to force “show open entries regardless of posting date”), or widen the date filter to include earlier months; also sanity-check the “missing” invoices aren’t applied/closed already (even partially), because then they won’t show as open items.

Regards,
Oussama Sabbouh

Was this reply helpful? Yes No
Suggested answer

YUN ZHU 98,066 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!

Hi, The data here is taken from Detailed Customer Ledger Entries. You can filter it on the page to see if your criteria are met.

Thanks

ZHU

Was this reply helpful? Yes No
Suggested answer

Dhiren Nagar 2,799 Super User 2026 Season 1 on at

Like (1)

Report
Copy link

Link copied!

Hi,

Can you please make sure that while you run the report you have select "Show Overdue entries" on the request page?

Also make sure that the entries are OverDue before the End date of the report. So for e.g. If you are running report till 28/02/2026 then Invoice must be due on or before 27/02/2026 then only the Invoice will be included in the Overdue entries.

I've checked the report works just fine.

✅ Tick the checkbox below to mark the answer as verified, if it helped resolve your question.

Regards,

Dhiren.

LinkedIn - https://www.linkedin.com/in/ca-dhiren-nagar-5079081b2/

Blog - https://dhirennagar.blogspot.com/

Was this reply helpful? Yes No