Sage 100

 View Only

  • 1.  SAGE 100 v2018 Inv Trial Balance Report shows negative(s)

    Posted 02-03-2020 08:40
    Client is running SAGE 100 STD v2018 and is reviewing year end reports. They are asking why/how can the year end Inventory Trial Balance report show some items with a year-end Quantity of zero but a year end value with a negative amount?  Is there a way to look at the activity and come up with a logical explanation?  Raw Material is using FIFO costing and Finished Goods is at Serial costing. I believe most of the questions are with Raw Material items.  Are there SAGE KB articles to review?

    ------------------------------
    Michael McDonald - Consultant
    Michael T McDonald CPA
    616-813-8887 - mike@mcdcpa.com
    ------------------------------


  • 2.  RE: SAGE 100 v2018 Inv Trial Balance Report shows negative(s)

    Posted 02-03-2020 08:44
    This can happen if a user makes an inventory transaction adjustment at a different cost than the FIFO tier cost.

    ------------------------------
    Doug Higgs
    Midwest Commerce Solutions, Inc
    (312) 315-0960
    Assistant to the Traveling Secretary
    ------------------------------



  • 3.  RE: SAGE 100 v2018 Inv Trial Balance Report shows negative(s)

    Posted 02-03-2020 08:48
    To correct it Step 1: Make a transaction adjustment:  quantity 1 and $0. unit cost, then update it.  Step 2:  After updating Step 1, make a transaction adjustment:  quantity -1 and the unit cost is the negative value, then update it.

    ------------------------------
    Doug Higgs
    Midwest Commerce Solutions, Inc
    (312) 315-0960
    Assistant to the Traveling Secretary
    ------------------------------

    Original Message


  • 4.  RE: SAGE 100 v2018 Inv Trial Balance Report shows negative(s)

    Posted 02-03-2020 09:50
    Must be data left from a previous version because this was fixed in v2018.
    A Zero quantity cost tier no longer exists with a residual value after a lot is adjusted to 00.00 through Transaction Adjustment entry.
    DE 106790 KBId 79706


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



  • 5.  RE: SAGE 100 v2018 Inv Trial Balance Report shows negative(s)

    Posted 02-03-2020 09:54

    I have seen this in 2019. A client had an overattributed tier in one warehouse and when they transferred the qty from one warehouse to the zero out negative tier, the costs were different and left a tier value with a zero qty.

     

    Thanks

     

    Avron Katz

    President

    K-Four Systems, LLC

    P: 774 233 0467 Cell: 508 380 1720

    www.kfoursystems..com  e-mail: avron@kfoursystems.com

     

     

    IMPORTANT: The contents of this email and any attachments are confidential. They are intended for the named recipient(s) only.  If you have received this email in error, please notify the system manager or the sender immediately and do not disclose the contents to anyone or make copies thereof.

    P Please consider the environment before printing this e-mail

     

     

     



    ------Original Message------

    Must be data left from a previous version because this was fixed in v2018.
    A Zero quantity cost tier no longer exists with a residual value after a lot is adjusted to 00.00 through Transaction Adjustment entry.
    DE 106790 KBId 79706


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


  • 6.  RE: SAGE 100 v2018 Inv Trial Balance Report shows negative(s)

    Posted 02-03-2020 10:22
    I've also experienced the issue with "transfers" warehouse to warehouse; leaving behind a balance.  My v2017 client no longer does transfers, instead they do two adjustments in and out of warehouses to ​eliminate the zero quantity with negative extend balance.

    ------------------------------
    Madeline Stefanou
    RKL eSolutions, LLC
    ------------------------------

    Original Message


  • 7.  RE: SAGE 100 v2018 Inv Trial Balance Report shows negative(s)

    Posted 02-03-2020 11:45
    Thanks Everyone,  I'm now reviewing Inventory Detailed Transaction (History) Report and some of the negative quantities (OVERDIST) are making sense.

    ------------------------------
    Michael McDonald - Consultant
    Michael T McDonald CPA
    616-813-8887 - mike@mcdcpa.com
    ------------------------------

    Original Message


  • 8.  RE: SAGE 100 v2018 Inv Trial Balance Report shows negative(s)

    Posted 02-03-2020 11:46
    Was it truly fixed everywhere.  The KB Kevin references says it was fixed in the 2016.5 product update regarding LOT valuations having some pennies left over when quantity is zero..  But there have been many instances where Sage "unfixes" it is subsequent release.  Perhaps this is one of those.  If you generate an IM valuation report, you might see some zero quantity tiers have some valuation dollars.  A year or so ago, @Jeff Fiddelman helped me with a QAD utility to wipe these tiers to oblivion.  Seem to do the trick.
    ​

    ------------------------------
    Jeff Schwenk
    FORMER 90M Board Member
    Bottomline Software, Inc.
    Waynesboro VA
    540-221-4444
    ------------------------------

    Original Message


Related Content