Available in Sage 50 Premium Accounting and higher.
The following table lists the fields available for import or export, with a brief description of the field and (when necessary) a character limit for the field. Sage Fixed Assets Depreciation Import fields are imported from the Sage Fixed Assets - Lite Depreciation fixed asset management product into your company's general journal. Typically, these fields are not exported, although they can be exported to a spreadsheet if desired.
All fields are available for both import and export. The Required column shows those fields that must be provided.
Note: Sage Fixed Assets Depreciation Import fields are exported using FASDEPR.CSV as the default file name.
|
Field Name |
Import? |
Required |
Description of Field |
Limit |
|---|---|---|---|---|
|
Date |
Y |
Y |
Date - Date of the transaction. Must be in ##/##/## (month/day/yr) format. |
|
|
Reference |
Y |
N |
Alphanumeric - Reference for the transaction. |
Up to 20 characters |
|
Number of Distributions |
Y |
Y |
Numeric (Whole) - Number of distributions in the transaction; valid numbers are 2 to 147. |
|
|
G/L Account |
Y |
Y |
Alphanumeric - G/L account number for a line of distribution. |
Up to 15 characters |
|
Description |
Y |
N |
Alphanumeric - Description for a line of distribution. |
Up to 160 characters |
|
Amount |
Y |
Y |
Numeric (Real) - Amount for a line of distribution. A positive amount denotes a debit, while a negative amount denotes a credit. |