Skip to main content
Solved

Import Trial Balance - Account cannot be mapped


Hi All, when I import Interest Account (4212), the system show “account cannot be mapped”. Does it mean I cannot import the balance for this account or what’s wrong?

 

Best answer by vkumar

Hi @chidao 

The GL account may have been selected on your GL preferences screen and set as ‘YTD Net Income account’. One cannot create GL transaction to this account manually as its calculated automatically for Financial report generation.

Refer to the documentation highlighted below:

https://help-2022r1.acumatica.com/(W(3))/Help?ScreenId=ShowWiki&pageid=9fb11332-7bbb-4944-8d9e-995918abc51b

Hope this helps,

Regards,

 

View original
Did this topic help you find an answer to your question?

8 replies

Forum|alt.badge.img+11
  • Acumatica Support Team
  • 785 replies
  • May 11, 2022

Hi @chidao 

Try enter a manual journal transaction for that GL account. You may delete the batch and not release it, just to validate if the GL account exists and it does not have any restriction to use on UI. If it allows you enter a Journal transaction, the import should work. 

Hope this helps,

Regards,

 


  • Author
  • 113 replies
  • May 12, 2022
vkumar wrote:

Hi @chidao 

Try enter a manual journal transaction for that GL account. You may delete the batch and not release it, just to validate if the GL account exists and it does not have any restriction to use on UI. If it allows you enter a Journal transaction, the import should work. 

Hope this helps,

Regards,

 

HI @vkumar

Thanks for your support!

From GL, I can not find that account (4212-1)

But in my chart acc, it’s there

Appreciated with your advises!

Thanks in advance.


Forum|alt.badge.img+11
  • Acumatica Support Team
  • 785 replies
  • Answer
  • May 12, 2022

Hi @chidao 

The GL account may have been selected on your GL preferences screen and set as ‘YTD Net Income account’. One cannot create GL transaction to this account manually as its calculated automatically for Financial report generation.

Refer to the documentation highlighted below:

https://help-2022r1.acumatica.com/(W(3))/Help?ScreenId=ShowWiki&pageid=9fb11332-7bbb-4944-8d9e-995918abc51b

Hope this helps,

Regards,

 


  • Author
  • 113 replies
  • May 14, 2022

Thanks @vkumar so much!!! That was our problem!


Forum|alt.badge.img+9
  • Semi-Pro I
  • 714 replies
  • August 8, 2024

@chidao This error also occurs if you Save the Trial Balance with Missing Imported Subaccounts Values.

 


Forum|alt.badge.img+9
  • Semi-Pro I
  • 714 replies
  • August 8, 2024

@chidao Attached screenshot for the error. This error also occurs if you Save the Trial Balance with Missing Imported Subaccounts Values.

 


So if Acumatica is telling me not to post YTD net income, how do I get the trial balance to balance for posting? Or do I post to the old account and then set up a new one to be used in GL pref?


  • Author
  • 113 replies
  • January 8, 2025
charleyedwards17 wrote:

So if Acumatica is telling me not to post YTD net income, how do I get the trial balance to balance for posting? Or do I post to the old account and then set up a new one to be used in GL pref?

y can import all your profit n loss account then let the system calculate it


Reply


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings