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

Announcements

News and Announcements icon
Community site session details

Community site session details

Session Id :
Small and medium business | Business Central, N...
Suggested Answer

Different sales document number series based on location

(0) ShareShare
ReportReport
Posted on by 25

We have a customer who sells items; They have two branches (identified with global dimension), with two locations in the same company; They are wanting to have a separate number series for the sales documents (sales orders, sales invoices) when making a sale, but all sales to their customer (regardless of which branch supplied the items) must appear on one statement.

What is the best way to manage the different number series for each branch so that when a sales order / invoice is created, the number series associated with that branch is selected and used. (The challenge here is that the document number is assigned on creation of the sales document. Our first thought was to link a number series to the user ID and assign the location / dimension to the user ID so that when the user sigs in, the number series is already determined.)

Any improvements on this thought would be great.

I have the same question (0)
  • Suggested answer
    Nitin Verma Profile Picture
    21,812 Moderator on at

    Hi,

    System initially checks the No. series from the Sales Setup during creation of Sales documents, so in that case it take no. series defined in the setup, the best way to achieve this requirement, have a little customization so that It ask you select the appropriate no. series before actually defining the sales document no. and creating the sales document, In that case you have take help from your Development partner.

    Thanks.

  • Suggested answer
    YUN ZHU Profile Picture
    102,476 Super User 2026 Season 1 on at

    Hi, The easiest way is to use No. Series Relationships feature and let the user choose each time.

    More details: https://yzhums.com/7522/

    If customized, first let Branch related to No. Series, and then it is recommended to select Branch before creating an order/invoice, so that a new order or invoice can be created with the related No. Series.
    Note that Sales order cannot be renamed.

    Just an idea, hope it helps.

    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

Quick Links

Season of Sharing Community Challenge Winners!

Congratulations to our community stars!

Women in Power Builds Momentum

Expanding mentorship, skilling, and AI innovation

Congratulations to the June Top 10 Community Leaders

These are the community rock stars!

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

#1
OussamaSabbouh Profile Picture

OussamaSabbouh 707 Super User 2026 Season 1

#2
YUN ZHU Profile Picture

YUN ZHU 481 Super User 2026 Season 1

#3
Khushbu Rajvi. Profile Picture

Khushbu Rajvi. 328 Super User 2026 Season 1

Last 30 days Overall leaderboard

Featured topics

Microsoft Training Manuals

Product updates

Dynamics 365 release plans