Split Stream Processing Using the AR Excel Upload Deposit Process

You can submit both Customer and Item Remit records as Remit Only records through the AR Excel Upload Deposit process. The process searches the database and matches the Remit Only records with a deposit or payment already in the database that is normally processed through EDI, Lockbox, or any other process.

These basic rules apply to remit only processing:

1. The deposit or payment available for matching must be unidentified.

   If there are any remit records attached to the payment, the payment is ignored for matching. Incoming Remit Only records will not match to that payment. This process does not allow the user to add remit records to a payment that already has remit records.

2. Remit only records coming from Excel can only use 2 of the 4 matching options available on the Payment Interface run control page for the AR_PAYLOAD process. The fields used to match to the payment are Payment Amount and Payment ID, and Accounting Date.

3. The process attempts to match the incoming Remit Only records to payments already loaded onto the database. The process also attempts to match the incoming Remit Only records to payments in the staging tables. The staging tables are deposits or payments that have been uploaded from EDI, Lockbox, or Cash Drawer, and so on, but not yet processed and loaded to the deposit/payment tables by the AR Payload program. Rules 1 and 2 above apply to both Loaded Payment and Staging Payments for matching.

Select these options on the Payment Interface run control page (Accounts Receivable, and then Payments, and then Electronic Payments, and then Process Payment Interface, and then Payment Interface) for the process AR_PAYLOAD:

1. Select the Upload from Excel check box in the Data Sources group box.

2. Select the Match Split Stream Data check box.

3. (Optional) Select the Match Payments Already Loaded check box if you want to match to payments already loaded into the database as well as payments still in the staging tables. Otherwise, only payments in staging are considered for matching.

4. Select the Payment Amount and Payment ID and/or Date, Amount and Payment ID check boxes in the Match Criteria Options group box. Only these two criteria options work for Excel Remit Only records. The Remit Only records must have the same payment ID and payment amount as the payment, and in the case of the Date, Amount and Payment ID, the Remit Only record must match the estimated settlement date of the payment on the payment record.

Input data on the spreadsheet must meet certain rules for Remit Only records. The field names and values are as follows:

Record Type	Field Name	Value
Record Type 000	Process	Y
Record Type 000	Remit Only	Y
Record Type 000	Deposit Unit	Use a value that is a valid Receivables business unit. This value is not used except to verify that this record is valid.
Record Type 000	Deposit ID	The value entered is not used except to identify the record if the user looks at the XML output.
Record Type 000	Control Count	Use a value that is equal to the total number of payments in this Remit Only group.
Record Type 000	Control Total	Use a value that is equal to the total amount of all payment amounts of all payments in this Remit Only group.
Record Type 000	Accounting Date	Only required if DATE is among the match criteria that should be selected when matching. This date is matched to the estimated settlement date on the payment.
Record Type 001	Payment ID	Required for matching to the payment ID.
Record Type 001	Payment Amount	Required for matching to the payment amount.
Record Type 002	All fields can be used for Customer Remit records.
Record Type 003	All fields can be used for Item Reference Remit records.