Understanding the Batch Delete Program (R74U5806)
You can use the Batch Delete program (R74U5806) when you have processed records in error. Be cautious when using this program because it deletes transactions based on the batch number that you enter from JD Edwards EnterpriseOne Enhanced Real Estate Management, JD Edwards EnterpriseOne Real Estate Management, JD Edwards EnterpriseOne Accounts Payable, JD Edwards EnterpriseOne Accounts Receivable, and JD Edwards EnterpriseOne General Accounting systems. The R74U5806 program ensures that all related transactions are purged from all systems and minimizes integrity problems that could result when you have to purge records from tables separately.
The R74U5806 program removes records that remain unposted in the Account Ledger table. These records include any transaction that posts from the Lease Billings Master (F1511B) table to the Customer Ledger (F03B11) or Accounts Payable Ledger (F0411) tables, but fails to post to the Account Ledger table (F0911). In this case, all of the associated records (F1511B, F03B11, F0411, and F0911) are considered unposted.
You cannot use the Batch Delete program to delete batches of receipts, revenue fees, or security deposits, or accounting profile records, because the system does not write records to the Lease Billings Master table, which is the source table used to retrieve the batch number; the Batch Delete program deletes batches only when records exist in table F1511B.
The R74U5806 program removes records from these tables based on the batch number that you enter:
Batch Control Records table (F0011)
Customer Ledger table (F03B11)
Accounts Payable Ledger table (F0411)
Account Ledger table (F0911)
Estimated EP Recurring Billings table (F1502WB)
Lease Billings Master table (F1511B)
Expense Participation Audit File table (F1532B)
EP Billing Register table (F1538B)
Payment Profile table (F74U0205)
Note: Only those payment profile records created for actual Expense Participation billings are deleted; otherwise, the payment profile status is changed from generated to open (blank).
When you run the R74U5806 program, the system:
Removes all transactions that exist in the tables for the batch number entered.
Resets the billing control ID for the related period from G (generated) or B (billed) for generation types 2 and 6 to blank in the Billings Generation Control table (F15011B) so that you can generate billings again for that period.
Returns the status of the payment profile records to open.