Actual Costing calculation not considering miscellaneous receipt quantity
Hi
We observed that Actual Costing is not taking miscellaneous receipt quantity into consideration during cost calculation. As a result, VALUE adjustments are spread across incorrect quantity.
Say we have an item A with:
Prior Period Onhand quantity of 10 @ prior period item cost = 5
Current Period PO receipts quantity of 5 @ cost = 5
Current Period Misc receipt of 5
VALUE Adjustment of 15 $
PMAC cost calculation for current period is coming as ( (10*5) + (5*5) + 15 ) / (10+5) = 6 $
We wanted the VALUE adjustment to be spread across current total onhand quantity of 10+5+5 = 20, but it is being spread across only 10+5 = 15 quantity.
Can you please let us know, if there is a way to achieve this functionality ?