Deleting Joint Venture Account Ledger Records

To delete joint venture account ledger records:

  1. From the Joint Venture Management module (G09J), click Daily Processing, and then JV Account Ledger Revisions.

    The system displays the Joint Venture Account Ledger Revisions form.

  2. Use any of the fields or options in the form header, the QBE line, or the advanced query to enter the search criteria, and then click Find.

  3. To delete one or more records, select the selection option at the beginning of the row for these records, and then click the Delete button.

    Alternately, to delete all of the records that are included in your current query results, select Delete All from the Form menu. Note that this option includes all records included in your query that meet your current selection criteria. This could include more records than are currently displayed on your form.

    On the confirmation window that is displayed, click Yes to confirm the delete.

    Note: The Delete button and Delete All option enable you to delete specific records or all the records that are not at the Process Complete status. After you delete the records from the F09J11 table, they can be added back to the table the next time you run the R09J400 program
  4. To delete the distributions associated with a joint venture account ledger record that is at a Process Complete status, select the selection option at the beginning of the row for the record, and then click Delete Dist Selected from the Row menu.

    Alternately, to delete the distributions for all the records that are included in your current query results, select Delete Dist All from the Form menu. Note that this option includes all records included in your query that meet your current selection criteria. This could include more records than are currently displayed on your form.

    On the confirmation window that is displayed, click Yes to confirm the delete.

  5. Note: The system deletes the distribution records for a joint venture account ledger transaction only when all of the associated distribution details are not at the Process Complete status. When the distribution records for a joint venture account ledger transaction is deleted, the transaction status for the joint venture account ledger record automatically resets to Available To Process. After the distribution records are deleted, you can now delete the account ledger record, if needed. You can then enter a a new DOI or a direct billed partner to the F09J11 record.

The system returns you to the Joint Venture Account Ledger Revisions form and refreshes the data based on your deletion.