Refund Write-Back

This is a function to capture refunds processed in Sage 300 and record them in OpusXi as a negative receipt.

This tool is run from the Sage 300 desktop, and follows same principles as the AR Receipt Write-Back tool.

Screen Title

This is the screen title: AR Refund Write-Back to OpusXi

Type	Notes	Rules	Compulsory	Format	Edit	Size	Default	Error Message
Screen Title

This is a lookup to the AR Refund batch numbers.

Type	Notes	Rules	Compulsory	Format	Edit	Size	Default	Error Message
Lookup		Table: ARRFB Field: CNTBTCH	Y

This is the corresponding batch description, shown for user information.

Type	Notes	Rules	Compulsory	Format	Edit	Size	Default	Error Message
Text		Table: ARRFB Field: BTCHDESC		Text	N

This is a function to read the refund entries in the selected batch and write refund (negative receipt) entries in OpusXi.

Type	Notes	Rules	Compulsory	Format	Edit	Size	Default	Error Message
Function		1. Write 1 OpusXi receipt record for each line entry in the Refund batch. Detailed field lists below. 1a. Repeat refund header data on each OpusXi receipt. 1b. Every OpusXi receipt entry to have a fixed Payment Type of "Refund". Prerequisite: creation of Payment Type "Refund" in OpusXi. 2. If ARIBH / INVCAPPLTO field is null (i.e. not matched to a source invoice) skip the line entry and continue to process. 3. Set the ERP sync field to completed. 4. Finish the processing sequence with a completion message that lists the unmatched refund entries.						4. Refund write-back process completed. The following entries could not be matched in OpusXi: [ARRFH / IDINVC] - [ARRFD / IDINVC] - [ARRFD / AMTHC]

Receipt Screen	Sage 300 table	Field	OpusXi data field	Sample	Notes
Sales & Booking	--	--	rece_OPSSaleID	10241
Receipt Date	ARRFH	DOCDATE	rece_receiptdate	13/01/2020
Payer	ARRFH	IDCUST	rece_idcust	1000006	If Person match in Xi
Company Payor			rece_companypayer	BAI001	If Company match in Xi
Receipt Number:	ARRFH	IDINVC	rece_accpacreceiptnumber	RF00003
Line Details: 1x receipt per line entry - header details repeat
Invoice (credit note)	ARRFD	IDINVC	rece_invoicenumber	CN00012
Payment Type			rece_paymenttype	Refund	Fixed
Amount	ARRFD	AMTHC	rece_Amount	1620	Multiply by -1

To identify the source Sales & Booking ID in OpusXi, from the credit note in the refund document:

1. Use the credit note on the refund	ARRFD	IDINVC	CN00012
2. Search the CN in OpusXi	OrderHeader	orhe_DocumentNum	CN00012
3. Identify the S&B ID	OrderHeader	orhe_OPSSaleID	10011
4. Write the Refund entry

This is a function to close the open window.

Type	Notes	Rules	Compulsory	Format	Edit	Size	Default	Error Message
Button