Understanding Automatic Receipt Record Creation
After uploading the information from the customer's bank into the F03B13Z1 table, you must process the information to create receipt or draft records in the Receipts Header (F03B13) and Receipts Detail (F03B14) tables. You must perform this initial step before you can match receipts to invoices. This batch program enables you to:
Update the bank account in the general ledger regardless of the success ratio of the matching of algorithms.
Account for the entire deposit before you rework any of the items that the system did not process successfully.
When you run the Update Receipts Header program (R03B551), the system creates either unapplied receipts or drafts, or it creates logged receipt records. The system creates logged receipts when it cannot locate a payor or customer; otherwise, it creates unapplied receipts.
When you run the R03B551 program, the system:
Retrieves the payment ID from the Next Numbers program.
Validates the batch type (9B) records in the Electronic Receipts Input table (F03B13Z1), and defines the value to be stored under the column RYEUFB (Uploaded from tape or batch entry) in the Receipts Header table (F03B13) to indicate which algorithm will be used.
The RYEUFB (Uploaded from tape or batch entry) value is defined in this way:
If Document Number (F03B13Z1-DOC) is equal to zero and Generic Matching (F03B13Z1-GMFD) is blank, the system assigns the value 1.
The value 1 indicates that the electronic receipt will be applied to invoices by using the Invoice Selection Match algorithm (R03B50A), the Balance Forward Match algorithm (R03B50B), or the Combination Invoice Match algorithm (R03B50F).
If RV Document Number (F03B13Z1-DOC) is not equal to zero or Generic Matching (F03B13Z1-GMFD) is not blank, and Gross Apply Amount (F03B13Z1-AG) is equal to zero, the system assigns the value 2.
The value 2 indicates that the electronic receipt is applied to invoices by using the Known Invoice Match Without Amount algorithm (R03B50E).
If RV Document Number (F03B13Z1-DOC) is not equal to zero or Generic Matching (F03B13Z1-GMFD) is not blank, and Gross Apply Amount (F03B13Z1-AG) is not equal to zero, the system assigns the value 3.
The value 3 indicates that the electronic receipt is applied to invoices by using the Known Invoice Match With Amount algorithm (R03B50D).
When the algorithms are run from Apply Receipts to Invoices Process (R03B50), each algorithm validates the RYEUFB value to make sure that the receipt can be processed by the algorithms that are set on the execution list.
The JD Edwards EnterpriseOne software provides record reservation capability for the Invoice Match With Amount algorithm (R03B50D), Known Invoice Match Without Amount algorithm (R03B50E), Balance Forward Match (R03B50B), Invoice Selection Match (R03B50A), and Combination Invoice Match (R03B50F) applications.
For the applications R03B50D and R03B50E the Work Center error message is displayed for the invoice pay item if the pay item is reserved by another process or user. This pay item is skipped and is not processed
For the applications R03B50B, R03B50A and R03B50F the record reservation errors are sent to the Work Center when some of the invoice pay items processed by the invoice matching routines are reserved by another process or user. Those invoice pay items are not considered for processing automatic receipts. To ensure that all applicable invoice pay items are processed, remove the reservation of the invoice pay items before executing the Automatic Receipt Processing program.
Locates the payor number in this way:
If customer bank account information is provided in the Customer Bank Account (CBNK) and Customer Bank Transit (TNST) fields, the system uses it to locate the address book number of the payor bank record (record type P) from the Bank Transit Master table (F0030).
If unsuccessful, and the bank information exists, the system uses the address book number of the customer bank record (record type C) as the payor.
If unsuccessful, the system uses information from the document number or generic reference fields, if provided, to locate the payor number from the invoice record.
If unsuccessful, the system uses the value of the customer number field (AN8).
If unsuccessful, the system uses the address number from the corresponding processing option.
If the processing option is blank, the system creates a logged receipt.
Note: If the customer number exists on the electronic receipt record, the system does not overwrite its value with the value of the payor field.
Retrieves the execution list from the customer master record (F03012). If the execution list does not exist, the system uses the execution list that is specified in the processing options or leaves the field blank.
Retrieves the G/L bank account in this way:
The system uses the value from the G/L Bank Account ID (GLBA) field.
If GLBA is blank, the system uses the values from the Home Bank Account (EHBK) and Home Bank Transit (EHTN) fields to retrieve the G/L bank account record from the F0030 table.
If unsuccessful, the system uses the value from the processing option Short Bank Account ID.
If the processing option is blank, the system uses the account that is associated with the AAI item RB for the company specified.
If unsuccessful, the system returns an error message.
Retrieves the company from the Account Master table (F0901).
If the company does not exist in this table, the system retrieves it from the processing options.
Attempts to retrieve the G/L date from the processing options.
Formats and validates the receipt date.
If the receipt date is not supplied on the electronic receipt record (F03B13Z1), the system uses the G/L date as the receipt date.
Generates an exception report of receipts that are not processed.
Updates the batch status to posted in the Batch Control Records table (F0011) for batch type 9B.
You see batch header records only if you created receipts using the Review Electronic Receipts program (P03B121).
Creates a batch header record in the F0011 table with a batch type RB.
Creates receipt header records in the F03B13 table.
Creates corresponding receipt detail records in the F03B14 table.
Note: A processing option enables you to run the Apply Receipts to Invoices program (R03B50) after the Update Receipts Header program finishes.See Applying Electronic Receipts to Invoices Automatically (Release 9.2 Update).