Rental Loss Worksheet
The Rental Loss Worksheet can be accessed:
- using Tell Me to post losses for multiple contracts at once. Choose the
icon, enter Rental Loss Worksheet, and then choose the related link. - on a Rental Contract header and line level by choosing:
- Functions > Loss Worksheet on the Actions menu to filter on all Rental Status Lines for all Rental Contract lines.
- Functions > Loss Worksheet on the Lines FastTab to filter on all Rental Status Lines and attached rate parts for the current Rental Contract line.
- on the Rental Status Lines page by choosing the Rental Loss Worksheet action to filter on only that status line.
Losses can be assigned to a Rental Contract line once it has been shipped.
The fields on the Rental Loss Worksheet page are described in the following table.
| Section | Field | Description |
|---|---|---|
| Header | Start Date / End Date | Specifies the date range of the rental loss, which also applies a filter to only show the lines that fit into the date range for at least one day. Therefore, it is possible that some of the filtered Rental Contract lines will start or end outside of these date ranges. In these cases, the actual shipment/return dates in the Rental Status Lines page are used as the start/end date of the posted loss. For example, a loss from February 1 – February 15 is entered in the Rental Loss Worksheet header. A Rental Contract with Shipment/Receipt Date of January 1 – February 28 as well as a Rental Contract with a Shipment Date of February 13 are included in the filtered Rental Loss Worksheet lines because the time period of the loss falls within the rental periods. If these Rental Contracts are selected for loss posting, only a loss for February 1 – 15 will be posted for the first Rental Contract and only a loss for February 13 – February 15 will be posted for the second Rental Contract. These dates can be populated from the shipment and receipt date fields in the Rental Loss Worksheet lines using the Copy Dates function. |
| Reason Code | Optionally used to determine how the loss will be processed, as specified in the Rental Loss Reasons page (see Rental Loss Reasons). | |
| Description | Defaults from the description of the Reason Code field but can be changed. The Rental Invoice and Rental Credit Memo Line Description field will display in the following format: Loss |
|
| Loss % | Indicates the percentage of the amount to be credited. On the resulting Rental Ledger Entries, the Discount % field will be calculated as 100 - Loss %. Defaults from the Reason Code but can be changed. NOTE: It is possible to post a zero loss in cases where no credit memo or invoice credit line is required; therefore, a new and closed Rental Ledger Entry will be created with a zero amount. |
|
| Lines | Selected | Determines if the rental position will be included in the loss. |
| Bill-to Customer No. | Indicates the bill-to customer from the Rental Contract; this field is only visible when the Rental Loss Worksheet is opened using the Tell Me feature. | |
| Contract No. | Indicates the number of the Rental Contract; this field is only visible when the Rental Loss Worksheet is opened using the Tell Me feature. | |
| Contract Line No. | Indicates the number of the Rental Contract line; this field is only visible when the Rental Loss Worksheet is opened using the Tell Me feature or from the Rental Contract header. | |
| Rental Position | Indicates if the position concerning the loss is designated as a Rental or Rate Part. | |
| Description | Indicates the description from the Rental Contract line. | |
| Shipment Date | Indicates the date the rental position was shipped. | |
| Receipt Date | Indicates the date the rental position was returned. | |
| Serial No. | Indicates the serial number of the rental item to be included in the loss posting. | |
| No. of Posted Losses | Specifies the number of losses that have been posted for the line. Choose the value in this field to open the Posted Rental Losses page. | |
| Credit Memo | Determines if posting the line(s) will generate an instant rental credit memo instead of a credit in the rental invoice line later. NOTE: In addition to using this setting to determine the type of loss document, the checkbox is automatically selected for Rental Ledger Entries that are completely invoiced (Open = not selected) and cannot be changed. |
|
| Maximum Quantity | Indicates the maximum possible rental item or rate part quantity as per the Rental Status Line. | |
| Selected Quantity | Indicates the number of units that need to be included in the loss posting. |
The actions on the Rental Loss Worksheet page are described in the following table.
| Menu | Field | Description |
|---|---|---|
| Home | Select/Clear All | Selects or clears the Selected checkbox on all Rental Loss Worksheet lines. |
| Copy Dates | Copies the Shipment Date and Receipt Date fields from the lines to the Start Date and End Date fields, respectively, in the header. | |
| Post Rental Loss | Creates a credit memo or will add a credit line to a later invoice for the selected Rental Loss Worksheet lines. | |
| Contract Line | Show Contract | Opens the related Rental Contract page. |
| Rental Ledger Entries | Opens the Rental Ledger Entries page of the contract line related to the selected Rental Loss Worksheet line. | |
| Rental Status Lines | Opens the Rental Status Lines page of the contract line related to the selected Rental Loss Worksheet line. |
Feedback
Submit feedback for this page .