About Posting - Average Cost Method

This topic describes the average cost method of posting.

Posting of Costs At Receipt for Average Cost Items

These transactions increase inventory on-hand quantities:

  • Purchase order receiving
  • Job receipt
  • Job transactions posting
  • Job material withdrawal
  • Stock adjustment
  • Cycle count posting
  • Miscellaneous receipt
  • Physical inventory posting

An increase in inventory due to a purchase order receipt, job transaction, or miscellaneous inventory receipt is associated with a new calculation of the Average cost, which in turn is posted to the (Standard) Unit CostItems form.

An increase in inventory due to a stock adjustment, through cycle count posting, physical inventory posting, or from a job material withdrawal does not affect the value in the field on the Unit Cost field.

The new Average cost calculation is:

AC = (OQOH * OAC) + (RQ * RC) / (OQOH + RQ)

Where:

  • AC = Average cost
  • OQOH = old quantity on-hand
  • OAC = old Average cost
  • RQ = receipt quantity
  • RC = Receipt cost

The Receipt cost (RC) in the calculation varies, depending upon the type of transaction being processed:

  • When an item is received through the purchase order receiving function, the receipt cost default value comes from the Purchase Order Lines form's Unit Cost field.
  • When a miscellaneous receipt is performed, you enter the receipt cost at the time the transaction is processed.
  • If the job is not closed and the Costs Based on Complete parameter is set to "Jobs," the receipt cost used is the Planned unit cost of the job. (The Planned unit cost is based on the setup, run times, and the rates from the Current Operations and Current Materials forms.)
  • If the job is not closed, and the Costs Based on Complete parameter is set to "Operations," the receipt cost used is determined by the "Complete" flag of the job's operations.
  • field on theActual costs from completed operations are accumulated while planned costs from incomplete operations are accumulated to determine the final receipt cost.

Posting of Costs At Issue for Average Cost Items

These transactions decrease inventory on-hand quantities:

  • Job material issue
  • Purchase order return
  • Stock adjustment
  • Cycle count posting
  • Physical inventory posting

All issues out of stock are done at the item's Average cost at the time of the transaction, including the posting to the G/L Journal.

All of the Inventory reports that use cost information use the item's Average unit cost at the time the report is executed. The reports using cost information include:

  • Item Cost By Product Code Report
  • Item Costing Report