Optional use of payment reversal data

Optionally, Customer Payment Reversal Entry data is available through ION BODs, SX.API calls, and Birst extracts. Because access to this data is not required for the functionality, you are responsible for any configuration and setup required to make use of this data.

ION BOD and SX.API changes:

Data is available with existing BODs and API calls that contain related database fields. You may require access to this data to send to another Infor product, a customer, or a third-party product.

ION BODs

No Inbound BODs contain the data. These Outbound BODs can add the payment reversal data with the SA Administrator ION Noun Setup function:
BOD SX.API
CustomerReturn OEEH.arrevdttmz and OEEL.arrevdttmz
SalesOrder OEEH.arrevdttmz and OEEL.arrevdttmz
CustomerPartyMaster ARSC.nonsf
Invoice OEEH.arrevdttmz and OEEL.arrevdttmz
SourceSystemJournalEntry GLET.bankno
ReceivableTransaction ARET.reversedfl. If set to “yes”, the payment has been reversed.

SX.API

These API calls contain payment reversal data:

SXapi Call REST Parameters Direction Description
sxapiARGetCustomerData t-fieldlist Output

Field Name: NoNSF

Field Value: >>>>>>>>9 (ARSC.nonsf)

Created new call:sxapiARGetCustomerDataCreditV2 t-infieldvalue and t-outfieldvalue Output

Field Name: NoNSF

Field Value: >>>>>>>>9 (ARSC.nonsf)

sxapiOEGetSingleOrderV2

t-fieldlist [for header]

t-oelineitem

Output

Field Name: DatePaidInvoiceReversal

Field Value: 99/99/9999 HH:MM:SS.SSS+HH:MM (OEEH.arrevdttmz)

Field Name: DatePaidInvoiceReversal

Field Value: 99/99/9999 HH:MM:SS.SSS+HH:MM (OEEL.arrevdttmz)

sxapiOEOrderChange

t-outoeordhdrextra

t-outoeordlineextra

Output

Field Name: DatePaidInvoiceReversal

Field Value: 99/99/9999 HH:MM:SS.SSS+HH:MM (OEEH.arrevdttmz)

Field Name: DatePaidInvoiceReversal

Field Value: 99/99/9999 HH:MM:SS.SSS+HH:MM (OEEL.arrevdttmz)

sxapiOEOrderCopyConvert na Output OEEH.arrevdttmz and OEEL.arrevdttmz are set to “?” on the new order when a copy is performed.
Created new call:sxapiSFGetOpenInvoiceV2

t-outfieldvalue

Output

Field Name: Reversed

Field Value: yes/no (ARET.reversedfl)

Created new call:sxapiSFGetOpenARTransactionV2

t-infieldvalue and t-outfieldvalue

Output

Field Name: Reversed

Field Value: yes/no (ARET.reversedfl)

Birst extracts for reporting

Optionally if you require access to Customer Payment Reversal Entry data for Birst use, these Birst extracts may be available:
Note: Contact your Infor representative.
Table Extract
ARET add ARET.payrowpointer and ARET.reversedfl
ARSC add ARSC.nonsf
GLET add GLET.bankno
OEEH add OEEH.arrevdttmz
OEEL add OEEL.arrevdttmz
PV_USER add PV_USER.nsfoverfl
SASC add AOData ARNSFFee, ARNSFWaiveFirstFeeFl, and ARAllowARPaymentReversals data