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

How to create Posted Sales Invoice number (grouping by Sell-to Customer No.)

(0) Share

Report

Posted on by LaserCopr

188

We have multiple Sales Orders for same customer, we will create a bulk Warehouse Shipment and bulk Warehouse Pick together with other customers, after post Ship and Invoice, how can we get Posted Sales Invoice No. sequence by Sell-to Customer Code instead of Sales Order No ( I think this is default)

This is Sales Order list, view (sorted by Sell-to Customer Name):

1234.Sales-Orders.png

Categories:

Dynamics 365 Business Central

I have the same question (0)

All responses (6)

Answers (0)

Sort by

Suggested answer

JAngle 157 on at

Like (0)

Report
Copy link

Link copied!

Providing you have enabled “Combine Shipments” at customer level you can try the combine shipments routine to generate a single invoice based on lines shipped. Details here: docs.microsoft.com/.../sales-how-to-combine-shipments-on-a-single-invoice

Was this reply helpful? Yes No
LaserCopr 188 on at

Like (0)

Report
Copy link

Link copied!

thanks Josh,

Unfortunately although these sales orders are under same Sell-to Customer No., but need to ship them to different Ship-to Customer address, we cannot combine the Posted Sales Invoices

Was this reply helpful? Yes No
Suggested answer

Amit Baru 3,037 on at

Like (0)

Report
Copy link

Link copied!

Hi,

Pls do create Batch Job for achieving the above requirement.

Regards

Amit Sharma

www.erpconsultors.com

Was this reply helpful? Yes No
LaserCopr 188 on at

Like (0)

Report
Copy link

Link copied!

Hi Amit,

Can you please the advise the steps to do batch achieving?

Was this reply helpful? Yes No
Suggested answer

Amit Baru 3,037 on at

Like (0)

Report
Copy link

Link copied!

Hi,

1. Create One Processing Report by using Sales Header dataitem.

2. Sorting on Sell-to Customer No.

3. Write code on OnAfterGetrecords of Sales Header Dataitem.

4. In this way system post Sales Invoice according to the Customer

Regards

Amit Sharma

www.erpconsultors.com

https://www.linkedin.com/in/amit-sharma-94542440/

Was this reply helpful? Yes No
Suggested answer

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

Like (0)

Report
Copy link

Link copied!

Hi, Hopefully the link below can give you some hints.

Manual number for Posted Sales invoice and Posted Purchase invoice (Use the same number in Sales Order and Posted Sales Invoice?)

https://yzhums.com/21537/

Thanks.

ZHU

Was this reply helpful? Yes No