How to change old Dimension Codes to new in all rel. tables?

Aravindh_Navision

Hi Friends,

Version: NAV 2009 SP1

We have a requirement to change the old dimension value to new in G/L Entry and other related tables.

Currently, below 10, 20.. 100 are the dimension codes.

10 - DimA
20 - DimB
30 - DimC
40 - DimD
50 - DimE
60 - DimF
70 - DimG
80 - DimH
90 - DimI
100 - DimJ

Current requirement is, instead of the above 10 Dimension codes, we are minimizing it to 3. Means the above 10 Dimension Codes are combined and grouped in to 3 dimension codes.

Say,

10 - DimA [New Dimension Code Dim1]
20 - DimB [New Dimension Code Dim2]
30 - DimC [New Dimension Code Dim3]
40 - DimD [New Dimension Code Dim2]
50 - DimE [New Dimension Code Dim3]
60 - DimF [New Dimension Code Dim1]
70 - DimG [New Dimension Code Dim3]
80 - DimH [New Dimension Code Dim3]
90 - DimI [New Dimension Code Dim1]
100 - DimJ [New Dimension Code Dim2]

The dimension codes should be changed in all related tables.

Can anyone tell me how to do?

Thanks in advance,
Aarvi.

neilgf

Hi

For posted entries, only option is to reverse post and post corrections. Or use totalling in dimension value structure, create new dims and historic and new transactions will work in reporting. You may need to rename existing dims to get the sub totalling to work.

Neil