Lot Number received based on PO
I am trying to get a report based on Analysis having two subject area, Inventory-Inventory Transactions Real Time and Procurement-Purchasing Real Time.
what connects these two subject area..?
Trying to find what links them and is there are common dimensions that can facilitate this.
My requirement is to see Lot Number received based on PO.
I am attaching the SQL which is appearing in Advanced tab. I am able to see Lot but I see duplicate values and second when I am adding supplier then this is showing error.
when I am trying it is t