# Item Number with Vendor # as Prefix and Default Numbering: BC

**URL:** https://www.dynamicsuser.net/t/item-number-with-vendor-as-prefix-and-default-numbering-bc/68208
**Category:** User Forum
**Created:** [December 2, 2020, 7:19pm UTC](https://www.dynamicsuser.net/t/item-number-with-vendor-as-prefix-and-default-numbering-bc/68208 "2020-12-02T19:19:12Z")
**Posts on this page:** 5
**Page:** 1

<div class="post-metadata">

### Author: ![enshepard](https://avatars.discourse-cdn.com/v4/letter/e/53a042/32.png) [@enshepard](https://www.dynamicsuser.net/u/enshepard)
#### Post date: [December 2, 2020, 7:19pm UTC](https://www.dynamicsuser.net/t/item-number-with-vendor-as-prefix-and-default-numbering-bc/68208/1 "2020-12-02T19:19:12Z")

</div>

I am mostly new to BC but am working with a client who has the following question. They code vendors using a 4-digit number. They would like to use this number on an item card as follows vendor # (eg, 1000)-default numbering series, Is this something that can be done in BC?

---

<div class="post-metadata">

### Author: ![Zumiic](https://avatars.discourse-cdn.com/v4/letter/z/46a35a/32.png) [@Zumiic](https://www.dynamicsuser.net/u/Zumiic)
#### Post date: [December 11, 2020, 10:21am UTC](https://www.dynamicsuser.net/t/item-number-with-vendor-as-prefix-and-default-numbering-bc/68208/2 "2020-12-11T10:21:46Z")

</div>

Hi, enshepard - can You give some examples of how the item numbers would/should look like ?

---

<div class="post-metadata">

### Author: ![enshepard](https://avatars.discourse-cdn.com/v4/letter/e/53a042/32.png) [@enshepard](https://www.dynamicsuser.net/u/enshepard)
#### Post date: [December 15, 2020, 3:55pm UTC](https://www.dynamicsuser.net/t/item-number-with-vendor-as-prefix-and-default-numbering-bc/68208/3 "2020-12-15T15:55:10Z")

</div>

Certainly. Client is retail furniture that does resale. Each vendor is assigned a 4-digit code( e.g., 1204, 1004, 1461, etc.), An item number might look like: 1204-#######; the “#######” segment would be generated automatically by BC for each vendor. Automatic generation of the 2nd segment is needed b/c staff will be creating item card data.

We were testing using the vendor model number for the second segment for item numbering purposes. However, it turns out that most of the vendors, they use the same model number with differential occurring in the finish, cover, etc. choices made by the customer to personalize the item. Whetger the customer wants to customize the item rather than order the exact same item on showroom floor, it’s a special order b/c client does not stock inventory in 95% of cases.

I’m open to other solutions.

---

<div class="post-metadata">

### Author: ![enshepard](https://avatars.discourse-cdn.com/v4/letter/e/53a042/32.png) [@enshepard](https://www.dynamicsuser.net/u/enshepard)
#### Post date: [April 24, 2021, 4:22pm UTC](https://www.dynamicsuser.net/t/item-number-with-vendor-as-prefix-and-default-numbering-bc/68208/4 "2021-04-24T16:22:45Z")

</div>

Hi, I was wondering if you had had any other thoughts about how to make this scenario work. I am dealing with 250 vendors, if that helps.

---

<div class="post-metadata">

### Author: ![schinsky](https://sea1.discourse-cdn.com/flex023/user_avatar/www.dynamicsuser.net/schinsky/32/7474_2.png) [@schinsky](https://www.dynamicsuser.net/u/schinsky)
#### Post date: [April 26, 2021, 1:13pm UTC](https://www.dynamicsuser.net/t/item-number-with-vendor-as-prefix-and-default-numbering-bc/68208/5 "2021-04-26T13:13:01Z")

</div>

Hello,

A long time ago a customer asked me for this type of request. After reviewing the requirement and making sure they understood that they would have an Item list, by Vendor, by Item, meaning like items would be duplicated (if possible), I had to request this from my DEV group. We created a new function to insert an Item No. based on an Option pop-up for Vendor No. and then the Item was inserted with the Vendor No.-(Item No. Series).

Hope this helps.

Thanks,

Steve
