1. Rental Management Implementation Guide
  2. Understanding the Rental Item Cost Calculation Report (R54R401)

Understanding the Rental Item Cost Calculation Report (R54R401)

You use the Rental Item Cost Calculation program (R54R401) to get the extended cost of the rental contract for a rental item. The system calculates extended cost using the formula:

Rental Item Cost = Number of rental days or total days (based on the value in the Number of Days processing option) * the cost associated with the cost method (specified in the Owned Asset Cost Method field in the Rental Constants table (F54R01).

The system retrieves the cost from the Item Cost table (F4105) depending on the inventory cost level specified in the Item Master program (P4101).

See "Setting Up Item information" in the JD Edwards EnterpriseOne Applications Inventory Management Implementation Guide

If you set the Number of Days processing option to use a calendar, the system uses the workday calendar for the business unit in the rental contract detail line, and calculates the number of rental days as follows:

  • If the rental contract has started in the fiscal period for which you run the report, the system calculates the number of rental days from the start date of the contract through the end date of the contract or through the last day of the fiscal period, whichever is the shortest. The system counts only the work days in the calendar.

  • If the rental contract has started in a prior period, the system calculates the number of rental days from the first day of the period through the end date of the contract or the last day of the fiscal period, whichever is the shortest. The system counts only the work days in the calendar.

If you set the Number of Days processing option to use the total number of days, the rental days is the total number of days (including holidays and weekends) within the date range. The system calculates the number of rental days as follows:

  • If the rental contract has started in the current fiscal period, the system calculates the number of rental days from the start date of the contract through the end date of the contract or the last day of the fiscal period, whichever is the shortest.

  • If the rental contract has started in a prior fiscal period, the system calculates the number of rental days from the first day of the period through the end date of the contract or the last day of the fiscal period, whichever is the shortest.