Sage 100

 View Only

  • 1.  How to Track a Lot Number

    Posted 06-12-2019 15:54
    The end user uses inventory lot valuation.  The purpose of using lot valuation is to be able to trace inventory sold back to the vendor purchase order and to notify all other customers that they may have sold inventory from the same lot to.

    The end user buys 100 of item ABC from vendor XYZ, and 200 of item ABC from vendor UVW and both purchases coincidentally have the same lot number 1234567.  It seems that Sage 100 combines the lot quantities together, so item ABC has 300 of lot 1234567 in inventory.  If they subsequently sell 50 of item ABC, lot 1234567, and 20 people that bought item ABC, lot 1234567 get poisoned, how would one determine which vendor the product was purchased from?

    ------------------------------
    Doug Higgs
    Assistant Technical Support / Building Maintenance Specialist
    Midwest Commerce Solutions, Inc
    ------------------------------


  • 2.  RE: How to Track a Lot Number

    Posted 06-12-2019 16:00
    Same item and same lot# >> there is no difference in Sage data for source vendor.  It all mixes together in the cost tier (IM_ItemCost) upon receipt.  You'd have to append a vendor designation to the lot# itself to keep things separate.

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



  • 3.  RE: How to Track a Lot Number

    Posted 06-12-2019 16:12
    @Kevin Moyes is correct. You could very well purchase additional items from a vendor with the same lot number thus there is no segmentation by vendor. When they do the receipt of goods and process the distribution, they should verify the lot does not already exist.  ​

    ------------------------------
    Therese Logeais, Technology Integrators
    ------------------------------

    Original Message


Related Content