Invoice and Credit Status Sync Process

This section describes the process to import AR Account customer invoices from OPERA Cloud into ERP Account Receivables.

Import invoices exported from OPERA Cloud for AR Account customers from OPERA Cloud into ERP Account Receivables.

Propagate the credit status of customer accounts across all properties based on the ERP Account Receivables Customer Account Balance report.

The following mapping is used between OPERA and ERP invoice data objects.

Table 3-2 OPERA PMS to ERP Invoice Object Mapping

OPERA Object	ERP FBDI Object
HOTEL CODE	Line Transactions Flexfield Segment 1
TRANSACTION TYPE	No direct mapping to ERP
N/A	Transaction Batch Source Name – This field is mapped with the corresponding value for each Hotel Code as configured in the ERP system.
N/A	Transaction Type Name – This field is mapped per the ERP system configuration. A value configured in the ERP system is used from lookup for all the invoice imports into ERP.
PAYMENT DUE DAYS	Payment Terms – The Payment Term value from the OPERA invoice is mapped to corresponding Payment string of the ERP system.
INVOICE NUMBER	The Transaction Number and Line Transactions Flexfield Segment 2.
N/A	Original System Bill-to Customer Address Reference – This field is mapped with the Account external system reference as updated by the Customer Sync – Create Account integration.
N/A	Original System Bill-to Customer Address Reference – The Address Id for the Account Number in the OPERA invoice line.
LINE	No direct mapping to ERP.
N/A	Transaction Line Type – Value ‘LINE’ fetched from lookup.
N/A	Transaction Line Description – CONF NUMBER, ARRIVAL, DEPARTURE, and GUEST NAME fields are mapped from the invoice line details.
GROSS AMOUNT	The Transaction Line Amount.
CURRENCY CONVERSION TYPE	The Currency Conversion Type.
CURRENCY CODE	The Currency Code.
INVOICE DATE	The Transaction Date and Accounting Date.
AR ACCOUNT NUMBER	N/A
N/A	Line Transactions Flex Field Context – The value mapped from lookup per ERP configuration.
CONF NUMBER	Line Transactions Flexfield Segment 3
ARRIVAL	Line Transactions Flexfield Segment 5
DEPARTURE	Line Transactions Flexfield Segment 6
GUEST NAME	Line Transactions Flexfield Segment 4
N/A	Taxable Flag – Mapped to ‘N’.
N/A	Business Unit Name – The business unit Name of ERP corresponding to the Hotel Code.