Skip to main content

On the Inventory Transaction History screen, there is a handy button to ‘Include landed cost in unit cost’. Interestingly, this also updates the impact of any PPV cost adjustments on the receipt.

Without PPV (original PR price) & with PPV (after PPV revalued)

Is there any easy method to retrieve this additional cost layer information through a GI, so we can push it through an import scenario? 

Specifically, we need to update the Last Cost of specific valued items so that it reflects the actual receipt cost with PPV revaluation included. Otherwise, our cost rolls are taking the incorrect last cost sans-PPV revaluation.

Did you ever have any success with this? 


I’m also requesting the same thing. Were you able to find a solution for this, ​@kokjietan ?


You can try to pull the PPV-adjusted cost into a GI by joining INTran with POReceiptLine and including cost-only adjustments (TranType = 'ADJ', InvMult = 0). Sum those against the original receipt cost to get the actual unit cost. Then you can feed that through an import scenario to update the Last Cost.


Reply