Is it possible to change dimensions on already posted invoices? We had more locations and we want to merge the numbers together now. And since all the reporting/keys are based on dimensions I was hoping I could say everything that was location 8 should now be 1. Or do I have to do journal entries to get things to work out right? Thanks.
Jason
There are examples on the forums for how to merge customers. The same concept can be applied to merging the dimensions. There are also some downloads out there that will allow you to correct dimensions on posted documents.
Will this solve your problem straight away ?
Setup a dimension value “NEWONE” with totaling 1|8 , (that is a “or” sign) , run reports again with this new dimension value.
Depends on how “soft” of your mod codings… this might save you from a lot of Data Fixing , and the risk of missing out some of them.
ie. these dimensions are stored in different tables. At least 2 of table, 1 -4 dimension entries per would need to be changed.
Matt,
Do you have any links you can share with me? Both for merging of customers and of a program that I can download? Thanks.
Jason
Jason,
If the amount is large, you may consider this one: http://dynamicsuser.net/groups/dynamics-nav-add-ons/media/p/144554.aspx
and this is not the only tool available.
Merging Dims is not so “easy” as merging Cust / Vend / Item. Due to historical reasons Dim values are stored in 2 different places - GD1 & GD2 in GL Entry, and ALL of them in Ledger Entry Dims (LED) table.
So, GD1 & GD2 are duplicated in LED table as SD1 & SD2, and you can easily get them out of sync by changing them in inappropriate way.
Then, you must also change Dims in Cust / Vend / Item Ledgers and their associated LED entries , maybe some of your reports run on those, not GL ledger (e.g. Item Analysis by Dims)
Changing Dims for posted entries is a hard job, as you must update many tables and KNOW which tables are involved for any given type of transaction.
As you write in Enduser forum, I suppose you are not a Navision guru programmer who knows the table structure, so I would rather recommend to look for some tool --the one I mentioned above or some other-- which will do the job for you, leaving all the technical intricacies aside.
some dimention correcting downloads:
http://www.mibuso.com/dlinfo.asp?FileID=1168
http://www.mibuso.com/dlinfo.asp?FileID=1333
Some merging info from the always brilliant Rashed Amini
http://www.mibuso.com/forum/viewtopic.php?f=5&t=15580
Some Dimension Correcting Tools:
http://www.mibuso.com/dlinfo.asp?FileID=1168
http://www.mibuso.com/dlinfo.asp?FileID=1333
Some Merging Info from the always brilliant Rashed Amini: