Sage 100

 View Only
Expand all | Collapse all

Standard Cost valuation but still have ability to track Serial or Lot number.

  • 1.  Standard Cost valuation but still have ability to track Serial or Lot number.

    Posted 08-23-2021 23:41
    Anyone know of enhancement to cost by standard cost but still track lot/serial numbers?

    ------------------------------
    Jeff Schwenk
    FORMER 90M Board Member -140,000,000 is a TERRIBLE thing to waste!!!
    Bottomline Software, Inc.
    Waynesboro VA
    540-221-4444
    ------------------------------


  • 2.  RE: Standard Cost valuation but still have ability to track Serial or Lot number.

    Posted 08-24-2021 00:21

    Jeff

     

    I do not believe it exists (both Sage X3 and Sage Intacct have that feature as a fyi).

     

    I have a feeling it would be an expensive enhancement.

     

     

    Thank you,

     

    Douglas Luchansky

    ACI Consulting

    p 714.282.0378 ext. 302    f 714.282.0235

     

    douglas@ACIconsulting.com

     

     

     

     






  • 3.  RE: Standard Cost valuation but still have ability to track Serial or Lot number.

    Posted 08-24-2021 00:51
    Here's a link to an enhancement that allows for lot / serial inventory by standard or average cost.

    https://www.dsdinc.com/enhancements/marketplace/products/im-1271-serialized-items-with-average-costs

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



  • 4.  RE: Standard Cost valuation but still have ability to track Serial or Lot number.

    Posted 08-24-2021 07:38
    Thanks @dougs .  This might do it.  Just wondering if it works with BOM's , PO's etc as description just indicates IM transactions.  Do you have any clients using it?


    ------------------------------
    Jeff Schwenk
    FORMER 90M Board Member -140,000,000 is a TERRIBLE thing to waste!!!
    Bottomline Software, Inc.
    Waynesboro VA
    540-221-4444
    ------------------------------



  • 5.  RE: Standard Cost valuation but still have ability to track Serial or Lot number.

    Posted 08-24-2021 08:14
    @Jeff Schwenk  Download the user guide.  It has a lot more info.  I believe you can also download and install the program  for a few days.​ 

    I don't have anyone using it I just remembered seeing it at one time.

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



  • 6.  RE: Standard Cost valuation but still have ability to track Serial or Lot number.

    Posted 08-24-2021 09:48
    I had a customer using it, they didn't have BOM's and wanted PO's at actual cost.  They wanted the Sales Invoices to be at average along with any Inventory Transactions and it worked well for them.

    ------------------------------
    Nancy Hanson
    Blytheco LLC
    Eagan MN
    ------------------------------



  • 7.  RE: Standard Cost valuation but still have ability to track Serial or Lot number.

    Posted 08-24-2021 08:25
    One of the gaps in 100.  Sage 500 had/has this feature.  Another related gap is losing track of lot/serialization when drop-shipping through PO.

    ------------------------------
    alan niergarth
    Velosio LLC
    ------------------------------



  • 8.  RE: Standard Cost valuation but still have ability to track Serial or Lot number.

    Posted 08-24-2021 09:47

    Jeff,

     User manual for reference: https://www.dsdinc.com/enh/downloads/I271700.pdf

     First please note: The described feature was developed for a specific client to its specifications and may not conform to generally accepted Sage 100 standards and procedures. These features may or may not benefit you in your application of Sage 100.

     The I/M Transaction Update, I/M Physical Count Variance Register update, P/O Receipt Register update, P/O Return of Goods Register update, S/O Sales Journal update, B/M Production Entry Register and Disassembly Register updates, and W/O Transaction Journal update will all use the 'Valuation Method' Cost.

     All reports that use the Unit Cost from the Item Cost Detail file will have a zero unit cost. The Inventory Valuation Report is the exception if the setup option to use the Average/Standard Cost instead was checked.

     Thanks!

     Enhancements Department



    ------------------------------
    Jeff Schwenk
    FORMER 90M Board Member -140,000,000 is a TERRIBLE thing to waste!!!
    Bottomline Software, Inc.
    Waynesboro VA
    540-221-4444
    ------------------------------



  • 9.  RE: Standard Cost valuation but still have ability to track Serial or Lot number.

    Posted 08-24-2021 13:24
    We created Lot/Serial UDFs for StdCost Valuation Items.  Had to tweak the BM Production Entry update program to track both completed Item and relieved component Item UDFs.

    ------------------------------
    Bob Pfahnl
    Manager - Silicon Valley
    DSD Business Systems
    San Diego CA
    408-641-0922
    ------------------------------



  • 10.  RE: Standard Cost valuation but still have ability to track Serial or Lot number.

    Posted 08-26-2022 10:40
    Edited by Eric Lunceford 08-26-2022 10:48
    Hey @Jeff Schwenk @Doug Higgs

    Did you end up using this? How did it work out?​

    ------------------------------
    Eric Lunceford
    First Mate Business Solutions
    Oklahoma City, OK
    877-880-8960
    ------------------------------



  • 11.  RE: Standard Cost valuation but still have ability to track Serial or Lot number.

    Posted 08-26-2022 10:56
    @Eric Lunceford  I have never used it.... Just remembered running across the DSD enhancement so thought it might be worth looking into.​

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