Manage the Payment Provider Ledger

This document is a guide on how to manage the payment provider ledger.

Introduction

The payment provider ledger manages the M3 BE account entries related to payment transaction from a third-party payment provider. An external reference, provided by the payment provider, keeps the link between the M3 BE account entries and the payment transactions managed by the payment provider.

Solution overview

The payment provider ledger is managed in two programs, 'Payment Provider Ledger. Display' (OPS290) and 'Payment Provider Ledger. Display Entries' (OPS291).

(OPS290) contains external references received from third-party payment providers, the references represent external transactions such as credit card payments. The records in (OPS290) contain an origin indicating where the external reference originates from, the origin ID is an identifier from this origin. For example, if the origin is 01-'Sales ticket', the origin ID is a sales ticket number. You can select option 11='Account entries' to launch (OPS291), displaying different account entries for the external reference.

(OPS291) can also be opened from the menu, this displays account entries for all external references in the payment provider ledger. Each account entry in (OPS290) contains an information type indicating the type of entry. Entries also contain accounting details such as accounting date, the seven accounting dimensions, and a reconciliation reference. The status of the entry indicates whether it has been transferred to the general ledger. You can select option 21='Display voucher' to view the voucher in the general ledger.

The program 'Payment Provider Ledger. Archive/delete' (OPS295) is used to archive references in (OPS290) and all associated account entries in (OPS291). A change date is entered. All references in (OPS290) that were updated to status 90 on this date or prior are included in the selection. Records that are not in status 90 must be manually processed before they can be archived.

All references with the same voucher number in (OPS290) as a reference in status 89 are excluded from the archiving run even though they have status 90. Correction ID OP01-'Cancel voucher from payment provider ledger' (OPS290) can be run in 'Program Problem. Solve' (CRS418) to process all records with status 89 to status 90 prior to archiving.

Workflow overview

External references in the payment provider ledger are managed in three steps.

  1. An external reference must be received from an origin. For instance, a credit card payment on a sales ticket from a point of sales system. For more details, see Update payment provider ledger with credit card payments from POS.
  2. The payment provider provides an update that the external reference is confirmed regarding, for instance, commission amount and VAT taken. A reconciliation reference is provided for the amount to be sent to a bank account. Account entries in (OPS291) are created using the API OPS291MI (Payment provider ledger entries). For more details, see Confirm transactions in the payment provider ledger.
  3. The account entries in (OPS291) are transferred to FIM using the API OPS292MI (Transfer payment provider ledger entries to FIM). For more details, see Transfer payment provider ledger entries to FIM.

Limitations

  • Only the transaction type for credit card payment is supported with the Point of Sales (POS) interface.
  • Credit card payments with the cash desk are not supported.
  • Credit card payments with customer order entry are not supported.

Setup

These criteria must be fulfilled for the payment provider process:
  • The 'Update payment provider ledger' (UDPL) setting must be activated in 'Settings - POS' (OPS700).
  • The 'FAM function for payment provider ledger' (FNPP) field must be defined in (OPS700).
Related topics