1. Home
  2. /
  3. Panel Help
  4. /
  5. Distribution
  6. /
  7. Update item prices (DMR75101)

Update item prices (DMR75101)

This panel displays the calculation model codes and corresponding descriptions that have been defined in the Work with calculations program. Updating of sales prices, purchase prices, retail price, campaign price, handling cost and/or standard cost can be done in this program.

Note: The information cannot be updated for a calculation model in this program if it is secured and you do not have authority for maintenance, as defined in the Work with item price calculations, Header maintenance.

Selection fields

Update item prices (DMR75103)

The actual updating of prices established in the Item file is initiated from this panel. The prices that will be updated are determined by what was defined in the Template for the Calculation model (i.e. the identification code defined in the Price to update field).

Information to be defined includes the date from when the price changes are to be valid, the currency that shall be updated for the selling price, retail price, campaign price and purchase price, exchange rate, if more units shall be updated with the new selling prices, if the campaign price is to be updated and the dates for which the campaign shall be valid.

From date
Enter the date from when the new purchase and selling prices shall be valid. The date entered cannot be lower than today’s date.
To date
Enter the date to which the new purchase and selling prices shall be valid. The date entered cannot be lower than today’s date.
Currency
The default is the system currency. Enter the currency for which the updating of selling prices and purchase prices shall be valid. For the updating to function, a record must exist with the correct currency and unit for the selling price and a currency must exist in the Currency table. If the currency is changed in this field, the exchange rate defined below is also updated. Click OK to confirm the entry.
Exchange rate
Enter the exchange rate that is to be valid during the updating of selling prices. If the system currency is defined in the Currency field above, this field will contain the value 1,0000000. If the Currency is changed, the corresponding exchange rate is automatically updated in this field. The exchange rate can also be manually changed.
More units
Set this field to YES if the selling prices for units of measure other than the stock unit shall be updated. A record must exist with the correct currency and unit for the selling price if the updating is to occur. If set to NO, the updating will only occur for the selling price for the defined currency and warehouse in which the item is stored.

Note: When calculating sales prices in units other than the stock unit, the ratio between the two new sales prices will be the same as the ratio between the two old sales prices.

For example:

Stock unit: Pieces

Unit Old New
PCS 100 110
BOXES 180 (xx)

Formula:

Old sales price 1 (box) x New sales price 1(pcs) = New sales price (box)
Old sales price 1 (pcs)

Therefore:
180 x 110 = 198 = (xx)
100

Campaign date
This field is only displayed if the campaign price is to be updated, as defined in the Template for the Calculation model. Enter a from and to date for the validity of the campaign price. The system automatically checks that the from date is not lower than today’s date.

Price adjustment

In the fields below you define how the new prices should be adjusted. Note: The system will default the price adjusting information defined in the Currency table, but can be changed.

To value
Enter, in ascending order, the break levels for price adjustment to the values in the corresponding Adjust to field. Normally the last field shall contain the maximum value (all 9’s).

For example:
To value= 1000
Adjust to = 10

If the new price of an item is calculated to 975, the price will be rounded up to even 10, i.e. 980.
Note: The values must be entered in ascending order (from lowest to highest).

Adjust to
Enter, for each price range, the adjustment value that a price in the specific price range shall be adjusted to.
Remarks
In this field you can enter text or comments that will be printed on the cover page. If this field is left blank, then your user ID will be printed.
Printer queue
If this is the first printout of the day, then the system will default the output queue defined in your iSeries user profile. If it is not, then the ID of the printer that was previously used will be defaulted. The value in this field may be changed. Another printer may be selected.
Number of copies
Indicate how many printouts you require.
Hold on spool file
The default is NO. This means that a printout will be generated as soon as the printer is available. If set to YES, then the printout will be held in the output queue. To release these holds, use either of the Work with jobs and Display printer output icons from the menu bar.

Click OK when you have completed all the information.