Authorized users can change prices, within sales order entry pricing fields, by editing the formula used to calculate the prices. A formula allows you to add, subtract, multiply, or divide a price basis.
A price basis is used to determine prices and is created in Price Line Maintenance. Examples of basis names include DFLT-LIST, DFLT-COST, COGS-COST, and COMM-COST.
You can use a formula to precisely manipulate the basis you select. For example, enter a formula of +1.123 to add 1.123 to the selected basis. Or, enter *1.123 to multiply the basis by that amount. If you select a basis used for your List prices and then enter a formula that subtracts 10 percent, that discount is applied to the designated items. If no formula is specified, the system uses a default formula of the selected basis *1.
Enter a price formula using these formats:
|
Formula... |
Specifies a... |
|
+n.nnnn |
plus percentage of the basis (for example, +1.123). |
|
-n.nnn |
minus percentage of the basis (for example, -1.123). |
|
-n.nn/n.nn/... |
chain discount (for example, -1.23/2.34/...). |
|
*n.nnn |
multiplier (for example, *1.123). |
|
dn.nn |
divisor (for example, d1.123). |
|
gpn.n |
formula that produces a price that reflects the gross profit. Instead of using the basis for the calculation, this formula uses the cost of goods sold (gp.12, for example). |
For detailed information about changing prices using pricing formulas, see Pricing Basis and Formula Guidelines in the Pricing section of the help.
See Also: