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

Community site session details

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

Item number is a combination of vendor#-item#. Linking no series relationships. Business Central.

(0) ShareShare
ReportReport
Posted on by 135

Item number is a combination of vendor#-item#. Liniking no series relationships. Created 200+ vendors to series and main item no.  Next, I tried to link the main item number to the 200+ vendor no series, using Config Package b/c it was taking a long time manually. However, the first time it didn't import those records to the Series Relationship table. All I could see was the data I'd manually input into the Series relationship. Tried Config Package a second time with the same results. Does anyone have any ideas?

I have the same question (0)
  • Suggested answer
    Ben Baxter Profile Picture
    6,396 Super User 2025 Season 2 on at
    RE: Item number is a combination of vendor#-item#. Linking no series relationships. Business Central.

    First, I don't recommend what you are doing.  On an Item Card you have a field for Vendor No and a field for Vendor Item No.  There is no need to build it into your Item's No.

    With that out of the way, you would want to use the main Item No. series and establish 200+ relationships to it.  When you are entering a new Item you would use the ellipses or a Data Template to select which series to number the Item.  This is going to open the door for human error and a lot of renumbering of Items (or delete and re-enter).

    You should be able to use a Config Package with three tables (308 - No. Series, 309 - No. Series Lines, and 310 - No. Series Relationship) to import your records.

    Again, I strongly encourage you NOT to do what you are thinking of doing.

  • Verified answer
    evenshepard Profile Picture
    135 on at
    RE: Item number is a combination of vendor#-item#. Linking no series relationships. Business Central.

    Some background: We wanted to allow sales staff to enter items for special orders where they create an item number that is based on 4-digit code vendor code with a "dash" separator and item number that automatically increments. An example would be 1234-1000601. This solution seemed to best address the desired business need.

    Thanks for the advice on how to link the 200+ relationships to the main item number series and guidance re the Config Package with Tables 308-310.

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

Responsible AI policies

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

Abhilash Warrier – Community Spotlight

We are honored to recognize Abhilash Warrier as our Community Spotlight honoree for…

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

#1
Rishabh Kanaskar Profile Picture

Rishabh Kanaskar 4,330

#2
Sumit Singh Profile Picture

Sumit Singh 2,738

#3
Nimsara Jayathilaka. Profile Picture

Nimsara Jayathilaka. 2,546

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans