By using this website, you agree to our Terms of Use (click here)
Dear All,
Was wondering as I go through the threads here and Acumatica's documentations. There are 2 things that I learned, i.e.
a. Acumatica allows posting of control account in the journal.
b. Acumatica does not provide db schemas.
Currently using AP Aged Period Sensitive report vs GL Summary Trial Balance periodically to check that AP=GL on a monthly basis.
My questions:
1. Are there any specific ways to reconcile the subsidiary modules to GL in Acumatica?
2. Can we create Generic Inquiries to expedite reconciliation? Having both GL and subsidiary module sude-by-side
Thanks in advance.
Hi Saiful,
Yes, you are correct on a and b unfortunately.
Regarding your questions:
1. I think it depends a little bit on the module, but, in general, you run the two reports to see if they agree. If they don't and the reason isn't obvious, then I'd recommend what you already suggested in question 2.
2. I would definitely do Generic Inquiries and even take it a step further to compare the two Generic Inquiries in Excel using OData with a Pivot Table. I think that would allow you to quickly zoom in on the problem areas.