The first time you receive a price update for a price line, set up a price sheet for that price line. The basis names and formulas entered on the price sheet determine product prices from the update information.
To assign a formula to a price sheet:
Display the character based system.
Note: The Auto Price Update functionality has not been incorporated into Solar Eclipse as of this release.
From the System > Printers menu, select Your Hold Entries to display the Spooler Control screen.
Position the cursor on the name of the update file, and use the Process hot key to display the User Defined Upload Processing screen.
In the Processing Type field, enter Auto Product Price Updating and use the Begin hot key to display the User Defined Auto Price Updating screen.
In the Work ID field, enter the appropriate work ID for the update file.
Use the Scan hot key to display the Price Update Scan screen.
Use the Edit Formulas hot key to display the Price Sheet Entry (Auto Updates) screen.
All entries in the CalcBase* field initially display NO UPDATE.
All formulas are *1.
The Rnd field displays a default entry for rounding digits.
The Prc Bas field is blank.
For any basis you are updating, change NO UPDATE to AUTO. The system reads the basis from the update file when you begin the update.
In the Rnd column, enter the number of characters for which you want to round the price. This field is used with the formula provided.
For example, the Rnd column displays 3, so when you run the price update, prices display three characters beyond the decimal point.
The vendor's update diskette shows a LIST price of 10.00.
The formula for REP-COST is *.4873.
The updated REP-COST is 4.873.
In the Prc Bas field, enter the number (1-5) that corresponds to the Update Basis # field on the User Defined Auto Price Updating screen that points to the price data in the update file.
In the CalcBase* and Formula fields, enter the basis name and formula to use to calculate the price. For example, REP-COST is LIST less 40 percent, so enter LIST in the CalcBase* field and *.40 in the Formula field.
Note: You receive an error message if you point the basis name to itself in the calculated field, for example, entering LIST next to the basis name LIST.
Press Esc to save your changes and return to the Price Update Scan screen.
See Also:
Formula and Pricing Basis Guidelines