INVENTORY CONTROL SETUP / ENABLE MULTIPLE BINS – TWO DIFFERENT BIN FIELDS NOT SAME LENGTH

(0) Share

Report

Posted on by Community Member

Hi,

I am using GP 10.0 and I would like to switch to “Enable Multiple Bins”. All my Bin numbers are stored in the “Item Quantities Maintenance” window under the BIN field. Now, this field is called “BINNMBR” from the IV00102 table and the Data type is STR20.

I need to enable the multiple bins function and when I follow the instructions it is mention that I first have to create all the bins in the Bin/Site Maintenance window. The bin field of that window is called “BIN” and it is a STR15 data type. The conversion process will then map the old BINNMBR field with the new BIN field.

Because I had bin numbers with 20 digits, when importing all my bins in the new BIN field it trunks the last 5 digits. I was able to change all the BIN fields length in the database to CHAR(21) but I cannot change the Bin/Site Windows field to STR20 data type.

I find this problem really stupid. If I do not find a solution I will have to change the complete bin numbers structure and therefore reprint all my Bar Code stickers on my store shelves.

I am really desperate. Does someone have a solution?

Thanks

Patrick

*This post is locked for comments

I have the same question (0)

All responses (3)

Answers (1)

babubaskaran@outloo... 12 on at

Like (0)

Report

Hi Patrick,

are you saying you have increase the size of the field in the BIN table in the database.

Was this reply helpful? Yes No
Verified answer

Mahmoud Saadi 32,738 on at

Like (1)

Report

You simply cannot change the field size from the SQL level, it is not only a database matter. There is a dexterity level included as well defining the field type and length.

Was this reply helpful? Yes No
L Vail 65,271 on at

Like (0)

Report

Hi Patrick,
Heed the advice of Mahmoud. Changing the field attributes directly from SQL will break Dynamics. Even if it seems to work for a little while, I guarantee you that it will crash and burn eventually. Looks like it's time to renumber the bins.

I do feel your pain. I had to go through this once a few years ago and it was not the best time I'd ever had on a weekend. Like you, I wondered why one of the fields was 15 chr and the other one was 20. If you have the time, go to Microsoft/connect and recommend the fields be changed to 20 chrs.
Kind regards,
Leslie

Was this reply helpful? Yes No