Sage 100

 View Only
  • 1.  Scanco - Multi-Bin - Bin Location Name Change

    Posted 10-24-2024 12:29

    How do you change the name of a bin location when using Scanco Multi-Bin?  the bin location has inventory quantities on hand.



    ------------------------------
    Doug Higgs
    Midwest Commerce Solutions, Inc
    (312) 315-0960
    Chauffeur, Chef, and Personal Assistant to Sprinkles
    ------------------------------


  • 2.  RE: Scanco - Multi-Bin - Bin Location Name Change

    Posted 10-24-2024 13:05

    Do you mean bin location is defined as 123456 and you now want to call the same physical location Doug24?



    ------------------------------
    Jeff Schwenk
    Owner
    Bottomline Software, Inc.
    Waynesboro VA
    (540) 221-4444
    ------------------------------



  • 3.  RE: Scanco - Multi-Bin - Bin Location Name Change

    Posted 10-24-2024 13:09

    Yes.  They want to change the names of 250 or so locations.  Most locations contain serialized inventory items.  I am thinking I may have to export all of the inventory detail to Excel, do a physical count to get all of the quantities to 0, create the new locations, then import the quantities into physical count or transaction entry to the new location.  I am hoping there may be another more efficient way.



    ------------------------------
    Doug Higgs
    Midwest Commerce Solutions, Inc
    (312) 315-0960
    Chauffeur, Chef, and Personal Assistant to Sprinkles
    ------------------------------



  • 4.  RE: Scanco - Multi-Bin - Bin Location Name Change

    Posted 10-24-2024 14:42

    IMO, your export/import process is what you will need to do.  Since the bin location "name" is the key field, there is not an easy way to rename them.  



    ------------------------------
    Rebekah Veuger
    President
    ClearPoint Consulting Group
    619-997-1627
    ------------------------------



  • 5.  RE: Scanco - Multi-Bin - Bin Location Name Change

    Posted 10-24-2024 15:06

    Thanks @Rebekah Veuger  I thought maybe there was a utility or another method I didn't know about.



    ------------------------------
    Doug Higgs
    Midwest Commerce Solutions, Inc
    (312) 315-0960
    Chauffeur, Chef, and Personal Assistant to Sprinkles
    ------------------------------



  • 6.  RE: Scanco - Multi-Bin - Bin Location Name Change

    Posted 10-24-2024 19:38

    I am not sure what the bin transfer process is like.  Upload the new bins, figure out what is in those bins, then import via the bin transfer program.  Serial numbers really make a mess of things



    ------------------------------
    Jeff Schwenk
    Owner
    Bottomline Software, Inc.
    Waynesboro VA
    (540) 221-4444
    ------------------------------



  • 7.  RE: Scanco - Multi-Bin - Bin Location Name Change

    Posted 10-24-2024 19:43

    Yes.  The "what's in the bins" is in the IM_140MBItemLocationQuantity table.  I was thinking of freezing all the inventory and then updating the physical count with all of the quantities at 0.. then importing the relavant  IM_140MBItemLocationQuantity fields to the IM_140MBPhysical table (Physical count).  Do you think doing a bin transfer is a better idea?  If so, do you know what table(s) to use for a bin transfer?



    ------------------------------
    Doug Higgs
    Midwest Commerce Solutions, Inc
    (312) 315-0960
    Chauffeur, Chef, and Personal Assistant to Sprinkles
    ------------------------------