You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

Lot Number received based on PO

Received Response
edited Mar 1, 2021 3:35PM in Reporting and Analytics for SCM 3 comments


Hi Freinds,


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



Howdy, Stranger!

Log In

To view full details, sign in.


Don't have an account? Click here to get started!