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

Customer statement bill to customers not showing invoices

(3) Share

Report

Posted on by CU13010319-0

543

I have a few customers that have a different bill to customer designated on the customer card. When invoices post, I'm expecting those posted sales invoices on the customer statement to appear for the customer with the bill to specified, not the existing customer. Is there a way to print the customer statement so that for those customers, the invoices appear on the section for the other bill to customer? And it to show blank for posted sales invoice for the current customer.

I have the same question (0)

All responses (5)

Answers (0)

Sort by

Suggested answer

YUN ZHU 100,629 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!

As far as I know, the standard cannot achieve this; it requires customization.

Hopefully, other experts can give you better advice.

Thanks.

ZHU

Was this reply helpful? Yes No
Suggested answer

AndrewThomas81 1,405 on at

Like (0)

Report
Copy link

Link copied!

There is a Ship-to Filter on the customer statement, so assuming the ship-to information is populated you might be able to filter on that

Kind Regards

Andrew Thomas
https://www.usebusinesscentral.com/
https://www.youtube.com/@usebusinesscentral

Was this reply helpful? Yes No
Gerardo Rentería Ga... 26,487 Most Valuable Professional on at

Like (1)

Report
Copy link

Link copied!

Hi, good day
I hope this can help you, and give you some hints.

Different Sell-to and Bill-to Customers on Sales Documents - Dynamics 365 Business Central Insights

Publicación | LinkedIn

Best Regards
Gerardo

Was this reply helpful? Yes No
Suggested answer

RockwithNav 9,113 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!

No it's not there as of standard but wont take long to develop this as well.

Reporting would be easy I understand but try to work on the Analysis view and see if that one can help.

Was this reply helpful? Yes No
Suggested answer

OussamaSabbouh 15,595 Super User 2026 Season 1 on at

Like (1)

Report
Copy link

Link copied!

Hello ,

Standard Customer Statement does not really regroup posted invoices by Bill-to Customer the way you want. In practice, statements are driven by the customer ledger entries / customer account that the invoice was posted to, so if the invoice posted under the original customer’s ledger, it will appear on that customer’s statement even if a different Bill-to Customer No. was involved on the document. So the answer is basically no, not with the standard report behavior: you won’t get the current customer section blank and have those invoices automatically move to the other bill-to customer’s statement unless the posting itself creates the receivable under that bill-to customer account. If your business needs the statement to always show balances under the bill-to customer only, the clean options are either to make sure documents are posted using that customer as the actual billing account from the start, or use a custom statement report that groups by Bill-to logic instead of standard customer ledger ownership.

Regards,
Oussama Sabbouh

Was this reply helpful? Yes No