Define Settings for General Ledger Update in M3

This document describes what accounting settings you have to define before you can transfer sales ticket information from an external point of sale (POS) system and update the general ledger 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:

Before you start

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.

Related topics