Update Markup % By Class/Group

** This utility is under development and is not yet available. **

This program updates the Markup % for the products in the selected Class and Group, and also provides the option to recalculate the list price according to the new markup percent on the cost.

An optional edit report can be printed, so that the update is executed only when the report is accepted. If the report is not generated, then the update occurs immediately when the selection screen is accepted.

The prompts are:

FROM CLASS

Enter the starting product class or press <F4> and select one from the window.

TO CLASS

Enter the ending product class or press <F4> and select one from the window.

FROM GROUP

Enter the starting product group or press <F4> and select one from the window.

TO GROUP

Enter the ending product group or press <F4> and select one from the window.

MARKUP %

Enter the markup percentage of the cost to be used to calculate the list price. For a 30 % increase over the purchase cost, type 30.00
Alternatively to calculate the markup % from a margin, press <F4> and enter the desired margin. The Margin is used in the calculation as a percent of the (Sale Price less Cost) divided by Sale Price.

UPDATE LIST PRICE

Enter N (NO) to update only the markup % for items in Sales Inventory or Rental Inventory.

Enter Y (YES) to update the markup % and also to update the list price by the markup on the last PO cost, for the selected products. If there is no last PO cost for a product, the average cost is used in the calculation. If there is no average cost either, the list price is not changed.

Note: If the List for a non-bulk asset is based on percent of revenue formula as setup in Groups, it is the Base List Price that is updated by the markup on cost, and it is the resulting selling List that is printed on the report.

Any changes made to the List Price or the Base List Price are tracked.
An audit report on history of Re-Order Price changes can be generated from Product Value Override Report.
Price changes are also included in the more general Override Report.

PRINT EDIT REPORT

Enter N (NO) to skip printing the edit report. When this selection screen is accepted, the update will immediately be processed.
Enter Y (YES) to print an edit report listing the products in the selected range with the old and the new markup percentages and list prices. The update to markup and list price does not occur until the report is accepted.

ACCEPT or CANCEL

A printer can be confirmed or re-selected from the Printer option located on the menu bar at the top of the screen.

Click the ACCEPT button to begin printing the report, or CANCEL to abort.

REPORT PRINTED OK

This prompt appears only if the Edit report was printed.
Enter N (NO) if the information is not correct, or if it did not print successfully.
Enter Y (YES) if the report printed ok and the new markup and list information is correct. When this is accepted, then the update to the product file is made.

ENTER TO ACCEPT, / TO CANCEL

Press <ENTER> to accept, or / to cancel.