Sage 100

 View Only

  • 1.  Quantity Committed on Lot Items

    Posted 07-20-2025 11:22

    A couple of times a month the user allocates a quantity for a lot item in Shipping Data Entry, then realizes there was an issue with the order so they delete the entry.  When they try and ship the order later the lots are not available because they are committed in the IM_ItemCost table.  They contact me and I set the quantity committed field to 0 so the order can ship.

    Any ideas for what is causing this?



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


  • 2.  RE: Quantity Committed on Lot Items

    Posted 07-21-2025 10:51

    The transaction level delete doesn't undo the line allocation sometimes.  They can either remove the allocation before deleting the invoice, or run rebuild sort files on IM afterwards.



    ------------------------------
    Kevin Moyes
    Technical Systems Analyst
    Munjal White Consulting Co.
    Toronto ON
    ------------------------------



  • 3.  RE: Quantity Committed on Lot Items

    Posted 07-21-2025 11:04

    Thank you @Kevin Moyes !



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

    Original Message


  • 4.  RE: Quantity Committed on Lot Items

    Posted 07-21-2025 11:06
    Edited by Wayne Schulz 07-21-2025 11:07

    This is one of the the reasons I suggest to Sage that it would be handy to have the capability to run rebuild sort files after hours.

    The reaction I get from Sage each and every time I annoyingly ask this question...



    ------------------------------
    Wayne Schulz
    wayne@s-consult.com
    Schulz Consulting
    (860) 516-8990
    CT
    ------------------------------



  • 5.  RE: Quantity Committed on Lot Items

    Posted 07-22-2025 09:59

    I think John's actual reaction is "Hell, no!" 

    @Alnoor Cassim was working on that as a project at one point.



    ------------------------------
    Robert Wood
    DDF Consulting Group
    Ocala FL
    (352) 615-5898
    ------------------------------

    Original Message


  • 6.  RE: Quantity Committed on Lot Items

    Posted 07-22-2025 11:56

    Alternatively to having to rebuild the IM sort files after hours:  Fix the program so the transaction level delete always removes the line allocation.  It's only been an issue for forty years so maybe Sage can make it a small priority to look into it. 



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

    Original Message


  • 7.  RE: Quantity Committed on Lot Items

    Posted 07-22-2025 15:25

    Indeed - the rebuild sort files is basically a "fix all our programming errors" program....



    ------------------------------
    Phil McIntosh
    Friendly Systems
    ------------------------------

    Original Message


  • 8.  RE: Quantity Committed on Lot Items

    Posted 07-22-2025 17:41

    @Doug Higgs - I refer you to @Robert Wood first line of his post.......



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

    Improving bottom lines for over 25 years!
    ------------------------------

    Original Message


Related Content