Scenario
Users may need to set different default Cost Estimate Types at the Item Type level. For example, an Inventory Item might need to be Last Purchase Price, while an Assembly or Kit might be best with an Average Cost.
Solution
Currently, there is no preference to set this up per Item type, but as an alternate solution, here are the steps we can perform:
- Create a Saved Search for the items (Showing Item Name/Internal Id, and of course the Item Type)
- Export it as an excel file
- Update the Cost Estimate Type in excel (Create one file for each Item Type)
- Save them as separate CSV files
- Perform as many Imports the number of files.
DEMO:
Let's use the scenario above: Inventory Item = Last Purchase Price, Assembly or Kit = Average Cost.
Here is the sample Item with 'Average Cost' as the Default Cost Estimate Type in the Item record:
TO UPDATE:
1.) Create an Item Saved Search (Reports > Saved Searches > All Saved Searches > New > Item)
Criteria tab:
Results tab:
Sample Result:
2.) Export: Click the excel button (See screenshot above)
3.) Update the Cost Estimate Type in the excel
4.) Perform the Import (One for Record Type Inventory item and one for Assembly)
Import Options:
Mapping:
5.) Name the Import and click Save & Run
Refresh the Item Record and check the updated Cost Estimate Type field after the Import:
Note: Users may create separate Saved Searches (one for each Item Type) and export them as excel files or create only one Saved Search similar to the sample above, then edit and save as many CSV files as necessary (one for each Record Type).
Do you know similar scenarios where this alternate solution can be applied? Feel free to share them in the comment section.