1. Account Administration
  2. CSV Imports
  3. CSV Import Error Messages
  4. Items Import Errors
  5. General Item Import Errors
  6. Invalid assetaccount reference key xxx or Invalid cogsaccount reference key xxx

Invalid assetaccount reference key xxx or Invalid cogsaccount reference key xxx

The error occurs when you update the asset or COGS account on Item record. There are three options to set a value on the Asset Account or COGS Account field.

Choose an option:

  1. Use the internal ID of the account. On the Field Mapping page, click the edit icon beside the Asset Account field. Click Choose Reference Type, and then select Internal ID.

  2. Use the account name. In your CSV file, make sure the asset account matches the format used in NetSuite.

    1. Go to Lists > Accounting > Items.

    2. Click Edit on any item record.

    3. In the Asset Account field on the Accounting subtab, copy the format of the field to the CSV file. The format used is as follows:

      • Account Number is not enabled: Parent Account

      • Account Number is enabled: Number Parent Account

      • Account Number is not enabled and there is a Child Account: Parent Account : Child Account

      • Account Number is enabled and there is a Child Account: Number Parent Account : Child Account

  3. Set a default value for the asset or COGS account if you want the same account for all items. On the Field Mapping page, select Asset Account or COGS Account under NetSuite Fields, click the edit icon, select Provide Default Value, and choose the account.

Related Topics

General Notices