Disposal Transactions Report
Inventory Control Menu -> Reports
-> Disposal Transactions Report
Reports Menu -> Automatic
Reporting -> Function RSDT10 -> runs Disposal
Transactions Report
At month end or year end, print the Disposal Transactions report
to see the list of rental equipment sold or disposed.
This report does not apply to merchandise sales.
The report allows for selection by Depreciation Class, Product
Class, Group, Date Range, Division Range, and can be sorted by
Depreciation Class, Product Class, Date Sold, or by Division.
Generally the report is printed in Depreciation Class order, so
that the sub-totals can be used by the accountant for tax
purposes.
The product number, description, sold date, invoice number, and
quantity are printed. The Cost, Depreciated amount, Book Value,
Sale Price, any Recapture amount, and the Gain or Loss on the
disposal print.
The spreadsheet output also includes the Leasing Vendor and
the values from the Appraisal Values
window.
Gain or Loss on Disposal is the excess between the Sale Price
and the Original Cost.
A flag in the Company Posting Parameters can
be set to post the sale of any fixed asset by the Book Value or by
the Average Cost using the asset tag values.
This posting selection is then used in the calculation of the
Recapture amounts, and the Gain or Loss on the disposal.
Either the standard accumulated depreciation or the alternative
depreciation can be printed on the report.
The Disposal Transactions Report can be setup to be run
automatically with the results emailed to staff, by setting up
RSDT10 with the relevant filters and email addresses in the
Automatic Reporting.
The selection prompts and report filters include:
-
- FROM DEPRECIATION CLASS
- Leave this field blank to include rental equipment from all
depreciation classes, or enter a starting Depreciation Class for
the reporting range, or select one from the drop-down list.
- TO DEPRECIATION CLASS
- Leave this field blank to include all depreciation classes, or
enter an ending Depreciation Class for the reporting range, or
select one from the drop-down list.
FROM PRODUCT CLASS
- Leave this field blank to include equipment from all rental
Product Classes or type in a beginning Product Class, or select it
from the Product Class Search
window.
- TO PRODUCT CLASS
- Leave this field blank to include all rental Product Classes,
or type in an ending Product Class, or select it from the
window.
FROM PRODUCT GROUP
- Leave this field blank to include all equipment from all Groups
or type in a beginning Group, or select it from the Product Group Search window.
- TO PRODUCT GROUP
- Leave this field blank to include all Groups, or type in an
ending Group, or select it from the window.
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 a range of divisions or divisions by
accounting region to include in the report, as outlined in Division Select By Region.
Note: The divisions included in the report output, are limited
to the Divisional Restricted Views
assigned to the operator.
FROM DATE
- Accept the default start date to include all disposals, or
enter a preferred starting date for the disposal report.
- TO DATE
- Accept today's date, or enter a preferred ending date for the
disposal report.
SORT ORDER
- Select one of the following sort options:
- Select Depr'n Class to list the products by disposal
date, within each Depreciation Class.
- Select Product Class to list the products by disposal
date, within each Product Class.
- Select Disposal Date to list the products by product
number for each Disposal Date.
- Select Inv Division to list the products by disposal
date for each Invoice Division.
USE ALTERNATE DEPRECIATION
- Uncheck this box to print the report reflecting the primary
depreciation information from the Asset Tags.
Check this box to print the report using the Alternate depreciation
values that can be maintained in the window on the Fixed Asset
Tags.
Note: The Show G/L Transaction does not apply to
Alternate Depreciation.
PRINT SECOND DETAIL LINE
- Check this box to print additional information for each product
on a second detail line, including the LTD Revenue, Customer #,
Name, Date Acquired, Tag # and Serial #.
Uncheck this box to suppress the extra line of details per
product.
NEW PAGE PER CLASS/DIV
- This prompt is disabled if the report is being sorted by
Disposal Date.
Check this box to start a new page for each new Product Class,
or Depreciation Class, or Invoice Division.
Uncheck this box to continue printing all classes and divisions
together
SHOW G/L TRANSACTION #
- This option only applies to Excel output when the Sort
Order is by 'Depreciation Class' or by 'Product Class'.
Uncheck this box if the G/L transaction associated with the sale
of the asset is not required.
Check this box to print the G/L transaction number for the posting
of the sale of the asset, on the Excel spreadsheet output.
Note: This value is only listed if the transaction number can be
uniquely identified in the G/L.
It is left blank if there is more that one transaction in the G/L
that matches the sale information of the product, vendor,
etc.
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.
When the output is generated to a spreadsheet by Depreciation
Class, or by Product Class, a new page is generate for the
spreadsheet for each class.
Finished?
- Click the ACCEPT button to begin printing the report, or CANCEL
to abort.
Topic Keyword: RSDT10