Dimension Correction Tool v2

Administrator · 2008-09-01

Dimension Correction Tool
We had developed this tool to modify the posted dimension in Dynamics NAV tables. It takes the document number as input and return all the possible dimension associated with the posted entries.

Then you can enter new desired dimension in the last column of the Dimension-Correction form for every entry and click UPDATE to change all the posted dimensions.

http://www.mibuso.com/dlinfo.asp?FileID=1010

Discuss this download here.

David_Cox · 2008-09-03

Will this update all the Document lines if you change Dimensions 1 or 2.
How about updating Alalysis views?

I have developed a similar tool for an end client which I cannot share, but to maintain the integrity of the data when updating dimensions they must cascade to all associated entries.

If we take a "G/L Entry" created from a Sales Invoice and Item posting, and changed "Dimension 1", to maintain the integrity the following would need to be updated:
Sales Invoice Line:
Item Ledger
G/L Entry
Value Entry
Posted Document Dimension
Ledger Entry Dimension
And any Analysis Views

David

anuragatish · 2008-09-03

(1) If you change any dimension it will work. We have tested it on a business databse which uses 8 dimensions at max and 2 at min in any transaction.

(2) Yes. It changes all the applicable "Analysis View Entry" entries corresponding to G/L Entries whose dimensions are begin changed.

(3) It even works woth the customers licences.

Regards
Anurag
anurag.atish@yahoo.com

GreatDane · 2008-12-08

A good starting point for changing dimensions, but it is not a generic tool, as dimensions are hardcoded in the code. Instead you should do a lookup of the dimension codes used via the GLSetup table, and the corresponding variables should have generic names, i.e. the code below, here customer, region etc. should be ShortcutDim3 etc.

IF ( PostDocDim."Dimension Code" = 'COMPANY') THEN company := PostDocDim."Dimension Value Code" ELSE
IF ( PostDocDim."Dimension Code" = 'UNIT') THEN unit := PostDocDim."Dimension Value Code" ELSE
IF ( PostDocDim."Dimension Code" = 'CUSTOMER') THEN customer := PostDocDim."Dimension Value Code" ELSE
IF ( PostDocDim."Dimension Code" = 'REGION') THEN region := PostDocDim."Dimension Value Code" ELSE
IF ( PostDocDim."Dimension Code" = 'TRANSPORTER') THEN transporter := PostDocDim."Dimension Value Code" ELSE
IF ( PostDocDim."Dimension Code" = 'VENDOR') THEN vendor := PostDocDim."Dimension Value Code";

Christian0680 · 2009-09-15

The tool is maybe a base for Dimension Correction, but it is not working with Global Dimensions, so this tool does net help now.

Has anybody something better? (without doing extra programming?)

Administrator · 2009-12-03

Dimension Correction Tool v2
So many times we need to modify the posted dimension in the Ledger tables. We had modified first version of this tool to modify the posted dimension in Dynamics NAV tables.
It takes the document number as input and return all the possible dimension associated with the posted entries.

Then we can enter new desired dimension in the last column of the Dimension-Correction form for every entry and click UPDATE to change all the posted dimensions.

Updates in this new version :
* More optimized code
* Dimensions are picked up from the dimension setup table.

http://www.mibuso.com/dlinfo.asp?FileID=1010

Discuss this download here.

antvoi · 2010-02-08

How to fix the error "The Indexing 101 in the array is outside of the permitted range" during process?

hewajith · 2010-06-16

I am getting this error . Can any one tell me how to fix the error "The Indexing 101 in the array is outside of the permitted range

Thanks

Dimension Correction Tool v2

Comments

Categories