Updating the prices of the sold materials in batch avoids loss of time. New material (class) sales prices can be generated for updated prices if necessary.
The Material prices are updated using the Material Price Update option located in the Operations menu of the Sales and Distribution module. The price update method, and the materials to be updated are specified with the selections made in the filter lines of the Service Sales Price Update window. The filter options are as follows:
Filter | Value |
Code | Group / Range |
Group Code | Group / Range |
Sorting | Sorting entry |
Material Type | (CG) Commercial Good / (MX) Mixed Case / (DI) Deposited Item / (FA) Fixed Asset / (RM) Raw Material / (SF) Semi Finished Good / (FG) Finished Good / (COG) Consumer Good |
Material Code | Group / Range |
Material Description | Group / Range |
Material Aux. Code 1-5 | Group / Range |
Material Auth. Code | Group / Range |
Material Group Code | Group / Range |
Material Brand Code | Group / Range |
Material Vendor Code | Group / Range |
Parent Material Class Code | Group / Range |
Parent Material Class Description | Group / Range |
Material Characteristics | Characteristic 1-10 |
Unit | Unit Set Code / Unit Code |
AR/AP Code | Group / Range |
AR/AP Trading Group | Group / Range |
AR/AP Auth. Code | Group / Range |
AR/AP Aux. Code 1-5 | Group / Range |
Payment Plan | Group / Range |
Brand Code | Group / Range |
Delivery Code | Group / Range |
Delivery Time | .......... equal to ...... |
Priority | .......... equal to ...... |
VAT | Excluded / Included |
F. Currency Type | Currency options |
Update Content | Price / Limit |
Present Unit Price | .......... equal to ...... |
Validity Date of Present Unit Price | Start / End |
Transaction Type | Update card / Add New Card |
Price Records to Be Processed | Purchase / Sales / All |
End Date of Present Unit Price | ............ on ...... |
Validity Date of New Unit Price | Start / End |
Validity Hour of New Unit Price | Start / End |
Update Method | New Price / Factor |
Update Factor (%) | .......... equal to ...... |
Rounding Base | .......... equal to ...... |
New Price | .......... equal to ...... |
Actual Lower Limit Type | Percent / Amount |
Actual Lower Limit | .......... equal to ...... |
New Lower Limit Type | Percent / Amount |
Lower Limit Update Method | New Value / Factor |
Lower Limit Update Factor (%) | .......... equal to ...... |
Lower Limit Rounding Base | .......... equal to ...... |
Lower Limit New Value | .......... equal to ...... |
Actual Medium Limit Type | Percent / Amount |
Actual Medium Limit | .......... equal to ...... |
New Medium Limit Type | Percent / Amount |
Medium Limit Update Method | New Value / Factor |
Medium Limit Update Factor (%) | .......... equal to ...... |
Medium Limit Rounding Base | .......... equal to ...... |
Medium Limit New Value | .......... equal to ...... |
Actual Upper Limit Type | Percent / Amount |
Actual Upper Limit | .......... equal to ...... |
New Upper Limit Type | Percent / Amount |
Upper Limit Update Method | New Value / Factor |
Upper Limit Update Factor (%) | .......... equal to ...... |
Upper Limit Rounding Base | .......... equal to ...... |
Upper Limit New Value | .......... equal to ...... |
Old Price Priority Info | Increase / Use as is |
Division | Defined divisions |
The material (class) sales prices to be updated are filtered by material type in the Material Type filter line, material code in the Material Code filter line, description in the Material Description filter line, Aux. code in the Material Aux. Code filter line, and the authorization and group codes in the Material Auth. Code and Material Group Code filter lines respectively. The group or range definition filter is used for the filtering operation.
The Parent Material Class Code and Parent Material Class Definition filter lines are used to specify the materials to be included in the update. The Material Characteristics filter line is used to filter the materials to be updated by characteristics.
The Unit filter line is used to specify the unit set and unit for which the price will be updated.
The AR/AP Code filter line indicates the AR/APs for which the material prices will be updated.
The Payment Plan filter line is used to set conditions according to the Payment Plan Code specified in the Sales Prices, in order to update the price of the materials for which the payments will be done according to this plan code.
The materials to be updated are filtered by the delivery time in days in the Delivery Time filter lines, delivery types in the Delivery Code filter lines, and the priority assigned in the material (class) sales prices in the Priority filter lines. The priority is specified as a number, and the material prices matching this priority are updated. The group or range definition filter is used for the filtering operation.
VAT filter line indicates whether or not VAT is included in the price, while the Currency Type filter line is used to select a currency type in order to process the prices of the materials for which the price is specified with the same currency.
The Present Unit Price filter line is used to specify the materials to be updated by present unit prices, while the End Date of Present Unit Price line can be used to filter prices by the end date of the present price.
The Transaction Type filter line is used to specify the usage method of the updated prices.
When "Add New Definition" is selected, a new material (class) sales price is generated, and the validity date of the old price is updated.
When "Card Will Be Updated" is selected, the new price resulting from the update is transferred into the Unit Price field of the material (class) price, and the record information is updated.
The Validity Date of New Unit Price filter line is used to specify the date range on which the new prices will be applied. These dates are recorded in the start date and end date fields of the material (class) sales prices.
The Update Method indicates how the prices will be updated. This filter line contains two options: New Price and Factor.
When New Price is selected, the new price value is entered directly into the New Price filter line.
When Factor is selected instead, the factor to be processed for price update is entered into the Update Factor (%) field.
The Rounding Base filter line indicates the rounding base for decimal prices.
The Old Price Priority Info filter line is used to specify the priority information, and how this priority will be transferred into the new price.
When "Increase" is selected, the priority of the old prices are increased by one and transferred into the new price.
When "Use as is" is selected instead, the priorities of the old prices do not change.
The Division filter line indicates the divisions for which the material prices will be updated.