Skip to main content
Question

generic inquiry to show list of production order with is planned material cost and actual cost

  • January 29, 2026
  • 1 reply
  • 21 views

Forum|alt.badge.img

Hello Experts, i was looking to create a GI to show material planned cost and actuaL cost for production order, i was in doubt that the data which i am looking because values may be calculated value, it may not be stored value. can anyone suggest me your opinion for this.

1 reply

  • Freshman II
  • January 29, 2026

Hi,

Both planned and actual material costs are calculated values. Planned material cost is calculated from BOM quantities and unit costs.

The actual material cost for each operation is equal to a sum of material costs, where each material cost is calculated as the unit cost multiplied by the issued quantity.

This is described in the Acumatica documentation here:
Material Costs

Hope this helps.