You can maintain the Price File records in the MB Master Price File form.
What do you want to do?
This form is displayed when you click Manufacturer systems (Module) and MB. Mercedes-Benz (Company) > Menu - Parts > Master Price File, or click Manufacturer systems (Module) and MB. Mercedes-Benz (Company) > Menu - Service > Menu - Standard Files > Master Price. It lets you maintain the Price File records.
Part number: Part number in manufacturers format.
Vendor: Vendor code or supplier code. Indicates from what factory the part comes from. This value is not delivered in every type of price file, in that case the part is created with the Default vendor-code of the Price file parameters. You can set the Assign pricefile parameters to update / load this field into the stock file field Line class.
Description: The description of the selected part. You can set the Assign pricefile parameters to update / load this field into the stock file fields Description and Alternative.
Tabs:
Buttons:
Cancel: Returns you to the previous menu.
Help: Displays this help topic in a web browser.
Create: Adds a new price file record, you start with a blank or make a copy.
Amend: Changing the selected price file record.
Delete: Deletes an existing price file record.
Save: Saves a changed or added price file record.
Cancel: Cancels a changed or new price file record.
Multi-lingual: You can add the description of the part to all languages that are standard set up in Autoline, when changing or adding a price file record.
Setup: Displays the contents of price file record in table.
In a grid the Effective date, Discount code, Retail price, Wholesale price, Vendor List Price (VLP), Vendor Net Price (VNP) or Exchange price for the part is displayed. All prices are displayed preceded by a currency code. To view or edit the values in the Price values form press the F2-key, or alternatively left-click in the Price generation grid when in edit mode.
A history is kept for only a maximum of three lines. An update on any of the prices will always cause the introduction of a new generated line for all prices on this line. The oldest line will disappear from the master price file.
The fields of the General tab of the MB Parts price file form are described, when the price file is uploaded in the stock file these fields are reviewed.
IMS SystemsPacked part: Part number in packed format, do not change the generated number! The packed part number is used when creating or updating the part in the stock file.
Manufacturers part: May be used for alternative part numbers, or any other memo information required against the part record.
Marketing code: Provided for either user- or franchised-defined analysis purposes. It has an up to eight-character alphanumeric capacity. You can set the Assign pricefile parameters to update / load this field into the stock file field Sales code. The Marketing code identifies the part by his source, his category and his family. Depending on this marketing code, it is possible to assign the Supplier, Analysis code, Product group and VAT code.
Model type: Used to indicate which vehicle model the part will fit. You can set the Assign pricefile parameters to update / load this field into the stock file field Model code.
Height/Length/Width: Measurements in millimeters. You can set the Assign pricefile parameters to update / load this field into the stock file field Sizes or Length/Height/Width.
Nesting factor: Multiplies the volume of the part sizes by this factor. The volume is calculated by Height multiplied by Length multiplied by Width multiplied by Nesting factor.
Weight: Weight in kilograms. You can set the Assign pricefile parameters to update / load this field into the stock file field Weight (kg).
Volume indicator: Indicates which of the three pack size fits in the calculated volume: 1 = first pack size, 2 = second pack size or 3 = third pack size.
Pack sizes: Supply quantities of the part. In the first field the minimum supply quantity (if negative) is displayed. In the last field the GLC (Global Logistic Centre) storage quantity is displayed. This is the maximum supply quantity. You can set the Assign pricefile parameters to update / load the first field of these three into stock file fields Purchase factor (for IMS systems), Issued in and Recommended qty.
Min. order quantity: Economic buy quantity of the part. You can set the Assign pricefile parameters to update / load this field into the stock file field Economic buy quantity.
Unit of measure: Indicates the unit in which the part is delivered. The tab Measure units on Assign pricefile parameters provide the possibility to link the measure units of the MB-price file with the measure units of Autoline.
Tip: The option Update stock from price file will update the relevant measure unit fields on existing stock record(s).
Measure type: Filled with a single numeric character, to indicate the type of measure. 1 = each/piece, 2 = kg, 3 = meter, 4 = cbm (cubic measure), 5 = qm, 6 = litre, 7 = pair, 8 = gross and 9 = gram
Shelf life in months: Storage period in months or number of months for which a repeat movement of the part on the same vehicle is sensitive.
Use-up: Indicates if a part in a stock file is set to 1 (yes) or 0 (no) of Block Sales.
Country of origin: Sets the country of origin for this part. You can set the Assign pricefile parameters to update / load this field into the stock file field Country of origin.
Last update: Displays the last date a Master price file is updated.
Source: Displays for which franchise the Master price file is updated.
IMCO (danger) code: Used to hold the level of Volatile Organic Content (solvent) or Dangerous goods code present in the part. You can set the Assign pricefile parameters to update / load this field into the stock file field Dangerous goods code.
Exchange- or Dirty: Indicate if a part is D (Dirty Unit, /70 parts), E (Exchange part, /80 parts) or empty (Not an exchange part).
VAT code: Indicates which tax should be calculated. Some price files contain VAT codes. The value is not taken over into the stock record.
Price class: Indicates the price classification of the part. This is only used by Pricefile 180. This information is not taken over in the stock file.
Main factory: Code that indicates in which factory the part is manufactured. The value is not taken over into the stock record.
Code SNP: Indicates the code for the Special Net Price. This is only used by Pricefile 180. This information is not taken over in the stock file.
Theft considerable [D]: Filled with a D, 2, 4, 5 or 7 if the part is considered to be a theft considerable part. The D is mainly on IMS systems. The 2 (Chassis number mandatory), 4 (Engine number mandatory), 5 (Chassis number mandatory) and 7 (Key code mandatory) are mainly on DMS systems.
Statistic number: Indicates the Intrastat code used for foreign trade statistics.
Customs number: Indicates the customs code applied to this part. You can set the Assign pricefile parameters to update / load the first field of three into stock file field Product number / Customs code.
Assortment class: Assortment to which the part belongs. You can set the Assign pricefile parameters to update / load this field into the stock file field Assortment class and will only update if the alternative description 2 is not used.
Parts category: Category to which the part belongs.
MLI Code (Major Line Item): Indicates the sales discount code (01 up to and including 09) by which you can overrule the standard discount code when calculation the sales price. It is also possible to put de MLI code direct in the discount code of the stock record. See the Price file parameters.
Changes to the MLI code made by the master price file import, confirmation orders or calculate retail prices program will also update the MLI effective date and the Previous MLI code.
You have to change the MLI effective date and Previous MLI code yourself, if a manual change is required.
When IMS warranty reads the discount code on any of its calculations, it uses the following logic:
If the repair date of the current claim is greater or equal to the MLI effective date, take the discount code from the MLI code field.
If the repair date of the current claim is smaller than the MLI effective date, take the discount code from the Previous MLI code field.
If the MLI effective date field is empty, take the discount code form the standard MLI code field.
In the Part descriptions you can add / maintain a description per concerning language. These languages are set in the Price file parameters.
* This product is only applicable for IMS (Importer systems of Autoline). In Autoline, IMS parts price information is held in the Master price file. IMS requires more detailed price history information when processing warranty than DMS (Dealer systems of Autoline).
The standard price history list in the price file does not display enough information for IMS users. A history is kept for only a maximum of three lines. An update on any of the prices will always cause the introduction of a new generated line for all prices on this line. The oldest line will disappear from the master price file.
Warranty history:
For IMS the warranty relevant data (Vendor List Price) is bound to its own effective periods and stored within its own generation. Also the dealer discount groups are stored separately, because not all markets are using the same discount grouping for their dealers as the supplier uses in the direction of the importer.
Because IMS needs to store warranty data in its own effective periods, this tab for historical price information is added to the Master price file maintenance program, where discount and VLP are displayed separately.
The maximum number of lines per subject (Discount and Vendor list Price) is three. This tab is updated with a new line if the discount code, the VLP price or the VLP currency is changed. The oldest line is then deleted. You cannot change the information on the Price history tab.
Note: The information displayed on the General tab in the MB Parts price file form may partially overlap with the information displayed on the Price history tab.
Price history grid:
Effective: Display the original effective date of the price generation history record.
Disc: Display the discount code for the price generation history record.
Retail price: Display the currency code and the Retail price for the price generation history record.
Wholesale: Display the currency code and the Wholesale price for the price generation history record.
VLP: Display the currency code and the VLP price for the price generation history record.
Date updated: The date the price history record were created.
Source: Indicate which program/process created the price history record.
Note: The price history records will be purged as per the Deletion days price history parameter setup in Mercedes Benz - Price File Parameters.
A price history record is created if one of the following fields on the price file record is changed:
The above values can be changed within the following programs:
The fields on this XML price file tab are filled by the XML price file.
Indicator small assemblies: Displays the small assembly indicator code.
Factory indicator: Displays the factory indicator code.
Merchandise class (Chrysler): Displays the merchandise class.
Price symbol (Chrysler): Displays the price symbol.
Product line MOPAR (Chrysler): Displays the product line MOPAR.
Indicator local list price: Local list price indicator.
SPM migration date: The SPM migration date will be displayed if the SPM order splitting is active. This field is not editable.
* The Price Change Analysis is only available for Asian Importers!
After an importer has calculated it's selling prices for dealers, it has the possibility to create price files for its dealers.
The dealers can be divided into markets and for every market a dealer price file can be created. Every market for which a price file has been created, the part might have different export prices. If available the dealer price file is displayed on the Export Prices tab.