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 |
...