Book Value Report
Reports Menu -> Inventory -> Inventory Value Reports -> Book Value
Report
This program can be used to generate an inventory Book Value
report for Rental equipment listing the current inventory value, or
calculating the value as of a prior date.
It does not apply to sales parts.
The report sorts the rental inventory by Product Class Number
and within each Product Class, the products are listed either in
product number order or by product description.
Costs for Bulk items are not date adjusted.
The Status with Description returned on the spreadsheet is the
Current 'Product Status' regardless of the reporting date.
To use this report to balance the inventory value to the G/L
always use the "Owning Location" for the Select By option,
and the "Tag/Product Detail" for the Detail To Print.
Note: For Bulk equipment the report can only be run
effectively by "Owning Location" as this version of the report
calculates the values for each Fixed Asset Tag based on the
quantity and location associated with that tag.
The "Inventory Location" option cannot be run for Bulk
products because the physical location count does not necessarily
equal the tag location count, meaning that the cost values on the
tag cannot be matched accurately to the physical location.
The prompts to generate the report are:
-
- PRODUCTS TO INCLUDE
- Select one of the following product options:
- Select Bulk Products to print the report for only the
Bulk items in the selected range, and only on the report by "Owning
Location".
- Select Non-Bulk Products to print the report for only
the Non-Bulk items in the selected range, for either of the "Owning
Location" or "Inventory Location" reports.
- Select Bulk and Non-Bulk Products to include all rental
products in the range, and only on the report by "Owning
Location".
FROM PRODUCT CLASS
- Leave this field blank to include all rental classes, or enter
the desired starting Product Class for the reporting range, or
select one from the Product Class Search
window.
- TO PRODUCT CLASS
- Leave this field blank to include all rental classes, or enter
the desired ending Product Class for the range.
FROM DEPRECIATION CLASS
- Leave this field blank to include all depreciation classes or
select a starting class for the report from the drop-down list.
The classes are setup in Depreciation
Classes and assigned to each product on the Fixed Asset Tag in
Rental Inventory.
- TO DEPRECIATION CLASS
- Leave this field blank to include all depreciation classes or
select an ending class for the report from the drop-down list.
ACQUIRED DATE CUT-OFF
- The date used by this cut-off date filter, is the Acquired
Date defined on each Fixed Asset Tag of the rental
products.
Accept today's date, or enter a preferred acquired cut-off date for
the report, so that products purchased later than this date are
excluded from the output.
PRINT AS OF PRIOR DATE
- Uncheck this box to generate the output as a 'snapshot' of the
information currently captured on the Fixed Asset Tags.
To include a product the Original Quantity on the Tag and
the Quantity On Hand on the Tag cannot currently be
zero.
When the prior-date option is not selected, the Depreciation Class
& description are only printed on the detailed spreadsheet, and
even if the Depreciation Class is used as a selection
filter, because of space restrictions it does not print out on the
report output.
Check this box to recalculate the report values as of an earlier
date.
- PRIOR DATE CUT-OFF
- Enter the preferred prior date for the report calculations.
To include a product the quantities on the Tag cannot be zero as of
this cut-off date.
Note: When the report is generated for a prior date, the
detailed report is always printed by Owning Location, and
the Alternate Depreciation option is disabled.
Prior Date Calculation Formulas:
- Quantity on the Tag at the time of the Prior Date
Cut-off and is reconstructed as follows:
Current tag quantity - (warehouse receipts after cut-off date) +
(rental to sale transfers after cut-off date) + (branch transfers
after cut-off date) - (sale to rental transfers after cut-off date)
+ (disposals after cut-off date)
- Unit Cost is obtained from the cost adjustment records
(RSCA) which include additions by cut-off date, or the current
average cost if there are no cost adjustment records.
- For non-bulk and non-multiple tag bulk products, the current
average cost is the average cost on the product file (RSPF).
- For multiple tag bulk products the current average cost is
obtained from the tag by the following formula:
Current cost = (net original cost) / (current on hand) = (original
cost - accumulated disposals - accumulated transfers + accumulated
additions) / (original quantity - quantity sold - quantity
transferred)
- Total Cost = Quantity * Unit Cost
- Accumulated Depreciation is the amount of depreciation
at the time of the cut-off date so that any Depreciation after the
cut-off date is ignored.
- Accumulated Additions is the value of additions at the
time of the cut-off date, and any Additions after the cut-off date
are ignored.
- Book Value = Total Cost - Accumulated Depreciation
SELECT BY
- Select one of the following product location options:
DETAIL TO PRINT
- Select one of the following report options:
DIVISION, "ALL" OR "SEL"
-
- Type ALL to include all divisions in the report.
- To print the report for a single division, leave this field
blank for the Head Office Division, or enter a specific division
code, or select a division from the drop-down list.
- Type SEL to select several specific divisions or divisions by
inventory region to include in the report, as outlined in Division Select By Region.
On the Report output, each division will print on a new
page with division totals.
On the Excel output, printing each division on a new tab of
the spreadsheet is controlled by the One Sheet Per Division
selection option below.
Note: Only locations for which the operator has access as
determined by Divisional Restricted Views
assigned to the operator, will be allowed.
NEW PAGE PER CLASS
- Check this box to start a new page for each new Product Class
with a sub-total for each Product Class.
Uncheck this box to continue printing all Product Classes together
with a sub-total for each Product Class.
This option only applies if Tag/Product Detail is to be
printed.
SORT OPTIONS
- Select one of the following sort options:
- Select Product Number to list the products by product #
order within each Product Class.
- Select Description to list the products alphabetically
by description within each Product Class.
ALTERNATE DEPRECIATION METHOD
- Uncheck this box to use the standard Depreciation stored on the
Fixed Asset Tags in Rental Inventory.
Check this box to use the Alternate Depreciation stored on the
Fixed Asset Tags in Rental Inventory.
This option is not provided when using the Print as of Prior
Date calculation.
INCLUDE NON-INVENTORY ITEMS
- Check this box to include equipment that is flagged as NOT
Inventory in Rental Inventory.
Uncheck this box to only include equipment that is flagged as
rental inventory in Rental Inventory.
YEARLY TOTALS BY DEPRECIATION CLASS
- Check this box to also print a separate report with the yearly
subtotals for equipment purchased in the last four years, for each
depreciation class.
Uncheck this box to suppress the yearly subtotals.
REPORT OPTIONS
- This value defaults to the operator preference as defined in
Operators.
Select one of the output options to Print a report or export
the data to Excel as outlined in Report Options.
ONE SHEET PER DIVISION
- This option only applies to the Excel output.
Check this box to print data for each division on a new tab of
the spreadsheet.
Uncheck this box to generate the data on one spreadsheet to enable
easier company-wide consolidation of totals.
This option does not apply to the Report output, as each
division will print on a new page with division totals.
Finished?
- Click the ACCEPT button to begin printing the report, or CANCEL
to abort.
Topic Keyword: RSIT27