Cash Basis Entries for Account Ledger Records

The Create Cash Basis Entries program creates cash basis entries that are based on accrual transactions in the F0911 table, regardless of batch type. The system locates transactions in the F0911 table that meet these criteria:

• The document type is not in UDC table 00/DX (Excluded Document Types).

• The ledger type is AA.

• The posted code is P.

• The GLALT6 (Cash Basis Posting Code) field is blank.

  The transaction has not been processed for cash basis.

Every time that you run the Create Cash Basis Entries program, the system creates cash basis entries with ledger type AZ and batch type G in a single batch in the F0911 table. The system uses the general ledger date from the originating AA ledger transaction as the general ledger date for the cash basis entry.

To prevent the system from creating cash basis entries multiple times for the same transactions, the system updates the GLALT6 field to P on the F0911 accrual records. 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.

When the system creates cash basis entries based on journal entries, it copies the entire transaction to the AZ ledger and assigns it a cash basis document type. As long as you create the original journal entry in balance, the system creates the cash basis entry in balance.