Understanding the E.P. Batch Delete Program (R158061)

If, after generating the expense participation calculations, you find that the expense participation information was not set up correctly, you can run the E.P. Batch Delete program (R158061) to remove the records from the E.P. Billing Register table (F1538B). You should delete expense participation batches only when your revisions affect multiple lease records or an expense class.

You can delete expense participation batches, even after the system has generated billing records for actual amounts, if they have not been posted to the JD Edwards EnterpriseOne Accounts Receivable or JD Edwards EnterpriseOne Accounts Payable systems. If you have already posted records, the system does not delete them when you run the R158061 program; you must enter manual billing records for adjustments.

The system deletes the unposted billing records from the following tables:

  • Lease Cap History (F15153)

  • E.P. Class Cap Expenses History (F15303)

  • Share Factor Denominator Audit (F150122A)

  • EP Billing Account Adjustments Audit (F1539A)

  • EP Billing Class Adjustments Audit (F1539C)

  • EP Billing Account Exclusions Audit (F1539E)

  • EP Billing Adj Factor EP Class Audit (F1539FC)

  • EP Billing Adj Factor Lease Audit (F1539FL)

  • Occupancy Gross Up Audit (F1538B1)

  • Exclusion/Redistribution (F1538B2)

  • E.P. Billing Register (F1538B)

  • E.P. Audit File (F1532B)

  • Estimated E.P. Recurring Billings (F1502WB)

  • Lease Billings Master (F1511B)

  • Billing Batches Summary (F1511B1)

  • Billings Generation Control (F15011B)

  • Batch Control Records (F0011)

The system also removes the G from the billing period in the Billings Generation Control table (F15011B). The system unlocks the recurring billing record only when all of the periods in the F15011B table are blank.

Note: When you generate the recurring billing records for estimated expense participation amounts, the system locks the calculation batch, even if the actual amounts have not been generated. After the calculation batch is locked, the system does not delete or unlock the record.