QAD 2017 Enterprise Edition > User Guides > Fixed Assets > Creating and Managing Fixed Assets > Using CIM to Load Fixed-Asset Data > Using CIM with Fixed Asset Maintenance
  
Using CIM with Fixed Asset Maintenance
When loading CIM data into Fixed Asset Maintenance, include the names of the buttons that are pressed while manually entering data. The following example illustrates how to add asset FA01 by specifying the Add button.
@@batchload fafamt.p
"add"
"FA01" "Asset Added through CIM" "FL01" "001"
04/24/07 1000
100
"end"
@@end
CIM Data Input File for Depreciation Amount is an example of a CIM data input file to add an asset and update the depreciation amount and date for a selected book. An explanation of each line follows the example.

CIM Data Input File for Depreciation Amount
 
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
@@batchload fafamt.p
"add"
"FA02" "Asset Added through CIM" "FL01" "001"
04/28/07 1000
100 1000 1 Yes "Auth-No"
"books"
"find"
"PB"
"detail"
"update"
300 04/26/07
"end"
"end"
"end"
.
@@end
CIM Data Input File Elements explains each element of the CIM data input file.

CIM Data Input File Elements
 
Line
Explanation
1
Indicates the beginning of the CIM data file
2
Select Add button on the Fixed Asset Maintenance header
3
“FA02”: Asset field
“Asset Added through CIM”: Asset description field
“FL01”: Class field
“001”: Location field
4
04/28/07: Service Date field
1000: Cost field
5
100: Salvage field
1000: Replacement field
1: Components field
Yes: Depreciate Asset field
“Auth-No”: Auth Number field
6
Select Books button on the Fixed Asset Maintenance header
7
Select Find button on the Depreciation Books frame
8
Enter the name of the book to find: PB
9
Select Detail button on the Depreciation Books frame
10
Select Update button on the Book Detail frame
11
300: Override Accumulated Dep field
4/26/07: Override Depreciation Date field
12
Select End button on the Book Detail frame
13
Select End button on the Depreciation Books frame
14
Select End button on the Fixed Assets Maintenance header
15
End
16
Indicates the ending of the CIM data file
In Fixed Asset Location Maintenance (32.1.13), you can define a sub-account and cost center for all assets referencing a location. This sub-account and cost center combination sets the default for all accounts defined in Fixed Asset Maintenance.
In some cases, a business may have different sub-accounts or cost centers associated with each fixed-asset account. The default values can be modified using a CIM-load script.
Up to seven accounts can be defined in the Accounts frame of Fixed Asset Maintenance. See Asset Account Maintenance. These are referenced by numbers from 1 to 7.
1: Asset Account
2: Accumulated Expense
3: Periodic Expense
4: Construction in Proc
5: Gain on Disposal
6: Loss on Disposal
7: Asset Suspense
The example in CIM Data Input File for Updating Accounts is a CIM data input file to update the first three GL accounts of an existing asset. The general format is as follows:
• Enter a number representing the account type (1–7).
• On the next line, specify an update statement.
• On the next line, enter account code values: account, sub-account, cost center, and project.

CIM Data Input File for Updating Accounts
 
 
@@@batchload fafamt.p
"find"
"asset1"
"options"
"accts"
"1"
"update"
"1800" "sub1" "cc-1" "pr1"
"2"
"update"
"1810" "sub2" "cc-2" "pr1"
"3"
"Update"
"1820" "sub3" "cc-3" "pr1"
"end"
"end"
"end"
@@end