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.

• Book Value Method:
  The Gain/Loss on disposal is equal to the difference between the Sale Price and the Book Value.

• Average Cost Method:
  This method splits the Book Value Gain/Loss (defined above) out, to show any Recaptured depreciation amount separately from the Average Cost Gain/Loss amount.

  • The Average Cost Gain/Loss on disposal is equal to the difference between the Sale Price and the Original Cost.
  • A recapture calculation is also done with this Average Cost method, but only when the Sale Price is greater than the Original Cost (e.g. the equipment has been over depreciated). This Recapture amount is the difference between the Book Value and the Cost.
  The sum of these two values then equals the Book Value Gain/Loss.

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.