Product Entry Import Average Cost Report overview

Product > Entry > ICE Reports > ICEIA

Function acronym: ICEIA

Use this report to batch process to import a comma-separated value (.csv) file and update the Average Cost of products in Product Warehouse Product Setup.

You must have a .csv file formatted and populated with these three elements per line:

  • Warehouse - this element must be a valid warehouse in Product Warehouse Description Setup.
  • Product - this element must be a valid product in Product Setup.
  • New Average Cost - this element must be a positive value.

When you run this import function, you must specify the name of the import file, e.g., importcost.csv. (The name does not have to include the .csv file type designation; it is appended automatically.) You must also specify a beginning and ending Posting Date used when creating the GL journal.

Your Post to GL By option in SA Admin Options - Products - Costs must be Average Cost and FIFO Layers must not be in use. Product Entry Import Average Cost Report creates GL adjustments, IC transactions, and balance change records just as Product Maintain Costs Entry does.

Note:  Since the current On Hand, Unavailable, and Received quantities in Product Warehouse Product Setup are used to calculate average cost, you should not run the import until after all processes that update these quantities are complete. You should not use Product Entry Import Average Cost Report to post cost changes for a future date.

The report output for this import lists the journal number created, and shows any errors that may have occurred. You can use Product Entry Journal Print to view the GL journal that is created.