Invalid assetaccount reference key xxx or Invalid cogsaccount reference key xxx
The error occurs when updating 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:
-
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.
-
Use the account name. In the CSV file, the asset account should have the same format used in NetSuite.
-
Go to Lists > Accounting > Items.
-
Click Edit on any item record.
-
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
-
-
-
Set a default value for the asset or COGS account. This option is feasible if the same asset or COGS account is to be set on all of the item records. On the Field Mapping page, select Asset Account or COGS Account under NetSuite Fields. Click the edit icon, click Provide Default Value, and select the asset or COGS account.