Confirmation Orders Parameters

The Confirmation Order Data program processes the order data coming from the factory after a part order has been created.

Confirmation Orders Parameters Form

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 > Confirmation orders > [Company] on the parameter configuration utility browser.

Tabs:

General 1
General 2
Reports
Uplifts

General 1 Tab

Confirmation order type: The confirmation order program can import different types of confirmation order interface data files:

AUTO: Automatic file format detection
The confirmation order data program will automatically detect the confirmation order file type at them moment of import.

STD: SPICS format (Europe)
This file is used in Europe and is delivered from the SPICS system. This file does not contain invoice information.

SPM: SPM@MB
This file format is used when SPM is used at the importer. SPM is the replacement system of SPICS.

GLC: Global Logistic Center
This is the file that is delivered from the EKOS system to the importer. This file also contains invoice information.

RLC: Regional Logistic Center
This is the file type that is used by the Regional Logistic Centre. This is the same type as the GLC but the processing logic for backorder releases is different. The header record contains 88 (Singapore) or 96 (Dubai) on position 60-61. This file also contains invoice information.

EKOS: ELC (Dealer)
This is the file that is generated on the EKOS system and is delivered to the dealer. This file does not contain invoice information.

XML1: Autoline format
This is the Autoline format of the confirmation order data file in XML format and is functionality wise comparable to the EKOS format. This file does not contain invoice information.

XML2: Autoline format including invoice details
This is the extended version of the XML1 format where also invoice details are included. The functionality of this format is similar to the GLC format. This file also contains invoice information.

File import and automatic processing

Import directory: Base location on Autoline server where the confirmation order data files are located. It is possible to use variables within this field. For example, ^KEY(MB)[ms_mb_param_xfer]/Receive.

Confirmation order file name: The confirmation order filename that needs to be imported. It is possible to use wildcards in the filename. This will import all files that match the mask in the specified directory. It is possible to use variables within this field. For example, BVG[ms_mb_param_compclin].

Enable import in the EOD: Defines that the order confirmation import file is to be automatically imported via the Timed Operations (EOD).

EOD default terminal id: Enter the terminal id which is used to determine the printer for printing the picking slips in Timed Operations (EOD) in case the Automatic update fields is set to ‘5 - Print picking slips’.

Automatic update: Defines the areas of Purchase Control to be updated automatically at the moment of importing a confirmation order file.

- Do not update purchase control: No update will be done to the lines in purchase control when importing a confirmation order file.

1 - Process backorders: Backorder information will be processed when a confirmation order file is imported.

2 - Process backorders and confirmations: Backorder and confirmation information will be processed (including navigation PIN orders on IMS systems) when importing a confirmation order file.

Note: Option ‘2 - Process backorders and confirmations’ is unavailable if order type C is set up in the POS-parameters as a valid order type. Order type C is in conflict with the status of the purchase transaction line if a line is confirmed.

3 - Advice purchase orders: All lines (confirmation, backorders, c-codes, cancellations, navigation pin record) will be processed automatically. Invoice data (if available) is also automatically accepted and the uplifts are applied to the corresponding confirmation order lines. The purchase transactions which are confirmed will have the advice status.

4 - Receive purchase orders: Updates equally to ‘3 - Advice purchase orders‘, but the mass received program is triggered to receive the advised purchase transaction lines into stock.

5 - Print picking slips: Updates equally to ‘4 - Receive purchase orders’ and additionally prints the picking slips after importing the confirmation order file(s) in timed operations.

Note: Options 4 and 5 are not available in combination with Advanced parts integration.

POS operator: POS operator to be used when the confirmation order program is automatically receiving the purchase transaction lines after import. Only available if Automatic update is set to ‘4 - Receive purchase orders’.

Update the price file: Defines if the price file is to be maintained.

- Update: The price file record is updated or created based on the confirmation order data (Default).

N - No update: No new price records are created and existing price records are not updated.

I - Update from Invoice: The price file record is updated and created with the information from the invoice details. This setting can only be used in combination of confirmation order type GLC or RLC.

E-Mail address: E-mail address of the responsible person when a new confirmation order data file is imported in the EOD.

Import order range: Only orders within this range are imported for this purchase control company. This can be used when one MB dealer number applies too more than one Purchase Control Company.

Note: The Import order range parameter is only available for Confirmation order type STD.

Import marketing code: The marketing code is in some versions of the GLC, EKOS and RLC confirmation order types part of the description field of the confirmation record (record type 53). Select to import this marketing code and update the price file. Clear if the parts description field does not contain the marketing code (position 206-211).

Note: The Import marketing code parameter is only available for Confirmation order types: AUTO, GLC, RLC and EKOS.

Data processing and default settings

Default search option: Select the default way of searching in the confirmation order program.

1: Order number

2: Delivery note

3: Invoice number

4: Original order

5: Processing errors

Tip: The confirmation order program will remember the user’s last selection, and will overrule this parameter.

Default franchise letter: This is the default franchise letter that will be used for finding the lines in purchase control and stock management. The supplier-franchise mapping table or dealer numbers parameters can overrule this.

Prompt for order notes: Confirmation order files generated with the generate dealer confirmation order program can contain additional order header notes. The user can be prompted for these notes based on the selection:

- Do not prompt for notes: The user will not be prompted if there are new notes.

1 - Upon entering program: The user will be prompted if there are new notes when starting the confirmation order program.

2 - When opening order, deliverynote or invoice: The user will be prompted with the notes for the selected order(s).

3 - Both: The user will be prompted when entering the program and opening an order, delivery note or invoice.

PC update priority: The priority that the user needs to update the lines on the purchase order from the conformation order program.

Link on reference: Select to indicate that the order reference number is the default setting for Matching lines on reference.

Invoice number in reference: Select if the invoice number should be stored in the GRN field on the purchase order line when the line is advised. Only for the types GLC and RLC.

Suppress ES1: Suppress supplementary key ES1 (01, 02, 04-06 and 64-69) from the delivered part number on import. Alternative ES1 codes can be defined in the MB table ES1EXCLUDE by selecting the ES1 codes button on this form.

Update line on WIP: Update the line on the workshop order that is linked to the line in Purchase Control.

Upgrade quantity on WIP: Update the line quantity on the workshop order that is linked to the line in Purchase Control

Supersessions creation: Define if the supersessions is to be updated/created, based on the information received in the confirmation order file.

: Update MB supersessions

1: Do not create C23/C99 supersessions

2: Do not update MB supersessions

PC confirmed status letter: Enter an alphabet letter which is used in purchase control to indicate the confirmed status. This should not be an existing order type.

Note: The ’PC confirmed status letter’ parameter is no longer used for SPM confirmation order files.

Virtual warehouse: Select this option to create automatically Purchase control headers and lines for those items that are received according to the confirmation order data files (only applicable when Virtual warehouse installed).

General 2 Tab

Purging Data

Days till purge processed records: Defines the number of days until the processed lines in the confirmation order data files are purged.

Days to purge information log: Defines the number of days until the processed lines in the confirmation order log data files are purged.

Days till purge additional files: All data for Confirmation order types GLC or EKOS are stored in additional files. The data in these additional files will be purged after the number of days that is specified here.

Generate Dealer Orders

The Generate Dealer Orders section is only available for IMS systems.

Virtual warehouse: A virtual warehouse does not do the handling of parts, only use the confirmation order data.

Create dealer orders: An entry for every confirmed order line will be created in the dealer order file. With this file is it then possible to create a WIP from the information in this file with the Import Dealer Orders function in Point-of-Sale. This requires dealer details in the dealer parameters.

POS Department code: Enter the department code that is put on the WIP that is created with the Import Dealer Orders function. This department code is also used to create workshop orders for the navigation pin orders.

Advanced parts integration:

The Advanced parts integration section is only available if Advanced parts is installed and the parameters for selected purchase control company are setup. In addition is it required to have the Mercedes-Benz advanced parts integration module installed which is part of the product ’MS-MB-MBADVPARTS’.

Advanced parts integration: Select to use advanced parts shipping module for goods received.

Note: If Advanced parts integration is selected, the Automatic update parameter is limited to status ’3 - Advice purchase orders’ in the confirmation order program, as parts receiving will be handled by die advanced parts software.

Reports Tab

It is possible to define up to 5 different reports that can be called directly from the confirmation order program. Enter here the name of the report definitions that you want to add.

Standard Reports Available:

These standard reports can be used as a template and are part of the confirmatin order data product.

MS/MB1 - Confirmation order contents

MS/MB2 - Confirmed order lines

MS/MB3 - Backorder information

MS/MB5 - Confirmation order log information

MS/MB11 - Automatic processing errors which are outstanding

Uplifts Tab

The Uplifts Tab is only available for Confirmation order types AUTO, GLC, RLC, SPM and XML2.

Confirmation order invoice date include also different charges. Most of these charges are related to the parts cost price (for example transportation charges) and these costs are applied as an uplift on the normal cost price of a part.

Other charges are not direct related to the parts (for example Environmental charges) and should therefore not increase the cost price of the part. These charges should be posted as a separate value into purchase ledger.

The Uplifts tab contains a mapping table, which maps the uplifts in the Confirmation Order Data fields with the Purchase Control Uplift parameters function.

After you have created all the uplift types, you must select the Add/modify Suppliers option from the Multi-Source menu to set the correct order type for the Purchase ledger account of the supplier.

Note: The Order types can be set-up in the Main-Tables-Fastrack parameters of the Point of Sale module. For every Order type, a supplier record should be created. When the order type is not found, order type S is used.

Fields:

Invoice processing: Defines the method of invoice processing

N : Invoice uplifts not mandatory

Y: Force uplifts before updating purchase control

V: Automatic invoice verification

Verification priority: Minimum priority a user must have in Purchase Control to accept invoices for verification, where the invoice value in confirmation orders do not match the total goods value in purchase control. This is also the minimum priority a user must have to mark invoices for manual processing.

Uplift Mapping Table

With this table the charges that are delivered in the confirmation order file are linked to the uplift codes in the Autoline uplift table.

The uplift parameters do allow the use of a ? as a wild card to support multiple uplift codes matching the mask in the situation where multiple suppliers are used.

Packing charges: Select the uplift associated with Packing charges.

Freight/postage charges: Select the uplift associated with Postage charges.

fob-charges: Select the uplift associated with FOB charges.

Sea/air freight charges: Select the uplift associated with Sea/air freight charges.

Insurance charges: Select the uplift associated with Insurance charges.

Consular charges: Select the uplift associated with Consular charges.

Rental charges: Select the uplift associated with Rental charges.

Shipping charges: Select the uplift associated with Shipping charges.

Collection charges: Select the uplift associated with Collection charges.

Loading charges: Select the uplift associated with Loading charges.

Container charges: Select the uplift associated with Container charges.

Railway rental charges: Select the uplift associated with Railway charges.

Other charges: Select the uplift associated with Other charges.

Warning: It is important that the uplift for the other charges is NOT setup as an uplift type on the supplier record. This will avoid that the charges will be applied to the cost prices of the parts on the invoice.

Note: You may map different charges to the same uplift code.

File Name Variables

Within the parameter fields Import directory and Confirmation order filename it is possible to use variables. These variables are expanded on the moment that the confirmation order file import is done. The following variables can be used:

Variable	Description
%dd	Current day
%mm	Current month
%cc	Current century
%yy	Current year
%dn	Current day number (from 1^st of January)
%hh	Current hour
%MM	Current minute
%ss	Current seconds
%jd	Julian day number
^COM	Current company
^MOD	Current module
^ENV(..)	Environmental variable
^KEY(..)	Used to force that the parameter is read with the key in this field. It is only possible to define one key element for all the defined parameters in a field. This parameter must be at the first position in the field.
[..]	By entering a string within square brackets allow you to read a record in a file. The current selected Purchase control company number or the key specified in the ^KEY(..) parameter is used to load the record.