Skip to main content
Question

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


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.

3 replies

  • Freshman I
  • 6 replies
  • 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.


Reply


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings