Hi,
I’m importing trial balance . the debit and credit amounts exactly tally in the excel. but system keep showing below error. Appreciate your help.
Thanks,
Dulanjana
Best answer by vkumar
View original
Hi
Note the Credit balance is reflecting negative number. You can try the following if you prefer to use the same file :
1. Delete the existing Trail Balance (if imported and saved)
2. On the GL Preferences screen - change the Sign of Trial Balance from Normal to Reversed
3. Create a new Trial Balance and import the data once again. Check and confirm if the balances on the Trial balance match
Refer to following documentation as well:
Hope this helps,
Regards
Hi
it was really helpful & appreciate your help on that. Further I have an one issue. Appreciate if you could help.
When we import the TB , there are account balances in the Exceptions Tab. the system behavior is to generate entries to make accounts balances of exception tab to zero. How can we stop this and import the trial balance without affecting the accounts balances of the exceptions tab.
Thanks ,
Dulanjana
Hi
There is no option to avoid that functionality. The GL numbers wont match if one does try skip that process. You may elaborate the reason why you need to skip generating GL entry based on exception.
Regards,
Hi
I will elaborate the requirement.
I’m doing a testing on import first Trial balance to the system because the go live date is soon.
- Initially I created import scenarios and imported AR, AP and Inventory balances to the system using a clearing accounts since these balances should be imported through invoices and transactions.
- The I’m trying to import other account balances which should be imported as GL balances. For this purpose I’m using Trial Balance form . When I import I faced that issue , removing balances of AR ,AP Inventory & clearing accounts which were available in exceptions tab.
With the constrain I faced I think it would be better to Import the balances which should be imported as ledger balances first and then import the AR,AP and Inventory Balances. Then I can skip the issue with exception tab since there will be no balance for the tab.
and I see a solution to import the trail balance as a JV upload because I can skip the issue by this as well.
This is my first Acumatica Go live and appreciate if you could comment on my approach and better if you could suggest a better approach.
Thanks,
Dulanjana
Reply
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.