Saturday, June 8, 2019

CSV Import to update COGS Account on Item record > Error: Invalid cogsaccount reference key xxx.

There are 3 options to set a value on the COGS Account field:

I. Use the Internal ID of the Account

-On the Field Mapping page, map the COGS Account field, click on the pencil icon and set Choose Reference Type to Internal ID.


II. Use the Account Name

-On the CSV file, COGS Account should have the same format reflected in NetSuite.

1. Navigate to Lists > Accounting > Items

2. Click Edit on any Item record

3. Accounting subtab > enter the account on the COGS Account field > copy the format on the CSV file

Format used is as follows:

a. Account Number is not enabled:

            Parent Account

b. Account Number is enabled:

Number Parent Account

c. Account Number is not enabled and there is a Child Account:

            Parent Account : Child Account

d. Account Number is enabled and there is a Child Account:

            Number Parent Account : Child Account


III. Set a Default Value for the COGS Account

-This option is feasible if the same COGS Account is to be set on all the Item records.

-On the Field Mapping page, select COGS Account under NetSuite Fields, click on the pencil icon and set the COGS Account on the Provide Default Value field.

No comments:

Post a Comment