Learn about Redwood and be one of the first to join the conversation

Visit Redwood Community
Lot Number received based on PO — Cloud Customer Connect
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
14
Views
3
Comments
edited Mar 1, 2021 3:35PM in Reporting and Analytics for SCM 3 comments

Content

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

Version

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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