web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

Sign Up for Ask a Community Pro Today!
Introducing our New Video Series: Community Spotlight
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Small and medium business | Business Central, N... / How to create Posted S...
Small and medium business | Business Central, N...
Suggested Answer

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

(0) ShareShare
ReportReport
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)
  • Suggested answer
    JAngle Profile Picture
    JAngle 145 on at

    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

  • LaserCopr Profile Picture
    LaserCopr 188 on at

    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

  • Suggested answer
    Amit Baru Profile Picture
    Amit Baru 3,037 on at

    Hi,

    Pls do create Batch Job for achieving the above requirement.

    Regards

    Amit Sharma

    www.erpconsultors.com

  • LaserCopr Profile Picture
    LaserCopr 188 on at

    Hi Amit,

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

  • Suggested answer
    Amit Baru Profile Picture
    Amit Baru 3,037 on at

    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/

  • Suggested answer
    YUN ZHU Profile Picture
    YUN ZHU 97,089 Super User 2025 Season 2 on at

    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

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

News and Announcements

Sign Up for Ask a Community Pro Today!
Introducing our New Video Series: Community Spotlight

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Congratulations to our 2025 Community Spotlights

Thanks to all of our 2025 Community Spotlight stars!

Congratulations to the December Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Small and medium business | Business Central, NAV, RMS

#1
OussamaSabbouh Profile Picture

OussamaSabbouh 2,167

#2
Dhiren Nagar Profile Picture

Dhiren Nagar 1,184

#3
YUN ZHU Profile Picture

YUN ZHU 1,161 Super User 2025 Season 2

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans