Download Sales Price List Information from M3 to an External POS System

Outcome

Basic sales price list information is transferred to the OPTRFI and OPTRML files in M3. Information is prepared in these files that enables the POS system to retrieve the price list information.

The POS system retrieves the downloaded price list information and any modification made to basic data in M3 is passed on to the POS system.

When basic data is exported from M3 to the external POS system, it is available in the OPTRFI file. For each record, an action code indicates the source file (the item master file MITMAS or the customer file OCUSMA, for example) and the record information is stored in a data field.

Each record in the OPTRFI file has an associated mailing list in the OPTRML file. This is a list of shops to which each record must be sent.

Before you start

• A shop must be created in 'Shop. Open' (OPS500) and the 'POS system interface' field must be selected in (OPS500/G).
• The 'Sales price interface' field must be selected in 'Shop. Open' (OPS500/G).
• The sales price lists you want to download from M3 must be specified in (OPS500/H). Up to 3 price lists can be selected. Note that only sales prices specified in a price list in 'Sales Price List. Open Basic' (OIS021) can be transferred. For example, sales prices from the item file or blanket agreement will not be considered.
• A currency method for the export of price lists must be defined in (OPS500/H). If this field is selected then all currencies connected to the price list code will be used. If it is not selected then the division's currency will be used.

Follow these steps

1. Start 'POS Price. Transfer' (OPS616/B).

2. Specify a report version identity of your choice in the 'Report version' field. Select Create to display the E panel.

   Report versions are stored under an identity of your choice in a separate file containing sets of selections and sorting parameters for created reports.

3. On the E panel, specify a warehouse (=shop).

   If no warehouse is specified, sales price information will be sent to all the POS-interfaced shops that allow sales price interface (OPS500/G). An item's sales price cannot be exported if the item has not been specified in the item-warehouse file for the interfaced shop in 'Item. Connect Warehouse' (MMS002).

4. Specify selections for sales price lists, currencies, customer numbers, and valid from dates. Press Enter to display the B panel.

   If you want to export price lists expressed in different currencies, the 'Currency method' field in 'Shop. Open' (OPS500/H) must be selected. Otherwise only the price list(s) expressed in the local currency will be exported.

   Note that only the sales price lists connected to the shops in (OPS500/H) can be downloaded.

5. On the B panel, select your report version and select option 9=Run to perform the download.

   The OPTRFI and OPTRML files are updated and the information is ready to be retrieved by the POS system. The action code is 'RTVPRI', that is, retrieved from the price list file.