AUGForums.com

An Acumatica User Group

  • Forums
  • Podcast
  • Blog
  • Rolodex
  • Login
  • Start Here
  • Consulting
  • Courses
  • Register

General Ledger Drillback

April 2, 2014 by Tim Rodman

Recently I was working on a Purchases Clearing reconciliation as a favor to the Controller at my company. It wasn’t a very fun project, but we needed to make sure that the Purchases Clearing account agreed to the General Ledger so our auditors would be happy. I was asked by the Controller to help out and so I went to work.

In Sage 500 ERP, the individual debit and credit transactions to the General Ledger maintain a link back to the source transaction that they came from. For example, if you post an Accounts Payable Invoice, the individual debit and credit transactions that get created in the General Ledger maintain a link back to the Accounts Payable Invoice in the Accounts Payable module. This allows you to go into a screen that lists General Ledger transactions, select an Accounts Payable Invoice debit/credit, and click a button to have Sage 500 ERP automatically open the related invoice screen. It’s a nice feature and I thought that I would be able to leverage it to help me reconcile the Purchases Clearing account to the General Leger. HOWEVER, I quickly discovered that the link back the Accounts Payable Invoice is only to the invoice itself, not to the specific line on the invoice. So, if there were five lines on the invoice which generated five General Ledger transactions, each of the five General Ledger transactions would have the same reference value, that of the Accounts Payable Invoice (but not the specific line).

Eventually, I had to group my Purchases Clearing transactions by day and compare them to the General Ledger (also grouped by day) in order to do the reconciliation. It would have been nice if I had the link back to specific lines because I could have reconciled things by Purchase Order Line level instead of by day. But, alas, the world of ERP isn’t perfect and many times you are forced to choose the best option available, even if it isn’t the most elegant.

Now, this is a post on an Acumatica blog so I should probably say something about Acumatica. This little reconciliation project that I did got me wondering how I would have approached this in Acumatica. So, I took a look at the General Ledger table that holds the debits and credits. I was very pleased to find TWO relevant columns. Not only does Acumatica store the header information (in the GLTran table). It also stores the line information (in the GLTran table). So, in my example above, it would not only have stored the Accounts Payable Invoice, but also the specific LINE in the Accounts Payable Invoice that triggered the individual debit/credit to be posted to the General Ledger. I haven’t looked at this specifically for Purchase Order receipts, but it definitely looks promising.

Filed Under: Acumatica Learning Tagged With: Acumatica, Acumatica Blog, Acumatica Training, Acumatica vs. Sage 500, General Ledger, Purchase Order, Purchases Clearing, Reconciliation

By using this website, you agree to our Terms of Use (click here)

Online Members

Recent Blog Posts

  • EP 38: From Welder to Consultant, Nick Savage-Mady on his journey with Acumatica and MYOB Advanced (Podcast) January 21, 2021
  • Acumatica Reporting Tools Consulting January 19, 2021
  • EP 37: Jody Lorincz, IT Manager at MHR Brands, sharing his Acumatica Customer Story (Podcast) January 13, 2021
  • EP 36: What Motivates ERP Veteran Nicole Ronchetti To Participate in Acu-Connect (Podcast) January 8, 2021
  • Acumatica and Scanco WMS – A Cautionary Tale for ISVs January 6, 2021
Acumatica Learning Resources

Recent Forum Posts

  • RE: Popup screen fields not being auto populated

    Are you clicking the SEND button in both scenarios or t...

    By Tim Rodman, 4 hours ago

  • Legal Name?

    I am trying to get the Legal name of a company listed i...

    By Chip Fritsch, 5 hours ago

  • RE: Kensium Shopify versus Acumatica Shopify

    @garenmardirossian I have not but I am interested in hi...

    By Carl Brooks, 22 hours ago

  • RE: Kensium Shopify versus Acumatica Shopify

    Have you also seen Biz-Tech Services Shopify Connector?

    By Gary Mardirossian, 1 day ago

  • RE: ACH postings in Acumatica

    ACH payments are better managed via the batch payments ...

    By Michael.Barker, 1 day ago

  • RE: Adding bill description on check stub

    @jswartz Yes, that does make sense, and yes without tho...

    By Chip Fritsch, 1 day ago

  • RE: Adding bill description on check stub

    @cfritsch Chip thank you for that. I did stumble upon t...

    By Jswartz, 1 day ago

  • RE: Create payment

    Hi @cndr, I think you’ll have better luck with this p...

    By Tim Rodman, 1 day ago

  • RE: Changing how fields are displayed on mobile app

    So I was able to figure this out in case we are not the...

    By jvandonkersgoed, 1 day ago

Recent Tweets

Terms of Use & Disclaimers :: Privacy Policy

Copyright © 2021 · AUG Forums, LLC. All rights reserved. This website is not owned, affiliated with, or endorsed by Acumatica, Inc.