Sage 100

 View Only

  • 1.  Inventory Valuation - to include, or not include zero's

    Posted 02-09-2022 14:00
    Sage 100 2016 Advanced - The check box on the IM Valuation report to 'Print Zero Balances' is doing something I think is just plain weird ... This client usually checks this box, but this month for some reason, they ran the report (always for all items), both ways and get a valuation difference of exactly $16K ... I am trying to understand how and why including or excluding zero balances would ever change the total this report.  What am I missing?  BTW, if you exclude zero's, it ties perfectly to GL

    ------------------------------
    Randy Marion
    ------------------------------


  • 2.  RE: Inventory Valuation - to include, or not include zero's

    Posted 02-09-2022 16:24
    They must have items with a 0 qty on hand that have a value.

    ------------------------------
    Mary Jo Krueger
    Senior Software Consultant
    CLA (CliftonLarsonAllen LLP)
    Appleton WI
    920-996-1176
    ------------------------------



  • 3.  RE: Inventory Valuation - to include, or not include zero's

    Posted 02-10-2022 16:56
    I agree with @Mary Jo Krueger.  I am sure by now you have identified the bad boy records.  Now to explain to the client why they just lost 16K of inventory value.
    ​

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

    Original Message


  • 4.  RE: Inventory Valuation - to include, or not include zero's

    Posted 02-10-2022 16:59
    I think around v2018-2019 Sage fixed inventory reports (valuation / TB) to show zero quantity with value... data which was hidden in previous versions.

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

    Original Message


Related Content