Managing Payment to Customer's Account

This document explains what happens in the point of sale (POS) system and in M3 when a customer wants to deposit money to his/her own account in a shop.

Outcome

Information about the customer and the amount to be paid is entered in the point of sale system. The money is paid to the customer's account and a cash receipt is given to the customer. Sales information is uploaded to M3 via a point of sale interface. The accounts receivable and general ledger are usually updated on a later occasion, but can sometimes be updated immediately.

The following files are updated:

  • Sales ticket input file-OPSALE
  • Accounts receivable file-FSLEDG
  • General ledger file-FGLEDG

Before you start

  • Accounting event OP35 must be defined in 'Accounting Event. Open' (CRS375).
  • Accounting types 100 and 101 must be defined in 'Accounting Type. Open' (CRS385).
  • Accountings for OP35 must be defined in 'Accounting Rule. Set' (CRS395).
  • Number series type 52 and number series 1 must be defined for invoices in 'Number Series. Open' (CRS165).
  • The 'Invoice payments' FAM function must be selected in 'Settings-POS' (OPS700).
  • A voucher number series for OP35 in 'FAM Function. Open' (CRS405) must be selected.

Follow these steps

  1. The customer wants to make a payment to own account

    The customer wants to make a payment to his/her own account at the point of sale in the shop. The customer can use the money on the account to pay for items bought in the shop, for example.

  2. Enter customer information in the point of sale system

    The customer number and the amount to be paid to the customer's account are entered in the point of sale system.

  3. Enter the payment to customer's account

    The payment to the customer's account is entered in the point of sale system and a cash receipt is created.

    Cash Receipt No. 123457

    Customer No.

    Amount

    10001 Deposit to account 500.00
    Subtotal 500.00
    Total 500.00
  4. Upload sales information to M3

    After the payment is entered, it is uploaded to M3 through the point of sales application programming interface 'POS sales tickets interface' (OPS270MI). Two different transaction types are used:

    • Transaction type 4500=Payment to account
    • Transaction type 4590=Payments

    Note that:

    • Stock levels are not updated.
    • The update of accounts receivable and the general ledger is sometimes performed immediately.

    The OPSALE sales ticket input file is updated as described in this table:

    Transaction type Customer No. Payment method VAT Amount
    4500 10001 500.00
    4590 10001 Cash (CSH) 500.00
  5. Update accounts receivable and the general ledger

    Accounts receivable and the general ledger are updated in batch through 'POS Sales Ticket. Update' (OPS280). The 'Financial interface' parameter in (OPS280) must be selected before batch is run.

    Transaction type 4500='Payment to account' is used to determine how the update of accounts receivable and the general ledger is performed. A record to the customer's credit is created in the accounts receivable. This record has to be matched manually against any open invoice.

    For the general ledger (FGLEDG), these accounting events and accounting types are created:

    Accounting event Accounting type Amount Customer No. Bank operation
    OP35 101 500.00 10001 45 (CSH)
    OP35 100 –500.00 10001

    Note that a bank operation is retrieved from the selected payment method.