See also: Menu Bar And Toolbar Definition
The parameter for the assigning of the price file are used, to update the parts in stock with information from the price file.
The assignment of the VAT code for new stock records can be done on three different levels.
VAT code assignment based on the VAT code stored on the price file record: The VAT code stored on the MB Parts Price File record has the highest priority. If a valid VAT code is available on the MB Parts Price File record, it will be assigned to the stock record when creating or updating a stock record according to the Pulled Fields 2 parameters.
VAT code assignment based on the marketing code: When the VAT code from the MB Parts Price File record is not assigned to the stock file record, then the VAT code can be assigned using the Support & Analysis code mapping. Depending on this Marketing code on the MB Parts Price File record, it is possible to assign the Supplier, Analysis code, Product group and VAT code.
VAT code from the default stock record: When the VAT code is not assigned from the MB Parts Price File record nor assigned using the Support & Analysis code mapping, then the VAT code is taken from the Stock File; Initial record form. This form is displayed when you click Stock management (Module) and [Company] > System maintenance > Default stock record.
During creation of a new Purchase order line, the VAT code from the corresponding Stock record is stored on the Purchase order line.
When the Confirmation order function sets the Purchase order line status to A(dvised), the VAT code on the Purchase order line is updated again with the VAT code of the Stock record at that moment. Consequently all linked WIP order lines are updated as well based on the following conditions:
The current VAT code on the WIP line is the same as the original VAT code on the Purchase order line (the VAT code on the WIP line is not manually changed).
The VAT code on the Sales Ledger account which is on the WIP is S (using standard VAT).
This will ensure that the VAT code from the Stock record is used when receiving the parts into stock and the same VAT code is used to invoice the parts to the customer.
This form is displayed when you click Manufacturer systems (Module) and MB. Mercedes-Benz (Company) > Menu - Utilities > Mercedes-Benz parameters and you browse to + Parts > + Assign Pricefile > [Company] on the Project parameters browser.
Tabs:
Exchange-part processing
Exchange-part processing: Select, if you want to use Exchange parts processing in Point of Sale.
Use average surcharge: Select to use the average cost of surcharges to calculate the stock values in End of Period. If selected, an extra field Average cost Surcharge will be available on the Display stock card and Stock file maintenance forms which will be used in the Stock EOP update calculations.
Note: The Use average surcharge option is only availalbe if Exchange-part processing has been selected.
Buyback: Exchange price of the Master price file is updated into the selected field.
Buyback minus discount%: Exchange price minus discount % of the Master price file is updated into the selected field.
Pull prices to stock-record
Retail: Retail price of the Master price file is updated into the selected field. If the part is indicated as exchange part in the Master price file and the Assign price file and Price file parameter regarding Exchange parts are set right, the value of the Retail price minus the Sale Surcharge price of the Master price file is updated into the selected field.
Wholesale: Wholesale price of the Master price file is updated into the selected field.
VLP in currency: VLP (Vender List Price) of the Master price file is updated into the selected field.
VLP base-currency: VLP (Vender List Price) of the Master price file is updated into the selected field in base-currency.
VNP in currency: VNP (Vendor Nett Price) of the Master price file is updated into the selected field.
VNP base-currency: VNP (Vendor Nett Price) of the Master price file is updated into the selected field in base-currency.
Retail minus discount%: Retail price of the Master price file minus the discount% is updated into the selected field in base-currency.
Alternative description-1: Selected language is assigned to the alternative description 1 of the stock file.
Alternative description-2: Select the language is assigned to the alternative description 2 of the stock file.
Parts-category and MLI-code
MLI-code (maintained in price file): Select for automatic update the stock record with the MLI-code from the price file.
Part category (maintained in pricefile): Select for automatic update the stock record with the Part category from the price file.
Discount (RG) code = MLI-code: Select for automatic update of the discount code field on the stock record with the MLI code from the price file.
The Pulled fields 2 tab gives the possibility to determine how fields must be assigned to the stock file.
If Discount (RG) code = MLI-code on the Pulled Fields tab is not selected, the discount code is updated with the discount code from the list where the Effective date, Discount code, Retail price, Wholesale price, Vendor List Price, Vendor Net Price or Exchange price are displayed in the Master price file.
Because the source of the price file is M (franchiser Mercedes-Benz) the Product group is updated with the concerning code.
You can enter one of the next values, for all the parameters listed on this tab:
A - Always update regardless the contents of both fields
N - NO update when field in stock file has a valid value
X - Exclude from update
Y - Update when field in price file has a valid value
A field is significant when it is unequal to null or zero.
Note: Not every type of Mercedes-Benz price file format supplies VAT codes. Currently only the Parts catalogue and CSV-Import types supply VAT codes.
The Supplier & Analysis tab contains information about the Supplier code, Analysis code, Product group and the VAT code via the first 6 digits of the Marketing code on the Price file record. You can set up these defaults in the matrix, which will overwrite the default stock record in Stock Management, depending on the Marketing code and / or the Vendor code.
Via a right-click on the column headings to maintain the Matrix on the Supplier & Analysis tab, you can select one of the options: Add, Amend, Delete or Stop.
Only for new parts to be created in the stock-file, the Analysis code can be assigned depending on the marketing-code and or vendor code. On existing parts in stock the Analysis code will not be overwritten.
The vendor code indicates the market that has manufactured the part which is used on IMS systems in Asia.
Tip: Click the Info button, to display a form with instructions.
Note: The VAT codes, displayed in the list when clicking the VAT code field, are set up in the Nominal ledger VAT code & rates.
The MLI code on the stock record will be populated with the value as per the defined parameters. It can be populated with specific digits of the Marketing code, with a fixed value or with the MLI code on the pricefile (default).
Matrix to convert to MLI code on stock file:
1 - Use MLI code from price file: The MLI code specified in the price file will be used as the MLI code on the stock record. This is the default option and will be used in case no valid record can be found in the assignment matrix.
2 - Use specified value as MLI code on stock record: The value specified in the column Mapping/value will be used as MLI code on the stock record.
3 - Use specified positions from marketing code: The specified positions of the MLI code on the pricefile, as defined in the column Mapping/value will be used as the MLI code on the stock record.
MLI code matrix Grid:
MK1: Enter the specific first character of the MLI code on the pricefile to define the MLI matrix. The character ? is used if no specific character is required to define the MLI matrix.
MK2: Enter the specific second character of the MLI code on the pricefile to define the MLI matrix. The character ? is used if no specific character is required to define the MLI matrix.
MK3: Enter the specific third character of the MLI code on the pricefile to define the MLI matrix. The character ? is used if no specific character is required to define the MLI matrix.
MK4: Enter the specific fourth character of the MLI code on the pricefile to define the MLI matrix. The character ? is used if no specific character is required to define the MLI matrix.
MK5: Enter the specific fith character of the MLI code on the pricefile to define the MLI matrix. The character ? is used if no specific character is required to define the MLI matrix.
MK6: Enter the specific sixth character of the MLI code on the pricefile to define the MLI matrix. The character ? is used if no specific character is required to define the MLI matrix.
VENDOR: Enter the vendor code (2 digits) of the part on the pricefile for this MLI matrix.
TYPE: Enter the Type to be used to populate the MLI code on the stock record.
Mapping/value: Enter the value to be used as MLI code if TYPE 2 is selected or enter the specific positions of the MLI code to use if TYPE 3 is selected.
Note: The MLI code on the stock file will only be populated if the parameter MLI-code on the Pulled Fields tab is selected.
Discount-code & Product-group
Length discount code: You can fill in the length of the Discount code up to a maximum of 3 positions.
Length product group: You can fill in the length of the Product group up to a maximum of 3 positions.
Mandatory on order when Theft Considerable (IMS)
Slot (1/2) and code (1-4) mandatory-on-order in case theft considerable part: You must fill this field if a stock record of the importer is indicated as theft considerable parts, with code D. In the stock record you can set up two Mandatory on order fields. The two fields are slot (1/2) in this parameter. The list of the Mandatory on order field contains several descriptions (Code 1-4). For instance: when you type 13 it means, description three of the list of the first field (slot) of Mandatory on order. Blank means that no slot is selected.
Mandatory on order when Theft Considerable (DMS)
Slot (1/2) and code (1-4) in case Theft-considerable part content is 2, 4, 5 or 7 :You must fill this field if a stock record of the dealer is indicated as theft considerable parts, with code 2, 4, 5 or 7. In the stock record you can set up two Mandatory on order fields. The two fields are slot (1/2) in this parameter. The list of the Mandatory on order field contains several descriptions (Code 1-4). For instance: when you type 13 it means, description three of the list of the first field (slot) of Mandatory on order. Blank means that no slot is selected.
Preferred Vendors
First Preferred Vendor: If there is more than one part available for different vendor codes, the First Preferred Vendor is taken as a default. After that the vendor codes in the next parameters is taken.
next: Enter the next preferred vendor
Retailprice dirty /70 parts
If NOT using surcharge-values, the retailprice of the dirty /70 parts will be populated as follows: Used in an IMS system. To activate this parameter; you must clear the Exchange-part processing parameter on the Pulled Fields tab. Select if you want to fill the retail price in the stock record of /70 parts with the C - Cost of surcharge or S - Sale of surcharge. If you do not want to use this functionality, select N.A.
The tab Measure units provide the possibility to link the measure units of the MB-price file with the measure units of Autoline. Additional you can decide, whether it is possible to work in decimals for defined measure units.
Grid:
Measure unit: Displays the Mercedes-Benz measure units.
Unit of stock: Select the Autoline measure unit to linked to the concerning Mercedes-Benz measure unit.
Decimals: Select to indicate that the measure unit can be sold in decimals.
Field
Update existing stock record: The measure unit mapping is by default only used when creating new stock records. Select this field to use the measure unit mapping for all existing stock data records when Update stock from price file option is run.
Tip: The stock record fields Decimal quantities and Unit of stock on the Description tab as well as the Unit and Per fields on the Prices and Costs tab of the stock record(s) will be updated accordingly.
Note: The measure units must be linked for each warehouse company.