Skip to main content

Notifications

Announcements

No record found.

Microsoft Dynamics GP (Archived)

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

(0) ShareShare
ReportReport
Posted on by Microsoft Employee

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.

 Bin2.jpg

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

  • L Vail Profile Picture
    L Vail 65,271 on at
    RE: INVENTORY CONTROL SETUP / ENABLE MULTIPLE BINS – TWO DIFFERENT BIN FIELDS NOT SAME LENGTH

    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

  • Verified answer
    Mahmoud Saadi Profile Picture
    Mahmoud Saadi 32,738 on at
    RE: INVENTORY CONTROL SETUP / ENABLE MULTIPLE BINS – TWO DIFFERENT BIN FIELDS NOT SAME LENGTH

    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.

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

    Hi Patrick,

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

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

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Tips for Writing Effective Verified Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,391 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,445 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans