Imported Depreciation History Records via CSV import for Secondary Book is Showing on Primary Book

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:

  1. 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
  2. Import CSV
    1. Navigate to Setup > Import/Export > Import CSV Records
    2. Import Type : Select Custom Records
    3. Record Type : Select FAM Depreciation History
    4. CSV file(s): Select One File to Upload
    5. Click Select
    6. Browse folder to select CSV file to be uploaded
    7. Click Next
    8. Data Handling: Click Add
    9. Click Next
    10.  Map CSV fields with NetSuite fields, see article 9948 Step 4 Field Mapping for details
    11. Set Reference Type to use for fields that are Internal ID
      ExampleAlternate Depreciation, Asset and Subsidiary fields
      1. Click Pencil Icon
      2. Choose Reference Type: Select Internal ID
      3. Click Done
    12. Click Next
    13. Import Map Name: Enter Name
    14. Click Save & Run

Leave a comment

Your email address will not be published. Required fields are marked *