Bulk Asset Disposal through CSV Import
To process multiple asset disposals using CSV import
-
Go to Fixed Assets > Transactions > Asset Disposal.
Note:You can't add columns or custom fields to this import.
-
On the Asset Sale/Disposal page, click Import CSV.
-
On the Bulk Asset Disposal page, click Choose File, then select the CSV file that contains the records you want to process.
Click the link below the Choose file button to view a sample file.
-
Check the Consolidate Line Items on Invoice box to combine the sales amount of all assets for disposal into a single line item on the invoice.
-
Click Submit.
The following table shows sample disposal values for a CSV import:
Disposal Type
Disposal Date
C
ustomer Tax Code
Sale Item
Asset
Quantity to Dispose
Sale Amount
L
ocation Sale
1/31/2015
Customer ABC
-Not Taxable-
Item for Disposal
79
3
7,000.00
C
alifornia Important:To ensure you are correctly entering values in your CSV file, see CSV File Mapping for Asset Disposal.
If Multi-Book Accounting is enabled, the system also creates a journal entry to write off tax methods linked to accounting books. For information about multi-book asset disposal, see Disposing an Asset in Multiple Books.