Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Dynamics 365 Community / Forums / Small and medium business | Business Central, N... / Changing Dimension Val...
Small and medium business | Business Central, N...
Suggested answer

Changing Dimension Value on Vendor Ledger Entries

(0) ShareShare
ReportReport
Posted on by Gavin 2,341

Hi All,

There's a request to change the dimension value on Vendor Ledger Entries and unfortunately when you use the Dimension Correction tool this isn't updated.

I've figured out that if I can do this using a Configuration Package but wondered if there are any reasons I should avoid this? 

In my configuration package I've ticked the "Dimensions as Columns" option and updated the Dimension Value and also the Dimension Set ID and when I've tested this everything looks ok but is there anything else I need to be aware of or consider?

Many thanks

Gavin 

  • MahGah Profile Picture
    MahGah 15,433 on at
    RE: Changing Dimension Value on Vendor Ledger Entries

    Hi Gavin

    You are welcome. You can try those Dimension Correction app if it is a one time deal.

    appsource.microsoft.com/.../PUBID.dynamicsnavaddon|AID.dimensionmanager|PAPPID.93678dd0-af16-46ec-a58b-a89808fba8f7

  • Gavin Profile Picture
    Gavin 2,341 on at
    RE: Changing Dimension Value on Vendor Ledger Entries

    Hi Both,

    Thanks for taking the time to reply.

    In my scenario there's only the Vendor Ledger Entry and Posted Purchase Invoice tables to consider. (I used "Find Entries" on the transactions to confirm)

    It seems I can successfully update the Vendor Ledger Entry table using the configuration package however it seems I can't update the table "Purch. Inv. Header" using the same method. (this is the table linked to the Posted Purchase Invoice when I use Page Inspector)

    Therefore taking everything into consideration I'm not going to attempt this.

    Thanks again

    Gavin

  • Dallefeld Profile Picture
    Dallefeld 169 User Group Leader on at
    RE: Changing Dimension Value on Vendor Ledger Entries

    MahGah is correct but I want to add that you can only fix dimensions in the general ledger entry table, not vendor ledger entry.

  • MahGah Profile Picture
    MahGah 15,433 on at
    RE: Changing Dimension Value on Vendor Ledger Entries

    Hi

    I could be wrong here. But I believe each vendor ledger entry created because of other actions such as purchase invoice.  Then purchase invoice impacted G/L , Item Ledger Entry, etc as well. Hence changing dimension here may not change other related posting dimension and cause issue in the future.

    You can try the following app. it has batch navigation change. You can go to G/L select the G/L (or multiple G/L) that you want to change dimension then use Batch Navigation then it will update all related transaction. This way you can see what are changing and maybe use the logic for your method. 

    appsource.microsoft.com/.../PUBID.dynamicsnavaddon|AID.dimensionmanager|PAPPID.93678dd0-af16-46ec-a58b-a89808fba8f7

    pastedimage1646153911504v1.png

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

Congratulations 2024 Spotlight Honorees

Kudos to all of our 2024 community stars! 🎉

Meet the Top 10 leaders for December

Congratulations to our December super stars! 🥳

Start Your Super User Journey Pt 2

Join the ranks of our community heros! 🦹

Leaderboard

#1
André Arnaud de Calavon Profile Picture

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

#2
Martin Dráb Profile Picture

Martin Dráb 230,514 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans