Asset Financial Adjustments can either be added or updated, depending on the data in the import file. If you want to add a new financial adjustment, the Adjustment Date supplied in the import file must NOT already exist for the Asset in the Pinnacle database. If you want to update an existing financial adjustment, the Adjustment Date supplied in the import file MUST already exist for the Asset in the Pinnacle database. Updates and additions can be mixed within the one import file if necessary.
All the Required fields must be supplied when you are adding a new Financial Adjustment. If you are updating an existing Financial Adjustment, you do not need to supply the Required fields (other than the Asset Number and Adjustment Date). Any fields left blank in the import file when updating an existing Financial Adjustment will be left unchanged in Pinnacle.
The data file to import Asset Financial Adjustments must consist of fifteen (15) comma separated columns. The columns must be in the following order:
Column |
Field |
Required/Optional |
Description |
1 |
Asset Number |
Required |
If no asset number is supplied, the row will not be imported |
2 |
Depreciation Book Name |
Required |
The depreciation book name must already exist in the Depreciation Books table. |
3 |
Adjustment Date |
Optional |
If the adjustment date exists for the asset number, the financial adjustment will be updated. If the adjustment date number does not exist for the asset number, the financial adjustment will be added. |
4 |
Adjustment Type |
Optional |
This is the type of adjustment being added. The valid values are 'Q' for 'Acquisition, 'A' for 'Adjustment', 'V' for 'Net Revaluation', or 'G' for 'Gross Revaluation'. This will default to 'A' if no value is supplied. |
5 |
Adjustment Value |
Optional |
This will default to 0.00 if no value is supplied. |
6 |
Depreciable Status |
Optional |
This value must be 'Y' or 'N'. |
7 |
Depreciation Method |
Optional |
This value must be 'P' for Prime Cost, or 'R' for Reducing Balance. This will default to the existing value for the asset in the specified depreciation book if no value is supplied. |
8 |
Depreciation Rate |
Optional |
This will default to 0.00 if no value is supplied. |
9 |
Residual Value |
Optional |
This will default to 0.00 if no value is supplied |
10 |
Retirement Date |
Optional |
|
11 |
Accumulated Depreciation |
Optional |
This field will only be processed if the Adjustment Type is 'G'. |
12 |
Recalculate Option |
Optional |
This value must be 'R' for Depreciation Rate, 'V' for Residual Value, 'D' for Retirement Date, or 'N' for None. This will default to 'N' if no value is supplied. |
13 |
Comments |
Optional |
|
14 |
Invoice Number |
Optional |
The invoice number will only be used for financial adjustments of type 'Q' or 'A'. |
15 |
Supplier Name |
Optional |
The supplier name will only be used for financial adjustments of type 'Q' or 'A'. If the supplier does not already exist, it will be added. |
Asset Financial Adjustments Tab