This section covers how to globally update Master Inventory Part (“Master”) Costs and / or Prices
The purpose is to allow the User to:
- Update selected Master Costs / Prices based on common filter attributes, such as Category, Subcategory, Company, Branch and / or Profile values; and
- Update the Master Selling Price A/B/C/D based on the Price Factor A/B/C/D input value
Note: This is an alternate option instead of accessing the system interface and editing each MasterNo record one by one for its Cost and Price Factor A/B/C/D
- Go to Inventory Main Menu > Global Updates – Master Prices. The Update Master Prices form will open in a new window
- Select the specific filter(s) and corresponding value(s) for Master record Costs and / or Prices you want to update
- Select from the list of filter options to locate Masters to impact based on Category, Subcategory, and / or Master By Company / Branch, and / or Master Profile
- If no selection is made, ALL Master records will be impacted
- Select whether you want to update those Masters’ Cost, i.e.
- to a Standard Cost amount or
- to update the Standard Cost by a percentage
- Otherwise leave blank to leave the Masters’ Cost as-is
- Select by how much to update the Masters’ Selling Price
- Select and input a value for Price Factor A and / or B and / or C and / or D
- Reminder: Selling Price [A] = Master Cost * Price Factor [A]
- Otherwise leave blank to leave Price Factors as-is
- Select from the list of filter options to locate Masters to impact based on Category, Subcategory, and / or Master By Company / Branch, and / or Master Profile
- Click SAVE icon and confirm the action in the pop up window that appears
- Notice the selection of Master records were updated according to the choice(s) you made above