Cost Adjustment issue

NAV__Developer

Hello,

Trying to solve a following problem:

Item Costing Method is Average.

Customer purchase raw material by units but consume them by weight.

For example

Purchased and invoiced 100 units at 1£ so value entry shows 100£ as Actual cost

Then Consumed 50 units (49 kg), so posted actual cost on value entry is -49£
Then Consumed 50 units (51 kg), so posted actual cost on value entry is -51£

The problem is when Item Cost Adjust entries is run, then system posts an adjustment to each consumption entry to make them equal to 50£ and 50£

Customer does not want that.

Thank you for any help.

Alan

Alex_Chow

Adjust cost is done by unit of measure. If you want the behavior you described, you have to change your base UOM to KG.