Microsoft KB Archive Search

Notice: This website is an unofficial Microsoft Knowledge Base (hereinafter KB) archive and is intended to provide a reliable access to deleted content from Microsoft KB. All KB articles are owned by Microsoft Corporation. Read full disclaimer for more details.

  1. Home
  2. "Invalid column name 'X'" during Year-End Close process with Analytical Accounting installed in Microsoft Dynamics GP

"Invalid column name 'X'" during Year-End Close process with Analytical Accounting installed in Microsoft Dynamics GP

View products that this article applies to.

Symptoms

When closing the GL Year with Analytical Accounting installed, this error message happens:


[Microsoft][SQL Server Native Client 10.0][SQL Server]Invalid column name '1'.
[Microsoft][SQL Server Native Client 10.0][SQL Server]Invalid column name '2'. 
[Microsoft][SQL Server Native Client 10.0][SQL Server]Invalid column name '3'.  
[Microsoft][SQL Server Native Client 10.0][SQL Server]Invalid column name '4'. 
The stored procedure aagYearEndCloseMain returned the following results: DBMS: 207, Microsoft Dynamics GP:.


↑ Back to the top

Cause

The ‘Consolidate balances during Year End Close’ checkboxes ARE marked on the individual dimensions(s), however the ‘Include dimensions in the year end close’, is not marked at the main AA setup Options level. This checkbox is grayed out on the individual dimensions and does not show as marked, however, if you look in the AAG00400 dimension table, the 'aaIncYEC' column is in fact marked.

This may happen if you had the main setup Options level marked at one time and then marked the individual dimensions. However, you then went back and unmarked the main setup Options level. This leaves the dimensions still marked to be included in the year-end close process in the SQL table and causes the issue due to the mismatched settings.

↑ Back to the top

Resolution

Basically, if the dimensions are marked, then the main setup Options level for AA should also be marked, or if the main setup level is not marked, then the dimensions should not be marked either. Have either all marked or all unmarked.  When one level is marked and the other is not, the error message will happen. Use the appropriate method below, depending on whether you want the AA dimensions included in the year-end close process or not:


Option 1 – If you do NOT want AA dimensions included in the year-end:
1. Go to Microsoft Dynamics GP, click on Tools, click on Setup, point to Company, point to Analytical Accounting, and click on Options and mark ‘Include dimensions in the year end close’.
2. Then go to each dimension code and unmark ‘Consolidate balances during Year End Close’ on each and save.
3. Then go back to the main level again and unmark the ‘Include dimensions in the year end close’ again.


Option 2 – If you DO want AA dimensions included in the year-end:
1. Go to Microsoft Dynamics GP, click on Tools, click on Setup, point to Company, point to Analytical Accounting, and click on Options and mark ‘Include dimensions in the year end close’
2. verify the ‘Consolidate balances during Year End Close’ checkbox is marked on each dimension that you want consolidated.


↑ Back to the top

More Information

Usually once users mark the dimensions to be included in the year-end process, they don't go back and unmark it. Therefore, due to the easy work-around for this issue and not many users go back to unmark it to cause the mismatch, this would have a low priority rating, so this issue was not logged as a quality issue at this time. 

↑ Back to the top

Keywords: kbmbspartner, kbmbsmigrate, kbsurveynew, kb

↑ Back to the top

Article Info
Article ID : 3052955
Revision : 1
Created on : 1/7/2017
Published on : 4/2/2015
Exists online : False
Views : 248