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

Visit Redwood Community
Need to get a report for PO's where we can filter by BU's — 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

Need to get a report for PO's where we can filter by BU's

Received Response
27
Views
5
Comments
edited Jun 22, 2020 4:34AM in Reporting and Analytics for SCM 5 comments

Summary

Need to get a report for PO's where we can filter by BU's

Content

Hello,

Grateful if you can help on how to get a list of all GRN's for Received Shipments for a Specific BU please?

Below are the previous SR's raised and now that we got the knowledge on how to build the report, can you help us with the exact query to join the 4 table names provided to build the report please.

Table names
PO_HEADERS_ALL
PO_LINES_ALL
PO_LINE_LOCATIONS_ALL
PO_DISTRIBUTIONS_ALL

Thank you

Yogesh

Version

20A

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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