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

Table name that holds the Supplier Site Purchasing Tab data

Received Response
27
Views
1
Comments
in Reporting and Analytics for ERP 1 comment

Summary:

Table name that holds the Supplier Site Purchasing Tab data

Content (required):

I'm trying to create a BI Report to monitor when PO's are not communicated out to the Suppliers. My BI is using the po_headers_all,

pozsuppliers and  hz_parties hzp tables to pull Supplier/PO info.

Then it uses a sub-query to look at the Document History Table, to see if there is a "comunicate" row.

The missing piece is I need to only pull Suppliers who have their Purchasing Communication Method set to "Email". See attached screenshot.

What table can I pull the Purchasing Communication Method from?

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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