...
Note 8 For INVMI Record Type
...
Exception:
What to do if your import file is hardcoded to zero’s and you need AGRIS to use the item’s average cost.
Modify the Import template to blank out the UNIT COST and TOTAL COST fields. They must be blank for AGRIS to load average cost.
AGRIS > Maintenance > Import Maintenance > Select Import > Modify Button
...
Set the Unit Cost and The Total cost to Asterisk for the old value (wild card for any value) and new value to blank.
...
Upon import into AGRIS, these fields will be wiped out to blank and AGRIS will use the item’s cost as stored in the Inventory or Commodity Package.