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

This document explains how you download sales price list information from M3 to an external point of sales (POS) system.

Note that this instruction only describes the manual flow for basic data download.


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

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.

Related topics