Trial Balance Shows Empty Account Name

(0) Share

Report

Posted on by Community Member

Dear Expert,

I have a strange condition where trial balance show one ledger account without name but it has amount.

4705.tb.png

I have tried rebuild balance and update balance from General Ledger > Financial Dimensions > Financial Dimensions Set but nothing is happened.

*This post is locked for comments

I have the same question (0)

All responses (7)

Answers (1)

Suggested answer

Ludwig Reinhard Microsoft Employee on at

Like (0)

Report

Hi,

Please check in the chart of accounts if an account name and possibly an account name translation into your users language have been setup.

Best regards,

Ludwig

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Dear Crispin,

Based on my query result, the account is exist in database.

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Dear All,

Lately my admin gave me this info:

He was trying to reset all transaction data by ran "SysDatabaseTransDelete". After that, he tried to delete bank account (since it's not used anymore) but AX gave him error message. Then he manually deleted data for the bank accounts from DimensionAttributeLevelValue and after that he deleted the bank account successfully.

Could be the missing account in TB caused by this?

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Dear Ludwig,

No, the account doesn't have name translation.

Was this reply helpful? Yes No
Ludwig Reinhard Microsoft Employee on at

Like (0)

Report

If your users language is different from the default en-us language then the setup of a translated name would help.

Otherwise, I would recommend trying to talk to your colleague who executed the delete process especially if your account setup was ok before.

Best regards,

Ludwig

Was this reply helpful? Yes No
Verified answer

Community Member on at

Like (1)

Report
Dear All,

I have found the solution for my problem. Based on my case, following are steps to solved the issue:

Change the main account of bank accounts that made trouble from 110105101 (old number) to the new one which is dummy account. I change it from Cash and bank management > Common > Bank Accounts.

Change main account number 110105101 to dummy account number - like 900000001 - and change it descriptions. I change it from General Ledger > Common > Main accounts

Create new main account using the same number as the old one - 110105101.

Change back main account of the bank accounts from step 1 to 110105101.

The consequence of my solution is the amount from the old 110105101 account is stored on account 900000001 and it must be manually adjusted by accounting.

This is very important lesson from me that do not ever delete data directly from database. :D

Thanks all for your help

Was this reply helpful? Yes No
Ludwig Reinhard Microsoft Employee on at

Like (0)

Report

Hello Haryo,

Great that you found the underlying issue.

Before 'closing' this issue please do also double check that the balances that you find for your bank accounts match with those that you find on your ledger accounts in GL.

That is, please check if the bank subledger matches GL.

Many thanks and best regards,

Ludwig

Was this reply helpful? Yes No