Sage 100

 View Only

  • 1.  Lot/Serial Tracking with Standard Costing

    Posted 02-02-2023 18:09
    I feel like I have been down this road before but unable to locate where the spot is.

    Client was acquired by company running JD Edwrds at the corporate level.  They have asked client to use standard inventory valuation but client is unable as they need the lot tracking functionality.

    Is there an enhancement in the SageVerse that provides this functionality?

    TIA

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


  • 2.  RE: Lot/Serial Tracking with Standard Costing

    Posted 02-02-2023 19:13
    Maybe this?
    I271 - IM-1271 Serialized Items with Average Costs
    https://www.dsdinc.com/enhancements/marketplace/products/im-1271-serialized-items-with-average-costs

    This DSD Extended Solution allows lot/serial valued Inventory items to be received into and relieved from the inventory transaction file at average or standard cost.

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



  • 3.  RE: Lot/Serial Tracking with Standard Costing

    Posted 02-03-2023 01:09
    Thanks @Doug Higgs for this find.  It would be nice if selected Items could be enabled, Finished Goods stay L/S Valuation while components could be Avg/Std.​

    ------------------------------
    Bob Pfahnl
    Manager - Silicon Valley
    DSD Business Systems
    ------------------------------

    Original Message


  • 4.  RE: Lot/Serial Tracking with Standard Costing

    Posted 02-03-2023 07:31
    if you only want it for certain items, maybe you could add a script to purchase order entry to pull in Standard cost during purchase order entry.
    • Script would need to run after Sage pulls in the last cost and replace it with Standard cost. But only for certain product line or if UDF is flagged on the item. 
    • Use custom office to disable unit cost field in PO Entry so the user can't change it.
    • If you need the PO to print the "true" cost
      • Add a UDF that the user can manually type in that cost.
      • Edit the PO form code to print that cost in place of the unit cost field.
    • During Receipt of Goods user would not change that standard cost so item gets received at Standard.  
    • During Receipt of Invoice, user would invoice the correct unit cost and there would be a purchase variance posting. 
    You may need to watch out for partially invoiced lines. I discovered that when you invoice part of a PO line and change the unit cost, Sage updates the original PO with that new unit cost. So subsequent receipts would come in at the wrong cost. If your client partial receipt and receipt of invoice, you may need another script in ROG screen. 

    Or maybe DSD could quote you that change?

    ------------------------------
    David Overholt
    DWD Technology Group
    ------------------------------

    Original Message


  • 5.  RE: Lot/Serial Tracking with Standard Costing

    Posted 02-03-2023 07:04
    Check DSD enhancements. I think they may have this.

    ------------------------------
    Jacqueline Hoyte
    Director of Client Services
    Integrated Data Technology, Inc.
    ------------------------------



  • 6.  RE: Lot/Serial Tracking with Standard Costing

    Posted 02-03-2023 09:22
    I have a customer working with serialized items.
    They are 100% created from BOM production entry, where the components are standard cost.

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



Related Content