Inventory Maintenance Mass Update
Action: MASSUPDATE
Mass Update is used to make modifications to multiple inventory styles at the same time. The modifications may be Reorder Cost, Date Discontinued and Retail factor %. For instance, a vendor may raise the cost of all their bridesmaid gowns, this form will update all styles from that vendor in one step (cost & retail prices).
Mass Update can automatically change the Retail Price #1 of each item it modifies. The program will change retail prices when the System/Store Setup setting Don't allow direct price changes to inventory is enabled AND there is something entered in the Reorder Cost field. If the Retail Price should be computed and no reorder cost change is required, use a Reorder Cost adjustment of +0.
This setting assumes that the computer is managing the computation of the retail price within Inventory and as a result it can compute the new Retail Price during a mass update.
There should be a current backup of all data before using this function, in case a data entry mistake is made.
There are four steps to accomplish a mass update of inventory.
- Enter the selection criteria of the items to update
- Input the new values
- Review selected items for update
- Apply the update
- Update Inventory where Indicates to ProfitSystem which inventory items to select for updating.
Category...Only inventory items containing the category selected will be updated. Blank updates all categories.
Vendor... Only items from the vendor selected will be updated. Blank updates all vendors.
Vendor style...Only items with the vendor style selected will be updated. Blank updates all vendor styles.
Last received...The item will only be updated if the last date received is within the date range entered. When the item was received during the date range and also received at a later date, it would not be updated, since only the last receive date is checked.
What modifications are to made to the items of the entered criteria: Date discontinued...Sets the discontinued date to the entered date.
Reorder cost...Change the reorder cost based on an adjustment amount. The adjustment amount is a code and an amount. The valid codes are =, -, +, %. You must enter the adjustment amount in the following format. Use =100 to set the actual reorder cost to $100.00 Use 25, or -25 to subtract $25 from the reorder cost. Use +45 to add $45 to the reorder cost. Use 15% to subtract 15% from the reorder cost. If you don't enter a code and just enter an amount, the reorder cost will be discounted by that amount (as if you'd entered a -)
Retail factor %... Change the retail factor to the number entered. Enter 200% as 200, or 175.5% as 175.5
Retail plus... Change the retail plus entered
Re-calculate retail price 1?... Check this option to recalculate retail price 1 after the reorder cost, retail factor, and retail plus are updated.
Round price to?... Either do not round, or round to the nearest dollar. Only applicable if Re-calculate retail price 1 is checked.
Buttons
Cancel button...Aborts any updates and returns to previous screen.
OK Button...Accepts the criteria entered. ProfitSystem will display the matching inventory with the Inventory Selection Grid.
Inventory Selection Grid...This list contains the inventory items that match the criteria entered. ProfitSystem will display a list of the inventory styles selected for modification. The operator should review this list to insure the correct items have been selected for modification.
Items may be removed by highlighting the item and pressing the DEL (DELETE) key. The item will remain visible, but a black box will appear on the left indicating it will not be included in the update.
Pressing the DEL (DELETE) key again with the item highlighted will remove the Black box indicating it WILL be updated.
ESC Key...Press Escape (or Esc) key while in the Inventory Selection Grid to exit the selection grid.
ProfitSystem will exit the grid and prompt for the update to continue. Click YES for the update to be performed or NO to cancel the update..