You’re offline. This is a read only version of the page.
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
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
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.
Hi Patrick,
are you saying you have increase the size of the field in the BIN table in the database.
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
#1
André Arnaud de Cal...
291,219
Super User 2024 Season 2
#2
Martin Dráb
230,056
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (
