Dynamics NAV Financials

account schedules, financial reporting, dimensions, budgets and all the rest of the fun, fun world of Microsoft Dynamics NAV from a (former) Controller who still uses the software every day

  • Account Schedule Examples
  • Account Schedule Formulas
  • Popular Series
  • Services
  • About

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

Posted: July 16, 2012 | Author: kpeters | Filed under: Uncategorized | Tags: Account Schedules, consolidation, error, financial statement, general ledger, NAV | 1 Comment

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


TwitterYouTubeFacebookGoogleLinkedInEmailRSS
MVP_Logo_Preferred_Cyan300_RGB_72ppi
All Stars_NAVUG(1)
400dpiLogo

Blog Stats

  • 559,747 visits

Enter your email address to follow this blog and receive notifications of new posts.

Join 473 other followers

Top Posts & Pages

  • Account Schedule Formulas
  • Account Schedule Examples
  • NAV Account Schedules 101
  • 12 month Trend Net Change
  • Month to Date vs. Year to Date
  • Basic Balance Sheet
  • NAV AS 101 Lesson 10: Comparison Period v. Comparison Date
  • 12 month Trend Balance
  • Base for Percent
  • Basic Income Statement
My Tweets

Account Schedules accounts payable accounts receivable aging analysis by dimensions Analysis Reports analysis views balance at date BREP budgets chart of accounts Classic Client code mandatory column layout community comparison date formula comparison period formula consolidation Convergence CustomerSource dimensions document date dual monitors due date Dynamics ERP Excel export to excel financial reporting financial statement fiscal year general ledger global glued column increase header item ledger entries JET journal entry keyboard shortcut learning Management Reporter manuals Microsoft NAV NAV 2013 NAVUG NAVUG Academy net change networking Office2013 paperless payment terms pivot table posting accounts PowerPivot productivity query tool reconciliation account reporting tool ROI row setup RTC set base for percent setup options shortcut show opposite sign SSRS tips and tricks totaling type training trial balance user group user level configuration user poll video

Blogroll

  • Microsoft Dynamics NAV Team Blog
  • Microsoft Connect
  • Microsoft Dynamics CustomerSource
  • I Love NAV
  • Microsoft Dynamics Community
  • NAVUG

Archives

  • December 2020
  • September 2020
  • November 2019
  • October 2019
  • August 2019
  • May 2019
  • March 2019
  • April 2018
  • December 2017
  • October 2017
  • April 2017
  • March 2016
  • December 2015
  • October 2015
  • September 2015
  • August 2015
  • July 2015
  • June 2015
  • May 2015
  • March 2015
  • January 2015
  • December 2014
  • September 2014
  • July 2014
  • June 2014
  • May 2014
  • April 2014
  • February 2014
  • January 2014
  • December 2013
  • November 2013
  • October 2013
  • September 2013
  • August 2013
  • July 2013
  • June 2013
  • May 2013
  • April 2013
  • March 2013
  • February 2013
  • January 2013
  • December 2012
  • November 2012
  • October 2012
  • September 2012
  • August 2012
  • July 2012
  • June 2012
  • May 2012
  • April 2012
Blog at WordPress.com. Mid Mo Design.
Cancel

 
Loading Comments...
Comment
    ×