Example: How Cash Basis Entries Are Created

This example illustrates how cash basis entries are created for the JD Edwards EnterpriseOne General Accounting, JD Edwards EnterpriseOne Accounts Payable, and the JD Edwards EnterpriseOne Accounts Receivable systems.

Review the following entry in the AA ledger in the F0911 table:

• JE 1234

• G/L Date 06/08/10

• Bank Fee 300

Based on the above entry in the AA ledger, when you run the Create Cash Basis Entries program (R11C850), the system creates a new G batch #445 and the following entry in the AZ ledger in the F0911 table:

• JE 1234

• G/L Date 06/08/10

• Bank Account -300

• Bank Fee 300

Review the following entry in the AA ledger in the F0911 table:

• PK 111

• G/L Date 06/13/10

• Bank Account -400

Based on the above entry in the AA ledger, the system creates the following entry in the AZ ledger in the F0911 table:

• PZ 111

• G/L Date 06/13/10

• Bank Account -400

Review the following entry in the AA ledger in the F0911 table:

• RC 32143

• G/L Date 06/23/10

• Bank Account 600

Based on the above entry in the AA ledger, the system creates the following entry in the AZ ledger in the F0911 table:

• RZ 32143

• G/L Date 06/23/10

• Bank Account 600

Cash basis entries are not created for document types PV:

• PV 45666

• G/L Date 06/01/10

• Expense Account 400

Cash basis entries are not created for document types RI:

• RI 3342

• G/L Date 05/27/10

• Expense Account 600

Based on the previous example, for Batch Type G, Batch Number 445, the system makes the following cash basis entry in the JD Edwards EnterpriseOne Accounts Payable:

• PZ 111

• G/L Date 06/13/10

• (R11C850) Bank Account: - 400

• (R11C854) Expense Account: 400

Based on the previous example, for Batch Type G, Batch Number 445, the system makes the following cash basis entry in the JD Edwards EnterpriseOne Accounts Receivable system:

• RZ 32143

• G/L Date 06/23/10

• (R11C850) Bank Account: 600

• (R11C853) Expense Account: -600