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:
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.