Define Settings for Stock Update in M3

This document describes the accounting settings that you must define before you can update stock in M3 with sales ticket information from an external point of sale (POS) system.

Outcome

Accounting events and rules for how to update the stock in M3 with sales ticket information are defined.

M3 internal accountings are updated according to set rules. The accounting events and rules reserved for sales tickets are automatically retrieved when the internal accountings are updated.

These files are updated:

Follow these steps

Define accounting events to enable stock update

  1. Start 'Accounting Event. Open' (CRS375/B).

  2. Press F14=Standard to generate the accounting events.

    The following accounting events will be used for sales tickets:

    OP05 - Sales ticket returns

    OP10 - Sales ticket delivery

    OP20 - Sales ticket invoicing

    These accounting events are used when internal accountings are updated from sales tickets rather than from OI05 (Customer returns), OI10 (Delivery to customer) and OI20 (Invoicing – CO), which are used for customer orders.

    OP05 is used for record type 1200=Credit note.

    OP10 is used for record type 1000=Sales.

    Events OP05 and OP10 are balanced by event OP20.

Define accounting rules to enable stock update

  1. Start 'Accounting Rule. Set' (CRS395/B).

  2. Press F14=Standard to generate the accounting rules.

    This table shows the accounting events and accounting types that are connected:

    Accounting event Accounting type Description

    OP05

    904

    Sales ticket return - customer return not inspected

    OP05

    910

    Sales ticket return - inventory

    OP10

    910

    Sales ticket delivery - inventory

    OP10

    951

    Sales ticket delivery - delivered, not invoiced

    OP20

    101

    Sales ticket invoicing - cash payment

    OP20

    111

    Sales ticket invoicing - VAT payable 1

    OP20

    112

    Sales ticket invoicing - VAT payable 2

    OP20

    120

    Sales ticket invoicing - revenues

    OP20

    131

    Sales ticket invoicing - discount 1

    OP20

    132

    Sales ticket invoicing - discount 2

    OP20

    133

    Sales ticket invoicing - discount 3

    OP20

    134

    Sales ticket invoicing - discount 4

    OP20

    135

    Sales ticket invoicing - discount 5

    OP20

    136

    Sales ticket invoicing - discount 6

    OP20

    951

    Sales ticket invoicing - delivered, not invoiced

    OP20

    971

    Sales ticket invoicing - cost of sold goods

    OP30

    370

    Advance payments - bank account

    OP35

    100

    Invoice payments - accounts receivable

    OP35

    101

    Invoice payments - cash payment

    OP35

    111

    Invoice payments - VAT payable 1

    OP35

    112

    Invoice payments - VAT payable 2

    OP35

    301

    Invoice payments - realized exchange gains

    OP35

    302

    Invoice payments - realized exchange losses

    OP35

    310

    Invoice payments - cash discount given

    OP40

    211

    Sales tickets petty cash - VAT receivable 1

    OP40

    212

    Sales tickets petty cash - VAT receivable 2

    OP40

    701

    Sales tickets petty cash - petty cash expenses

    OP50

    101

    Daily takings

  3. Select an accounting rule and click Create to proceed to the E panel.

  4. On the E panel, specify the accounting strings.

    If necessary, fill in the control field on the F panel and specify exceptions in 'Accounting Exception. Open' (CRS396), which you open through option 11='Exceptions' in (CRS395/B).

  5. Repeat these steps for all accounting rules. Click Close to finish.

Parameters to set

In addition to the accounting events and accounting rules described, the parameters in this table must also be defined to update M3 stock:

Program ID/Panel Field The field indicates …

(OPS500/G)

Inventory accounting interface

… whether the M3 stock system is to be updated with sales tickets received from an external POS system.

POS interface parameters are managed in 'Settings - POS' (OPS700). The inventory accounting batch interface is managed in 'POS Sales Ticket. Update' (OPS280).

Note that the M3 stock system will not be updated unless the 'Inventory accounting interface' field is selected in both 'Shop. Open' (OPS500/G) and in 'POS Sales Ticket. Update' (OPS280/E).

For more information about shop settings, see Create a New Shop.

(MMS005/H)

Retrieve stock transactions

… whether messages retrieved from the POS system are to update M3 stock transactions when using batch entry in (MMS870).

The messages retrieved in this way can be displayed and updated in 'Internal Stock Msg. Manage' (MMS850). Only messages with permitted qualifiers, as defined in 'Internal Stock Trans Qualif. Open' (MMS860), are transferred.

(OPS700/E)

Customer order type

… a customer order type, which is an ID for settings that determine how the order is processed during order entry.

A customer order type must be defined in 'Settings - POS' (OPS700/E). The CO type entered on this panel will be reserved for sales tickets only. Thus, it will not be available for use when entering customer orders in 'Customer Order. Open' (OIS100).

(MWS010/F)

Create accounting entries for stock transactions

…whether financial transactions are to be created from stock transactions. The dispatch policy must be connected to the CO type indicated in 'POS - Settings' (OPS700/E). You must connect a dispatch policy to a customer order type in 'CO Type. Open' (OIS010/G).

Related topics