Sage 100

 View Only
  • 1.  Scanco Multi-Bin Inventory Reconciliation. Looking for documentation.

    Posted 06-20-2024 09:26

    After a night of cleaning the customer's inventory with all those inventory utilities, so the Sage files match each other (AND I ran the M-Bin Item reconciliation), a few days later the client ran M-Bin Item reconciliation for a lot number item in one warehouse and it changed all but one Sage files to match the multi bin number.  I thought Sage "ruled" and MBin would change to match Sage. 

    In this case, customer's products are mostly lot, but they have some FIFO and Standard Cost.   I've been asking Scanco for over a week for written documentation on how to run the utility and what the options/consequences are for each option.  I've run the utility a number of times without issue, but something written would be nice.  Does anyone have anything?

    The first line of the utility asks for, to me, what bin to use for lot variances.

    The second line has two choices--Apply to Lot and Apply to Stock.  Is this line optional?  When would you choose one vs the other?  I'd assume you choose Lot for the lot items and Stock for the non lot numbers.  We want M-Bin to change to match Sage, not the other way around.

    Thanks,

    Roberta



    ------------------------------
    Roberta Chase
    Enterprise Software Consultant--Sage 100, Crystal Reports, Sage Intelligence, FAS, Starship
    CompuData, Inc.
    Philadelphia, PA 19154
    215-969-1000, ext. 277
    ------------------------------


  • 2.  RE: Scanco Multi-Bin Inventory Reconciliation. Looking for documentation.

    Posted 06-20-2024 19:09

    Do not select the Apply to Stock, this changes the Sage quantity on hand to match the MB quantity on hand.  And at least in v2020, does not write a record to IM_TransactionHistory or to the GL, causing your inventory to become more out of balance. This was reported to Scanco but not sure if it has been repaired or not. Additionally when this utility run it does not write to the activity log.



    ------------------------------
    Lisa Dion
    Vrakas/Blum Computer Consulting, Inc. ldion@v-bcc.com
    ------------------------------



  • 3.  RE: Scanco Multi-Bin Inventory Reconciliation. Looking for documentation.

    Posted 06-24-2024 09:47

    Thanks so much, Lisa.  Apparently, it's still not fixed.

     

    Scanco told me also not to choose "apply to lot" as that is part of some unfinished custom code.

     

    Roberta Chase, CompuData, Inc.

    roberta.chase@compudata.com

    215-969-1000,,277 or 800-223-3282,,277

    https://www.compudata.com/online-support/

     

    Roberta Chase
    Enterprise Software Consultant
    roberta.chase@compudata.com
    215-969-1000 ext. 277
    CBIZLogo_CompuData_2C (002).png
    Work Smarter... Together

    CBIZ CompuData • compudata.com • 325 Chestnut St, Ste 700 • Philadelphia • PA • 19106