Define Settings for Stock Update in M3

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:

• Accounting events file - CAEVEN
• Accounting exceptions file - CAEXEL
• Allowed keys for user-defined matrixes - CPMKEY
• Accounting setup - CASTDV
• Start values and parameters file - CSYSTR

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/J).