We have a transaction saved search which mimics the Inventory Activity Detailed report.
CRITERIA
RESULTS
We need two other columns:
1) if the record is an Item Receipt, we need to retrieve the Rate field from PO. I.e. the purchase price when the PO was created
2) if the record is an Item Receipt, we need to retrieve the Sales Order from which the PO was created (if there is one)
Any pointer would be greatly appreciated.
Thanks,
Sanjeev