Hello,
Does anyone know of a way to retroactively apply dimensions to all of a customers previous transactions? Specifically, my customers currently have a region dimension applied, but I'd like to add a City dimension as well, and have it apply to all previous transactions the customer made.
Thank you
*This post is locked for comments
Have you identified the tables where you need to update the city dimension !
hi,
no standard ways to do this.
You need to customize, you can use standard NAV function DimMgt.GetDimensionSetID(Rec) to create New Dimension SET ID of fiunction existing on UpgradeToolkit since NAV 2013
Example
On Close Page (page 480 Edit Dimension Set Entries) you can find teh function
DimSetID := DimMgt.GetDimensionSetID(Rec)
You can use new IDs to update tables (for example starting from table 17..)
Hi,
Manesh is right. It is not allowed to change posted transaction and dimensions in transactions also.
Tatiana
Hi,
There's no standard way to update the existing transactions. You need to update them using a customized program.
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
André Arnaud de Cal... 291,113 Super User 2024 Season 2
Martin Dráb 229,918 Most Valuable Professional
nmaenpaa 101,156