Small and medium business | Business Central, N...

Item numbers more than 20 Characters

(0) Share

Report

Posted on by Claus Macali.dk

997

In the default og BC, we only have 20 Characters for intem number also in in Item referens number

Any idea how to get more Characters than 20, in anyway, as its seems extending Item number or Item ref. number, will mees up the defalults

Are their somewhere in the sysme a place to have more than 20 or and that can hold be extende to 50,

that can beused like/replacement for item number.

Sample

Item number 23 substitut 32432432432432432432

Categories:

Dynamics 365 Business Central

All responses (10)

Answers (0)

sVerme 120 on at

Like (0)

Report

RE: Item numbers more than 20 Characters

This is the way to go.
We solved it this way for a customer.

Created a custom field "PartNumber", Code[50] in this case. They use this field on all reports, searches, ...

The standerd "No." field is just a numeric field that is used as the PK.
Suggested answer

Amit Baru 3,029 on at

Like (1)

Report

RE: Item numbers more than 20 Characters

Hi,

Create One Custom filed as per the required Length. Use this field for reporting. Do not try to change the base field. It is not recommended

Regards

Amit Sharma

www.erpconsultors.com
Suggested answer

Nitin Verma 21,544 Moderator on at

Like (0)

Report

RE: Item numbers more than 20 Characters

Hi,

simple answer you can not change Item table, instead create a one more Field name can be "item No. 2" with 20 length, and take your data by breaking into two size, and store it accordingly and create a one more field in BC so that it merge and show of those two fields.

Not sure how I am right here. ;)

Thanks.
Suggested answer

Inge M. Bruvik 1,021 Moderator on at

Like (0)

Report

RE: Item numbers more than 20 Characters

There really is no solution to this. In BC SaaS you can not extend the primary key on the item table to a length of more than 20 characters. So if the customer requires longer item no. than 20 characters. Business Central is not the system for them.
SMS 338 on at

Like (0)

Report

RE: Item numbers more than 20 Characters

Bumping this thread...

Anyone have any methods they have used to handle this situation? We have a GP client ready to migrate, but due to this issue

may look elsewhere.
Suggested answer

Stefano Demiliani 37,166 Most Valuable Professional on at

Like (0)

Report

RE: Item numbers more than 20 Characters

On SaaS, you cannot modify standard fields. In a cloud environment, you're not alone :)
Claus Macali.dk 997 on at

Like (0)

Report

RE: Item numbers more than 20 Characters

Thanks Stefano,

I can seee their also is the item cross refence field Item number , can this field be extended
Suggested answer

Stefano Demiliani 37,166 Most Valuable Professional on at

Like (0)

Report

RE: Item numbers more than 20 Characters

This is not possible. First: you cannot change a standard field. Second: No. is the primary key for the Item table.

You can create a custom new field (length = 50) and then use this field for your customer, but the Item table primary key must continue to be 20 characters.
Claus Macali.dk 997 on at

Like (0)

Report

RE: Item numbers more than 20 Characters

Thanks Jerome, got it

If so, perhaps someone has a soloutions for this, already, seem so be a hard one to start from start
jerome77 on at

Like (0)

Report

RE: Item numbers more than 20 Characters

Hi

Changing length is possible with developpers, but it is huge work as many objects will need to be adjusted as well. I would not recommend that at all. Maybe you can workaround with description field. Or create a new field to handle that….

That would be my recommendation here

Kind regards

Jerome