Hi,
I am trying to get the PO in the Inventory WIP Reconciliation Report by joining the tables Recon and PartTran with fields Company, PartNum, TranType, TranDate and TmpReference
But I am getting the duplicate rows. Is there any idea how to get the PO from PartTran
We’re on Kinetic but suspect the PartTran field names remain the same…should be PartTran.OrderNum (PO), PartTran.OrderLine (line), PartTran.OrderRelNum (release)
How to find the PO when the TranType is ADJ-PUR?
The problem is sometimes getting the duplicate rows when try to join the Recon Table with PartTran. Because there is not much mapping fields exist in Recon.
Sometimes Company, PartNum, TranType, TranDate and TmpReference will be same for many rows
Check fields PartTran.PONum, PartTran.POLine, PartTran.PORelNum then…occasionally the transaction mapping differs by type (PUR-XXX or XXX-PUR).
Value is exist in PartTran.PONum. But the problem is when mapping to Recon. Multiple PO is exist in PartTran for the records in Recon