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.
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:
- Import all AP/AR Invoice to Acumatica on Hold
- 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
- Than I have create a Pivot Table based on that GI where I have accounts as columns and document types as rows
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
And GI definition:
https://gist.github.com/smarenich/384418ee5d2ffe0972dfa8117b98bef0
Have a fast data migration.
Hi Sergey,
I have created Import Scenario. It is working fine with new record import.
But, if i trying to update existing data with import scenario, it is not working.
Please suggest.
Thanks,
Gaurav Katiyar
Gaurav,
To update the existing record you need to provide the primary key. did you do so?
Hi Sergey,
I have created Import Scenario. It is working fine with new record import.
But, if i trying to update my scenario is not working.
Please suggest.
Thanks,
Gaurav Katiyar
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
Hi Vikas, could you please create a support case on Acumatica Portal – http://portal.acumatica.com
Our support team will help you to review setting.