Hello. I have been trying to add inventory items using csv but it keeps giving me an error "You entered "ERROR: Invalid Expression" into a field where a numeric value was expected. Please go back and change this value to a number." I narrowed it down to COGS/Asset Accounts and I have no idea why it is wanting me to use numeric value even when I actually manually set which account I want it to use using that pencil icon on the left of the mapping. Any ideas why this is happening?

Possibly wants the internalid?

I never had problem with internalid when adding in inventory items with csv previously. So this puzzles me even more.

is your csv values the string value of the account or the internal id of the account?

I finally found the issue. And as I expected it was something extremely small. Someone had set up a formula on one of the custom fields (Currency) and it was returning "Error:Invalid Expression".