Monday, July 14, 2014

AX 2012 - Ledger Account / Nominal not recognised / has an error (warning symbol) when posting a GL Journal

Hi Fellow DAX Passionists,
A simple issue but one that can drive a novice Functional Consultant crazy if not sure where to look.
Scenario: You are trying to post a simple General Ledger Journal via "General Ledger > Journals > General Journal"
Error: When you choose a Nominal / Ledger Account there is the warning symbol / error symbol displayed alongside it to intimate the account cannot be chosen (See screen shot 1). In my example, F20210 (blue rectangle) is allowed to be chosen but F20200 (red rectangle) is barred from selection.

Check 1: You obviously visit the Chart of Accounts. One way to do that is to go to "General Ledger > Common > Main Accounts" and check the setup behind F20210 and F20200. They appear to be exactly the same in my case(See screen shot 2). Had F20200 been a "Total" account for instance instead of a "Balance Sheet or a P&L Account" all would have made sense as the "Total" Account is NOT an input account unlike Balance Sheet or P&L Account.

Check 2 (And possibly the solution): The most likely culprit is an 'Account Structure' setup issue. (An 'Account Structure', if you are not sure, simply enables you to setup additional validations to ledger accounts to ensure only the right data flows into these accounts). Go to "General Ledger > Set up > Chart of Accounts > Configure Account Structures". If there are more than one Account Struture, chose the appropriate structure you think should hold the validations for the account that is throwing up the error. See screen shot 3 below.

In my case it is the account structure "Default - BS (Draft). I know this because F20200 that is giving me the error is a Balance Sheet Account. As you can see F20200 is missing from the Account structure. The range starts from F20210 only. Edit this record (buttons available in the Action Menu), to say "F20200..F20279", save and the Journal should work (assuming there are no other errors, of course!)