Item 408062 – Unit cost doubles in CST_PERPAVG_COST_HEADER_V following an acquisition cost

Summary:

Dear Team,

We are investigating a difference between the perpetual average cost stored in CST_PERPAVG_COST and the TOTAL_UNIT_COST returned by CST_PERPAVG_COST_HEADER_V for item 408062.

The view returns USD 10,155.52, although both the original and subsequent average-cost records contain USD 5,077.76. We need clarification on the intended behavior of the view and the supported extraction logic for an integration.

Transaction sequence and findings

1. The initial PO receipt was processed for 1 EA at USD 5,077.76. This created average-cost record 4471232, with UNIT_COST_AVERAGE = 5,077.76.
2. The receipt quantity was subsequently fully issued through project transfer transaction 2737726.
3. Invoice 9000335317 introduced USD 147.26 of nonrecoverable tax