We'd love to hear from you! Provide  feedback  to earn a badge today. Take our quick survey
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
26
Views
2
Comments
edited Jun 22, 2020 4:34AM in Reporting and Analytics for SCM 2 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!