Cash Basis Entries for Accounts Payable and Accounts Receivable

The Create Cash Basis Entries program launches additional programs to create balancing entries for batch types K, M, W, and RB. The program does not create balancing entries for document types AE, DP, JT, PM, PR, PV, RA, RI, RM, and RR.

For payments and receipts, the system first processes the F0911 record for the bank account. The system excludes general ledger transactions for the corresponding expense and revenue accounts because those document types (such as PV and RI) are in UDC 00/DX. To balance the cash basis entry, the system automatically runs the Create Cash Basis Entries - A/P (R11C854) and Create Cash Basis Entries - A/R (R11C853) programs to retrieve the expense and revenue accounts.

The system locates paid vouchers from the F0414 table and paid invoices from the F03B14 table that meet these criteria:

  • The posted code is D.

  • The RNALT6 and RZALT6 fields are blank in the F0414 and F03B14 tables.

When the system locates eligible transactions, it:

  • Locates records in the F0411 and F03B11 tables to retrieve the expense and revenue accounts.

  • If the RPOBJ (Object) field has a value, uses the values in the RPMCU (Business Unit), RPOBJ, and RPSUB (Subsidiary) fields from the invoice or voucher record.

  • If the RPOBJ field is blank, locates the expense and revenue accounts from the associated F0911 record.

  • Adds the expense and revenue account information to the cash basis entry that was previously generated for the bank account, based on the F0911 payment and receipt records.

  • Uses the general ledger date from the receipt or payment as the general ledger date for the cash basis document.

Payment and receipt amounts are prorated under these conditions:

  • The payment or receipt does not fully pay the voucher or invoice.

  • The payment or receipt is for multiple vouchers or invoices.

  • The payment of receipt is for vouchers or invoices with multiple expense accounts.

To prevent the system from creating cash basis entries multiple times for the same vouchers and invoices, the system updates the RNALT6 and RZALT6 fields to P in the F0414 and F03B14 tables.

If you delete cash basis entries before you post them, the system does not create new cash basis entries for the same records; you must manually enter AZ journal entries to re-create the cash basis entry.

This table describes the differences between the JD Edwards EnterpriseOne Accounts Payable and JD Edwards EnterpriseOne Accounts Receivable cash basis entry programs:

Create Cash Basis Entries - A/P

Create Cash Basis Entries - A/R

The system uses the F0414 table to locate all paid vouchers that have not been updated for cash basis. The system uses the payment number (DOCM) from the F0413 table as the cash basis document number.

The system uses the F03B14 table to locate all paid invoices that have not been updated for cash basis. The system uses the general ledger document number (DOCG) as the cash basis document number.

The system uses the voucher number to locate the document in the F0411 table, and then uses the values from the OBJ and SUB fields for the expense account.

The system uses the invoice number to locate the document in the F03B11 table, and uses the values from the OBJ and SUB fields for the revenue account.

If the OBJ and SUB fields are blank, the system searches the F0911 record to locate expense accounts.

If the OBJ and SUB fields are blank, the system looks at the F0911 record to locate revenue accounts.

The system updates the F0911 record in the batch with expense account information from the voucher.

The system updates the F0911 record in the batch with revenue account information from the invoice.

The system updates the RNALT6 field to P in the F0414 table.

The system updates the RZALT6 field to P in the F03B14 table.