I am trying to populate latest date record to be printed for BPA from PO tables in a custom BIP — 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

I am trying to populate latest date record to be printed for BPA from PO tables in a custom BIP

edited Aug 8, 2025 1:55PM in BI Publisher Learning Center

Per the business requirement, we need to print COO from BPA attached to the shipment, if the shipment lines having country of origin code is NULL, and since there maybe multiple BPAs created against each inventory item lines so we need to print the latest bpa created record, but the max function seems not be working, also i was trying to join PO and WSH tables through below join ids also not to be working

SELECT
pha.segment1 AS po_number,
pol.line_num AS po_line_number,
wdA.delivery_id,
wdd.shipped_quantity,
hou.name AS business_unit_name

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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