Sage 100

 View Only

  • 1.  Inventory Trial Balance vs. GL Inventory account balance

    Posted 02-08-2019 16:07
    Dear Minds,
    Followed Sage's KB on this, but still can't get an explanation why IM Trial Balance is 2% higher than Inventory GL acct balance.
    OR how to adjust to make them match. 
    Sage KB mentions rounding, putting Inventory GL account in wrong setup, etc.
    Client not satisfied with rounding producing a 2% difference.

    Any other ideas?

    ------------------------------
    Lee Graham
    Friendly Systems, Inc.
    ------------------------------


  • 2.  RE: Inventory Trial Balance vs. GL Inventory account balance

    Posted 02-08-2019 16:19
    Print the DTR from GL to see if something is only half-posted.
    Look for direct GL postings to the control account(s), which will not be reflected in IM reports.

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



  • 3.  RE: Inventory Trial Balance vs. GL Inventory account balance

    Posted 02-08-2019 16:35
    Does the IM Valuation report balance??

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

    Original Message


  • 4.  RE: Inventory Trial Balance vs. GL Inventory account balance

    Posted 02-13-2019 16:04
    Inventory Trial Balance and Inventory Valuation Reports balance.
    They don't match the GL Acct for Inventory.
    There was one GL Journal Entry to Inventory, but doesn't account for $19,446.23 difference.?? G/L total is 2.06% lower.

    All DTR's - updated.
    Checked all the setups.?? OK.

    They do have a lot of fractional quantities and prices.
    Rounding totals difference would logically be less that 2% for the totals though, no?

    It's GL Transaction file vs. Inventory Transaction file discrepancies.

    Lee
    --

    Friendly Systems, Inc.

    Sage 100 (Mas90/200), Sage 300 (Accpac), SageCRM
    Visit us on the web at www.friendlysystems.com
    Office:?? 678.273.4010 ext 4
    Mobile: 404.202.9065
    Fax:?????????? ??678.273.4012
    See our blog at www.friendlysystems.com/blog



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

    Does the IM Valuation report balance??

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


  • 5.  RE: Inventory Trial Balance vs. GL Inventory account balance

    Posted 02-13-2019 16:28
    If I am forced to troubleshoot, I query GL_DetailPosting for the IM control account, grouped by source journal and journal #.  Then compare that to a similarly grouped result set from IM_ItemTransactionHistory (Extended Cost by journal).  The differences should stand out allowing you to dig deeper into examples.

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

    Original Message


  • 6.  RE: Inventory Trial Balance vs. GL Inventory account balance

    Posted 02-09-2019 09:40
    Check /MISC code GL account setup and do a GL Account inquiry on the inventory accounts transactions tab and sort by journal.  If you see any postings from journals other than IM, SO, PO, WO, BM they could be the cause.

    ------------------------------
    Bernie Lehman
    Lehman Wesley & Associates
    ------------------------------



  • 7.  RE: Inventory Trial Balance vs. GL Inventory account balance

    Posted 02-13-2019 17:08
    When did it last reconcile?  Is this a one month variance?  Months?  Years?

    ------------------------------
    Bob Pfahnl
    DSD Business Systems
    ------------------------------

    Original Message


  • 8.  RE: Inventory Trial Balance vs. GL Inventory account balance

    Posted 02-14-2019 11:22
    I tried GL detail report.?? Found a single JE entry, but not a major factor.

    I will be checking both reports historically to look for unequal period amounts.

    Thanks,
    Lee
    --

    Friendly Systems, Inc.

    Sage 100 (Mas90/200), Sage 300 (Accpac), SageCRM
    Visit us on the web at www.friendlysystems.com
    Office:?? 678.273.4010 ext 4
    Mobile: 404.202.9065
    Fax:?????????? ??678.273.4012
    See our blog at www.friendlysystems.com/blog



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

    When did it last reconcile?  Is this a one month variance?  Months?  Years?

    ------------------------------
    Bob Pfahnl
    DSD Business Systems
    ------------------------------


  • 9.  RE: Inventory Trial Balance vs. GL Inventory account balance

    Posted 02-14-2019 08:11
    Some of this advice you have already... Confirm IM Valuation ​balances to IM TB as of today's date.  Confirm GL DTR is updated.  Run the GL Transaction Detail Report for Source Type General Ledger Only and confirm no one did a Journal Entry using an IM type transaction code (i.e. a JE using IA or IP as the transaction Source).  Check all the Product Lines and confirm the "inventory GL Account" is "only" in the inventory field, and not in an adjustment field also.  Confirm no AP Transactions posted to inventory, my experience is that they are notorious to buy a truckload at a "sale" and post the invoice through AP. Check your Miscellaneous items for the inventory account, I don't recommend using the Inventory Control Account in /Misc Items; instead set up a different inventory account as a pass through for this purpose.  Check your * Misc Item GL accounts in the setups, and make sure the Inventory Control Account is not used.  Monitor the difference on a day by day (or weekly) bases to see if it "moves" then check the transactions since the last change to see if you can pinpoint what causes the issue.

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



Related Content