Skip to main content

Notifications

Announcements

No record found.

Microsoft Dynamics NAV (Archived)

Apply dimensions retroactively

(0) ShareShare
ReportReport
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

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Tips for Writing Effective Verified Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

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

#2
Martin Dráb Profile Picture

Martin Dráb 230,445 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans