Verify the information on the price sheet before running the update to ensure all information is in place to accurately update your product pricing information.
To verify data on 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 Update) screen.
Verify the values defined for the last effective date that display in the CalcBase* and Formula fields:
If the formulas are correct, they carry over to the new effective date.
If new formulas are necessary, use the Edit Eff Dates hot key on the Price Update Scan screen to create a new price sheet.
For basis names you are updating from the file, verify that the CalcBase* field displays AUTO and the Formula field displays *1. If not, change the values.
In the Prc Bas field verify that the number (1-5) corresponds to the correct number of the Price Basis # field in the Data Format column on the User Defined Auto Price Updating screen.
For example, if you are updating LIST and you used Price Basis #1 on the User Defined Auto Price Updating screen to point to a new list price in the update file, enter 1 in the PrcBas field for LIST price on the Price Sheet Entry (Auto Update) screen.
For basis names with a value calculated using another basis name, enter the basis name and the formula. For example, if REP-COST is LIST less 40 percent, enter LIST in the CalcBase* field and *.40 in the Formula field. If LIST equals $40.00, this creates the formula $40.00 x .40 = $16.00, therefore the price for REP-COST is $40.00 - $16.00 = $24.00.
If the basis name used to calculate another value is updated from the file, enter that number (1-5) in the Prc Bas field.
Repeat the verification process for each price sheet being updated.
Press Esc to return to the Price Update Scan screen.
See Also:
Changing the Auto Price Update Format