Apply dimensions retroactively

(0) Share

Report

Posted on by themanjosh

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

All responses (4)

Answers (2)

ManishS 6,578 on at

Like (0)

Report

RE: Apply dimensions retroactively

Have you identified the tables where you need to update the city dimension !
Suggested answer

Roberto Stefanetti 12,998 on at

Like (0)

Report

RE: Apply dimensions retroactively

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..)
Verified answer

tpupko 2,048 on at

Like (1)

Report

RE: Apply dimensions retroactively

Hi,

Manesh is right. It is not allowed to change posted transaction and dimensions in transactions also.

Tatiana
Verified answer

mmv 11,465 on at

Like (0)

Report

RE: Apply dimensions retroactively

Hi,

There's no standard way to update the existing transactions. You need to update them using a customized program.