Adding suggested cost/price information | Deleting suggested cost/price information |
Use these fields to create suggested costs/prices.
1. Item
Specify the inventory item for which the suggested cost/price is to be entered.
To specify suggested cost/price information on the inventory item for the first time, select, and the system forwards you to the Effective Date field.
Fields 2-4 contain Suggested Cost/Price Header record information
2. Effective Date
Specify the effective date of this suggested cost/price change. Press Enter to default to the system date. When running the Update Suggested Costs/Prices program, a cutoff date is entered and effective dates up to that cutoff date are updated.
3. List Price—(Suggested) Amount
The list price may be entered as a dollar amount or you can press F1to specify a change %. Using a basis and multiplier is not available for list price.
4. Manual Cost—(Suggested)
The manual cost may be entered as dollar amount or a change %. You can press F1to specify a value. The only available basis for manual cost is list price.
To edit existing suggested records for the inventory item, highlight it in the browser or select one of the options across the bottom of your screen and edit the highlighted record.
Adding a Suggested Standard Price During Line Entry
When you access line entry to add a suggested standard price, the pricing information defaults to the basis, multiplier and price of the current price.
Use the Filter list box to select the display settings for the suggested cost and/or price lines in the browser. You can select from: P-Price Levels, S-Standard Price, or Q-Quantity Breaks.
5. Qty
For quantity breaks, specify the minimum quantity that must be sold on a sales order document in order to utilize the price from the level. For example, the standard price of I100 is $10.00 ea., the break 1 price is $9.75 and the break 2 price is $9.50. In order to receive a price of $9.75 the customer must purchase a minimum of 50. In order to receive a price of $9.50 the customer must purchase a minimum of 100. Therefore break 1’s quantity is 50 and break 2’s quantity is 100.
Quantity break is always defined in the selling unit of measure.
6. Basis
For quantity breaks, the system displays the basis options. Initially, you can select from L—Use List Price as Basis, M—Use Manual Cost as Basis, S—Use Standard Price as Basis. After you set the basis/multiplier all price breaks must either use the same basis or they must be based on another price break.
The basis options for additional quantity breaks are: L—Use List Price as Basis , or 1-6—Use Prior Quantity Break 1-6 as Basis. For example, if manual cost is the basis for break 1, the bases for breaks 2 through 6 must be either manual cost or one of the previous price breaks. The basis for levels 2 - 6 may not be set to list price or standard price.
For level pricing, you can select from L—Use List Price as Basis, M—Use Manual Cost as Basis, S—Use Standard Price as Basis, or 1-6—Use Prior Price Level 1-6 as Basis.
For standard pricing, you can select from L—Use List Price as Basis or M—Use Manual Cost as Basis.
7. Mult
For quantity breaks, if you are entering the suggested standard price as a basis and multiplier, specify the multiplier for the suggested standard price for the level. The system automatically calculated and displays the new suggested standard price for the level.
If you are entering the suggested price level as a basis and multiplier, specify the multiplier for the suggested standard price for the level. The system automatically calculated and displays the new suggested standard price for the level.
If you are entering the suggested standard price as a basis and multiplier, specify the multiplier for the suggested standard price. The system automatically calculated and displays the new suggested standard price.
8. Price
The suggested level price may be entered as a basis and multiplier, a set price or a change %. The valid options for basis for level price are as follows: List Price, Manual Cost, Standard Price, or any prior Price Level. You can press F1to specify a change percentage (Chg %) value.
The quantity break price may be entered as a basis and multiplier, a set price or a change. The valid options for basis for quantity break prices are as follows: list price, manual cost, standard price, or any previous quantity break price. You can press F1to specify a change percentage (Chg %)value.
Note: If the require descending prices flag (in the IC Static record) is set to Y, all price breaks must be the same Note: type (basis/multipliers or fixed amounts). Furthermore, if basis/multiplier is used, all price breaks must either use the same basis or they must be based on another price break. For example, if manual cost is the basis for break 1, the bases for breaks 2 through 6 must be either manual cost or one of the previous price breaks. The basis for levels 2 - 6 may not be set to list price or standard price. If the require descending prices flag is set to Y, the prices for breaks 1 through 6 must be entered in a descending order. For example, if price break 1’s price is $5.00 then the price for price break 2 must be less than or equal to $5.00.
The standard price may be entered as a basis and multiplier, a set price or a change %. The valid options for basis for standard price are as follows: List Price or Manual Cost. You can press F1 to specify a change percentage (Chg %) value. All of the item’s valid pricing unit of measures are displayed in the order of the smallest to largest, and up to seven lines of standard prices can be displayed at one time.
9. Chg % (percent)
Costs/prices may be entered by pressing F1 to specify a change % (percent) from the existing cost/price. The system automatically calculate and displays the new suggested standard price for the level or the item. For example, if a standard price of $100.00 is increasing by 3% then you specify a change percent of 3.000. The system then calculates and displays the new calculated price of $103.00. When entering a change percent, the system calculates and stores the actual dollar amount in the pricing files. In this example, the system would store $103.00 the pricing files and this is the amount that would display in Sales Order Entry programs.
10. Comm %
In addition to these three options for setting up the standard price, price levels and quantity breaks, you may also specify a commission percent. A Sales Order Static F/M flag determines whether this flag is available throughout the costing/pricing subsystem.
If the flag is turned off, the system does not give you the option to specify the commission %. If the flag is turned on, each cost/price you create will require you to specify a commission %.
Specify a commission percent for the price level, standard price or quantity break price level. When entering the commission %, you also have the option to set it to "no priority" (which leaves the field blank), indicating that commission is not generated based on the price being set up. (If the item is set to "no priority", any commission % entered in the pricing system will be ignored). For more information on commissions, refer to the Commission Basis flag set in System Management>File Maintenances>Company Control F/M.
11. Save your changes when you have completed the information entry. You can then update these header fields: effective date, list price, manual cost, standard prices, and quantity breaks.
12. You can highlight a suggested costing/pricing line in the browser and press Delete to display the Delete Record Type dialog box, where you can select to delete from these options: L--Suggested list price, M—Suggested manual cost, S— Suggested manual price for the selected unit of measure.
13. In the upper right corner of the screen you can use the item navigation buttons to display the Previous Item, Previous Suggested Costing/Pricing Line Next Suggested Costing/Pricing Line or Next Item suggested costing/pricing information.
14. Click Done to end the program and then again to exit the screen.
See also
Adding suggested cost/price information
Changing existing cost/price information
Deleting suggested cost/price information