Define Settings for General Ledger Update in M3

Outcome

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

The general ledger in M3 is updated with sales ticket information according to the set rules. The accounting events and rules reserved for sales tickets are automatically retrieved when the general ledger is updated.

The following files are updated:

• Accounting events file-CAEVEN
• Accounting types file-CATYPE
• Start values and parameters file-CSYSTR

Before you start

• The 'Financial interface' field must be selected in 'Shop. Open' (OPS500/G).
• The parameters listed in Define Basic Settings for Enabling POS Integration with M3 must be defined.

Follow these steps

Enter new FAM functions

1. Start 'FAM Function. Open' (CRS405/B).

2. On the B panel, press F14=Standard to generate the default FAM functions.

   The following FAM functions will be used for sales tickets:

   OP20-Sales ticket invoicing

   OP30-Advance payments

   OP40-Sales ticket petty cash

3. Select a FAM function and select the Details option to proceed to 'FAM Function. Open Details' (CRS406/E).

4. If necessary, enter voucher series, voucher name and from and to dates. Press Enter and (CRS405/B) will be displayed.

   Repeat steps 3 and 4 for the remaining FAM functions if you need to add new information.

Enter new accounting events

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

2. On the B panel, press F14=Standard to generate the accounting events.

   The following accounting events will be used for sales tickets:

   OP20-Sales ticket and refunds

   OP30-Bank remittances

   OP40-Petty cash expenses

Enter new accounting type

1. Start 'Accounting Type. Open' (CRS385/B).

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

   The following accounting type will be used for sales tickets:

   701-Petty cash expenses.

Enter new accounting rules

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

2. Press F14=Standard to generate the accounting rules. The following accounting events and accounting types 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 select Change to proceed to the E panel.

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

   If necessary, fill in a control field on the F panel and enter exceptions in 'Accounting Exception. Open' (CRS396), which you can start by selecting the related option=Exceptions in (CRS395/B).

5. Repeat the procedure from step 11 onwards for remaining accounting rules and click Close to finish.