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)

Suggested answer

JAngle 131 on at

Like (0)

Report

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

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

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

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

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

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

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

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

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

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 95,307 Super User 2025 Season 2 on at

Like (0)

Report

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

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