Skip to main content
Solved

Obtaining last cost with cost layers included (eg. PPV or landed cost)

  • March 7, 2024
  • 3 replies
  • 299 views

Forum|alt.badge.img

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.

Best answer by davidnavasardyan

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.

3 replies

  • Freshman I
  • February 19, 2025

Did you ever have any success with this? 


dominicpolicicchio03
Freshman I
Forum|alt.badge.img

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


davidnavasardyan
Jr Varsity I
Forum|alt.badge.img+3

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.