Skip to main content
Answer

Reconcile IN subledger and GL

  • June 17, 2025
  • 3 replies
  • 49 views
B
Varsity I
Forum|alt.badge.img

Good day community

Can anyone assist me by telling me which tables are relevant to write GI in order to balance IN subledger and GL?

Suddenly the subledger & GL have gone out of balance and the difference appears to be growing. There are hundreds of transactions so I am struggling to do this using a normal recon process. I really need to generate a GI to help but can’t figure out which tables to use.

If anyone has an existing GI or can at least advise which tables to use I would be very grateful.

Many thanks in advance.

Best answer by BarbaraPietersen23

Thanks for your input. I have done all these things. Don’t worry - I managed to find a GI that works.

 

    L

    3 replies

    L
    Jr Varsity I
    Forum|alt.badge.img

    Hello ​@BarbaraPietersen23 ,

    Historical Inventory Balance or Historical Inventory Valuation report should balance to GL inventory accounts, without looking at individual tables or creating a GI.

    If the above reports do not balance to the inventory account(s), use Account Details screen in GL to look for transactions posted to Inventory accounts that did not originate from Inventory modules.

    Find out when the GL last balanced to the Inventory subsidiary ledger, and work forward from that point with adjustments.  

    Laura

     

    Chris Hackett
    B
    Varsity I
    Forum|alt.badge.img

    Thanks for your input. I have done all these things. Don’t worry - I managed to find a GI that works.

     

    Chris Hackett
    Chris Hackett
    Community Manager
    Forum|alt.badge.img
    • Chris Hackett
    • Acumatica Community Manager
    • June 20, 2025

    Hi ​@BarbaraPietersen23  - Would you be able to share what worked for you?

    Chris ~ Let us know how we're doing: https://forms.office.com/r/xmJUdZ1QE5 - A member helped you, please *Like* their post. A member provided an answer to your question, please mark it as *Best Answer*.
    Terms & ConditionsCookie settingsAccessibility statement
    About Acumatica ERP system
    Acumatica Cloud ERP provides the best business management solution for transforming your company to thrive in the new digital economy. Built on a future-proof platform with open architecture for rapid integrations, scalability, and ease of use, Acumatica delivers unparalleled value to small and midmarket organizations. Connected Business. Delivered.
    © 2008 — 2024  Acumatica, Inc. All rights reserved