Finance | Project Operations, Human Resources, ...

What entity will help mass update vendor financial dimensions

(0) Share

Report

Posted on by US-22040800-0

Hello all,

Is there a Data Entity in D365 that can help update a large number of vendor financial dimensions in one go.

Any help will be appreciated

Thank you

I have the same question (0)

All responses (6)

Answers (0)

Suggested answer

Mohit Rampal 12,565 Moderator on at

Like (0)

Report

Hi Usman, 'Vendors V2' data entity can be used to update vendors financial dimension by updating field DEFAULTLEDGERDIMENSIONDISPLAYVALUE or use Excel-add in to update this field and publish.

Was this reply helpful? Yes No
US-22040800-0 2 on at

Like (0)

Report

Hi Mohit,

I ran the Vendor V2 Entity without the DEFAULTLEDGERDIMENSIONDISPLAYVALUE which updated the vendor master. I tried that again by removing all columns and just leaving vendor name and DEFAULTLEDGERDIMENSIONDISPLAYVALUE.

This did not work, threw an error "0 record inserted in staging".

Trying to load dimension string 000000-000-000. I can try the publish route and see what happens. In the meantime, any suggestions where i might be missing a step when using Vendor V2 entity. Thanks

Was this reply helpful? Yes No
Mohit Rampal 12,565 Moderator on at

Like (0)

Report

I have tested removing financial dimension while importing existing vendor and its working. Instead of adding 000000-000-000, just empty the field DEFAULTLEDGERDIMENSIONDISPLAYVALUE in the file, it will remove all financial dimensions for that vendor.

Was this reply helpful? Yes No
Suggested answer

Gaurangkumar Jani 4,534 User Group Leader on at

Like (0)

Report

Hi Usman Syal,

Please add all required* fields and default financial dimension field, update required details and publish.

Please let us know if this helps.

Thanks,

Was this reply helpful? Yes No
Suggested answer

salman ahmad 176 on at

Like (0)

Report

Hi there alot of times i have to update vendor financial dimensions i use the excel add on approach that is pretty simple.

1. open the vendor v2 add on.

2. add one vendor dimension manually to verify the dimension column otherwise it will be financial dimensions or default ledger financial dimension.

3. go to design format and add all the column it will show in which column the dimensions are appearing just add dimensions there.

i hope it work for you.

thank you

Was this reply helpful? Yes No
André Arnaud de Cal... 301,171 Super User 2025 Season 2 on at

Like (0)

Report

Hi Usman,

Have you looked at the execution details for more information and details of the error(s)? Do you actually have the values 000000, 000, and 000 in your application? If not, the update stopped because of non-existing values.

Have you set up the dimensions for integration? Menu path: General ledger > Chart of accounts > Dimensions > Financial dimension configuration for integrating applications.

Do you need to clear the values or set other (valid) dimension values?

Was this reply helpful? Yes No