Scenario
User needs to an automated way to <null> for Reorder Point and Preferred Stock Level fields since doing them one by one will be arduous and will take a lot of time. As of currently doing this via mass update is a system limitation and currently logged to Enhancement#109179: Mass Update > Items > Add ability to update reorder point (with preferred location when MLI turned on) but an alternative solution would be doing it via CSV import.
Solution
Here are the general steps: (Reminder to test this to one or two sample first to see how it works on your end before doing it on a big batch)
Note: only one location per CSV import will be updated.
Step 1: Create a CSV file with the following details/headers:
Step 2: Perform a CSV import:
- Navigate to Setup > Import/Export Import > CSV Records
- Here are the setup in the Import Assistant
Scan & Upload CSV FIle
Import Options (Choose Update)
Field Mapping
For Reorder Point and Preferred Stock Level, click the pencil icon and choose "Set Value to Null"
Make sure to also include the Auto Calculate Reorder Point and Auto Calculate Preferred Stock Level in the mapping and set its value to No.
(Just an additional information, I tried to clear out the values in my initial tests by only setting Reorder Point and Preferred Stock Level and did not include the Auto Calculate Reorder Point and Auto Calculate Preferred Stock Level in the mapping. With that setup, the values were not cleared out after the import.)
-----
If you find this information useful, let us know by reacting or commenting on this post!