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

I have the same question (0)

All responses (4)

Answers (2)

Verified answer

mmv 11,471 on at

Like (0)

Report

Hi,

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

Was this reply helpful? Yes No
Verified answer

tpupko 2,048 on at

Like (1)

Report

Hi,

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

Tatiana

Was this reply helpful? Yes No
Suggested answer

Roberto Stefanetti 12,998 on at

Like (0)

Report

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

Was this reply helpful? Yes No
ManishS 86 on at

Like (0)

Report

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

Was this reply helpful? Yes No