NAV Error Message: G/L Account No. ” does not exist

I was merrily finalizing my financial statements last week, and got this error when running my consolidation. I had successfully run my consolidation error free for over a year, so in disbelief, I immediately reran it, expecting a change in result. Same error. I began to run the mental check list. What was different? What had changed?

Of course! I had added a new account at the end of the year, and this month was the first month there was activity in the account. Not remembering exactly what I did six months ago, I rechecked my work.

• I had added the new account on my main company
• I had added the new account on my consolidation company

I reran the consolidation; still the same error.  What was I missing?  The culprit was the Consolidation tab on the on the G/L Account Card.  I only had it set up correctly in the consolidation company and had missed filling out these same fields on the main company. I needed for this to be filled out exactly the same on both cards in order for this to work.   I fixed the two fields, and voila!, my consolidation was back to its usual, reliable old self and finished up like a champ.

The culprit, showing missed fields

Now properly filled out

Just for good measure, I took a quick tour through my account schedules to make sure I had incorporated this new account either through ranges or individually so this new activity would also be properly captured in the financial statements.

This error can occur in other places, and in plain English is basically telling you that you’ve missed some setup where a general ledger account must be defined.  That nifty little double apostrophe means “blank” to NAV.  I put “NAV G/L Account No. ” does not exist” into BING looking for someone who may have answered this question before, so if you’re looking for a solution for this error in other areas, try these links.

http://support.microsoft.com/kb/2274642  Microsoft hotfix available when error is generated when you run the export to excel function on the analysis by dimensions reporting in the Spanish version

http://www.mibuso.com/forum/viewtopic.php?t=52338 when posting a sales credit note

http://dynamicsuser.net/forums/p/279520/279520.aspx when posting an invoice