Validating AP/AR Accounts Balances before Releasing Imported Invoices

Hi There,

If you ever was involved in any implementation project and data migration process you have seen how complicated is to validate data after migration.
It is especially important if you have documents that have to be released – if you release wrong document than there is now way to change document anymore and you have to reverse and create it again, that basically litteres documents history.

documents history acumatica
Validating AP AR Accounts Balances before Releasing Imported Invoices

Ok, we can see the problem, but is there any way to validate balances before releasing of the documents to minimize number of errors?

When I have faced that problem, I have tried to find a solution and basically have found it with Generic Inquiries and Pivot tables.

So I have followed that scenario:

  1. Import all AP/AR Invoice to Acumatica on Hold
  2. Created 2 Generic Inquiries that get AP and AR invoices with following fields: Type, Ref Number, Branch, AP/AR accounts, Amount in Base Currency, Customer/Vendor, Class and Date
  3. Than I have create a Pivot Table based on that GI where I have accounts as columns and document types as rows
Pivot Table based onGI
Validating AP AR Accounts Balances before Releasing Imported Invoices

Total on that report give me total amount that would be recorded on AP/AR account after releasing.
Basically using that report I can reconcile AP/AR accounts with Trial balance even before releasing of them.

Here is Pivot Table definition

Validating AP AR Accounts Balances before Releasing Imported Invoices
Validating AP AR Accounts Balances before Releasing Imported Invoices

And GI definition:
https://gist.github.com/smarenich/384418ee5d2ffe0972dfa8117b98bef0

Have a fast data migration.

2 Replies to “Validating AP/AR Accounts Balances before Releasing Imported Invoices”

  1. Hi Sergey,

    I am working on Acumatica 2018 R1. I am getting issue with the Project Balances. I want to make my “Assets AR” Actual Amount to 0 after my invoice released. But its getting added on my Assets AR Actual Amount as shown in image as :-
    https://www.dropbox.com/s/lti5aoom4bm9yw3/ProjectBalance.JPG?dl=0
    I made some research on this founded it can be done using Allocation Rules. I have used TMR rule. My allocation rules looks like following image:-
    https://www.dropbox.com/s/fwp5capi6kk7lvt/AllocationRules.JPG?dl=0

    If there is any other solution or reference please let me know.
    Thanks in Advance,
    Vikas

Leave a Reply

Your email address will not be published. Required fields are marked *