2,382
I updated database from 2009 to 2016 but dimension set ID for in the table Sales Shipment line is not updated. In 2009 there are more than two dimensions are attached with single document. Is there any way to update dimension set id.
*This post is locked for comments
Hi
1) You need to add the related dimension in temporary table in NAV 2016
2) Ensure that all the dimension values are there in dimension value table
3) Based on the dimension combination for each document from temporary table you need to find dimension set id and update in Posted document.
Hope this helps.
Dimension Values and Dimension codes are are present in posted document dimension table in 2009 database . Should I import that table and data in 2016 at some temporary ID in 2016 and run the function UpdateDimensionSetId for every document in sales shipment Line Table .
In 2009 there is no dimension Set ID concept it was introduced in the later version, are you trying to update Sales Shipment Line Dimension Set ID ? What you need, is to create the dimensions which you can check for the functions in dimension management and once you create them it has the function to return the dimension set ID which you can assign to Sales Shipment Line.
For example, check the OBJECT Table 96 G/L Budget Entry there is a function in it which is used to update the dimension set id for that record, you need to write something like that for sales shipment line.
Look at this for updating dimension
Hi,
Is the document is customized?
You probably have to look at these threads:
community.dynamics.com/.../191644
forum.mibuso.com/.../upgradation-to-2013-dimension-set-entry-table
Hope it helps.
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
#1
André Arnaud de Cal...
291,280
Super User 2024 Season 2
#2
Martin Dráb
230,235
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (