Skip to main content

Notifications

Microsoft Dynamics NAV (Archived)

Apply dimensions retroactively

Posted on by 85

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

  • ManishS Profile Picture
    ManishS 6,578 on at
    RE: Apply dimensions retroactively

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

  • Suggested answer
    Roberto Stefanetti Profile Picture
    Roberto Stefanetti 12,998 on at
    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 Profile Picture
    tpupko 2,048 on at
    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 Profile Picture
    mmv 11,465 on at
    RE: Apply dimensions retroactively

    Hi,

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

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

November Spotlight Star - Khushbu Rajvi

Congratulations to a top community star!

Forum Structure Changes Complete!

🔔 Be sure to subscribe to the new forums you are interested in to stay up to date! 🔔

Dynamics 365 Community Platform update – Oct 28

Welcome to the next edition of the Community Platform Update. This is a status …

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,113 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 229,918 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans