Depreciation History Records for the Secondary Book was imported via CSV however they are showing on the Depreciation History page of the Primary Book instead.
To import Depreciation History Record for Secondary Book or as applicable:
- Create CSV file and include the following fields:
- Name
Note: Do not use “|” as a separator. - Alternate Depreciation
Note: This is the Internal ID for Local Accounting Standards Alternate Depreciation Method. - Asset
- Accounting Book
- Subsidiary
- Asset Type
- Transaction Type
- Date
- Transaction Amount
- Quantity
- Net Book Value
- Name
- Import CSV
- Navigate to Setup > Import/Export > Import CSV Records
- Import Type : Select Custom Records
- Record Type : Select FAM Depreciation History
- CSV file(s): Select One File to Upload
- Click Select
- Browse folder to select CSV file to be uploaded
- Click Next
- Data Handling: Click Add
- Click Next
- Map CSV fields with NetSuite fields, see article 9948 Step 4 Field Mapping for details
- Set Reference Type to use for fields that are Internal ID
Example: Alternate Depreciation, Asset and Subsidiary fields- Click Pencil Icon
- Choose Reference Type: Select Internal ID
- Click Done
- Click Next
- Import Map Name: Enter Name
- Click Save & Run