Getting Started with Multi-Book Accounting for Fixed Assets Management

Prerequisites for Fixed Assets Multi-Book Accounting

You must perform the following tasks before proceeding:

Roles and Permissions

If you're using a custom role with Multi-Book Accounting for Fixed Assets Management, set the Accounting Book permission to View. This enables custom roles to set up accounting books. For more information, see Roles and Data Access for Multi-Book Accounting.

Updating Historical Depreciation History Records

The asset register report groups the depreciation history records by accounting book. To include entries without an accounting book, you must update your depreciation history record through mass update or CSV import.

Note:

When you enable Multi-Book Accounting for the first time in your account, all historical depreciation journals are automatically updated to Primary Accounting Book.

To update historical depreciation history records through mass update:

  1. Go to Lists > Mass Update > Mass Updates.

  2. Expand General Updates, then under Custom Records, click the FAM Depreciation History link.

  3. In the Criteria subtab, add the following filters:

    • Accounting Book - Select None to update only the depreciation history records with blank accounting books.

    • Alternate Method – Select None to update only the depreciation history records for the asset's accounting method.

  4. In the Mass Update Fields subtab, check the Accounting Book field, and then set the value to Primary Accounting Book.

  5. Click Preview.

  6. Click Perform Update.

To update historical depreciation history records through CSV import:

  1. Prepare an import file by creating a saved search for depreciation history records.

    1. Go to Lists > Search > Saved Searches > New.

    2. On the New Saved Search page, click the FAM Depreciation History link.

    3. In the Criteria subtab, add the following filters:

      • Accounting Book - Select None to update only the depreciation history records with blank accounting books.

      • Alternate Method – Select None to update only the depreciation history records for the asset's accounting method.

    4. Click Preview, and then export the search results to CSV. For more information, see Exporting Search Results.

    5. Edit the CSV file to add a column for Accounting Book, and then set the value to Primary Accounting Book.

    6. Save the CSV file.

  2. Import CSV file for depreciation history record.

    1. Go to Setup > Import/Export > Import CSV Records.

    2. In the Import Assistant Step 1 – Scan & Upload CSV File screen:

      • From the Import Type list, select Custom Records.

      • From the Record Type list, select FAM Depreciation History.

      • Select the CSV file to upload.

      • Click Next.

    3. In the Import Assistant Step 2 – Import Options screen:

      • Set Data Handling to Update.

      • Click Next.

    4. In Import Assistant Step 4 – Field Mapping screen:

      Setting the Reference Type for the DHR import

      Map the fields in your CSV file to the NetSuite fields. Review the both sets of fields to ensure that all required fields are mapped correctly. Make sure that the Internal ID mapping type is set to Internal ID.

    5. In the Import Assistant Step 5 – Save Mapping and Start Import screen:

      • Enter an Import Map Name and Description.

      • Click Save & Run.

Related Topics

General Notices