Supply chain | Supply Chain Management, Commerce

Bulk Update of multiple fields in Default order settings at different ranks

(1) Share

Report

Posted on by CP-29041027-0

Hello, I have a requirement for performing bulk Update of multiple fields in Default order settings across Purchase, Inventory and Sales tabs for many items at once at different ranks. I have tried doing this through Excel add-in and the Default order settings entity from data management, but I do not see a way to do it for different ranks at once. The fields I need to update are order type, default warehouse, multiple, max order qty, standard order qty and inventory lead time.

All responses (2)

Answers (0)

CP-29041027-0 12 on at

Like (1)

Report

Bulk Update of multiple fields in Default order settings at different ranks

Thanks Kevin, I already checked this but looks like the process that gets executed is confusing when there are multiple settings at different ranks. For example, I executed the data entity import against one item with settings at two ranks 0 and 10.

Two problems I see:

1. All changes except default warehouse applied to settings at both ranks

2. Default warehouse only applied to settings at 0 rank.

I also used the open excel functionality from default order settings but it is only loading settings at the rank 0.

My requirement is to only update the different values to settings at different ranks and not same values to all settings at all ranks for an item at once.
Suggested answer

Kevin Xia Microsoft Employee on at

Like (0)

Report

Bulk Update of multiple fields in Default order settings at different ranks

Hi,

There are users on the forum who have encountered similar problems and got solutions, you can refer to this old thread: default order settings bulk upload (dynamics.com). The consultant gave the corresponding page navigation, as well as the corresponding screenshot, you can refer to it.

Best regards,

Kevin