13 Working With Rental Contract Ledger

This chapter discusses these topics:

13.1 Understanding Rental Contract Ledger

The Rental Contract Ledger program (P54R099) enables you to track updates to the Rental Contract Header table (F54R10) and Rental Contract Detail table (F54R11).

The system adds a ledger record to the Rental Contract Header Ledger table (F54R099) whenever there's a change in the F54R10 table, and to the Rental Contract Detail Ledger table (F54R199) whenever there's a change in the F54R11 table.

13.2 Forms Used to Work With Rental Contract Ledger

Form Name Form ID Navigation Usage
Work With Rental Contract Ledger W54R099A Periodic Processing (G54R20), Rental Contract Ledger

Alternately, access the Work With Rental Contract Ledger form by clicking the Contract, Contract Ledger on the Row menu of the Work With Rental Contracts form. Access the Work With Rental Contracts form through Daily Processing (G54R10), Rental Contract Entry.

Select a rental contract to review changes.
Rental Contract Header and Detail Ledger W54R099B On the Work With Rental Contract Ledger form, select a record and click Select. Review additions or updates made to the header and detail of the selected rental contract.

13.3 Using the Rental Contract Ledger

Access the Rental Contract Header and Detail Ledger form. The form includes:

  • Header information: This includes the rental contract number, the order type, and the company associated with the rental contract. The system retrieves this information from the Rental Contract Header table (F54R10).

  • A grid that displays the details of the rental contract: The system retrieves all the detail lines of the contract from the Rental Contract Detail table (F54R11).

    The system selects the first detail line by default, and populates the ledger records for the selected detail line on the third grid, which is the Rental Contract Detail Ledger subform. The line number of the displayed line is populated in the Line Number Query By Example (QBE) field in the Rental Contract Detail Ledger subform. To view ledger entries for a different detail line, select that line.

  • Rental Contract Header Ledger subform: This subform displays records from the Rental Contract Header Ledger table (F54R099). Whenever you change the contract header information, the system makes an entry of the change in the F54R099 table. Changes in the rental contract header that trigger a header ledger entry include:

    • Adding or updating the header data in the Rental Contract Entry program (P54R10)

      The system updates the F54R10 table, and also makes an entry of the update in the F54R099 table.

    • Deleting a rental contract using the Delete button on the Work With Rental Contracts form, or using the Delete Contract option on the Row menu of the Work With Rental Contracts form

      The deletion is recorded in the F54R099 table, although the record no longer exists in the F54R10 table.

    • Using the Convert Reservation, Release Hold, and Close Contract options on the Row menu of the Work With Rental Contracts form

    The system uses the Ledger Action column to specify the action that triggered the header ledger entry. The system populates this column with a value from the Ledger Action UDC table (54R/LA). Examples of the values in this UDC table are: Add, Update, Delete, Convert Reservation, Cancel, Release Hold, Close Contract, Update Status, and so on.

    If you click the OK button on the Rental Contract Header Revisions form without making an update, the system does not update the F54R10 table. As a result, the system does not create a header ledger entry.

  • Rental Contract Detail Ledger subform: This subform displays records from the Rental Contract Detail Ledger table (F54R199). Whenever you change the contract detail information, the system makes an entry of the change in the F54R199 table. Changes in the rental contract detail that trigger a detail ledger entry include:

    • Adding or updating the detail data in the Rental Contract Entry program (P54R10). The system updates the F54R11 table, and also makes an entry of the update in the F54R199 table

      The system updates the F54R11 table, and also makes an entry of the update in the F54R199 table.

    • Deleting a rental contract using the Delete button on the Work With Rental Contracts form, or using the Delete Contract option on the Row menu of the Work With Rental Contracts form

      If detail lines existed for the contract, the deleted detail lines are recorded in the F54R199 table, although the detail records no longer exist in the F54R11 table.

    • Using the Create Transfer, Link Related Order, Close Line, Delete Line, and Cancel Line options on the Row menu of the Rental Contract Detail Revisions form

      The system also creates detail ledger records when you make updates that affect the entire rental contract, such as using the Convert Reservation, Release Hold, and Close Contract options on the Row menu of the Work With Rental Contracts form.

    The system uses the Ledger Action column to specify the action that triggered the detail ledger entry. The system populates this column with a value from the Ledger Action UDC table (54R/LA). Examples of the values in this UDC table are: Add, Update, Delete, Convert Reservation, Cancel, Release Hold, Close Contract, Update Status, and so on.

    If you click the OK button on the Rental Contract Detail Revisions form without making an update, the system does not update the Rental Contract Detail table (F54R11). Since F54R11 table is not updated, the system does not create a detail ledger entry.


Note:

The Work With Rental Contract Ledger form is based on the Rental Contract Header Ledger table (F54R099).