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,339

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,428 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,339 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 11,425 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,428 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

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 Suggested Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

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

#2
Martin Dráb Profile Picture

Martin Dráb 230,198 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans