Hi @dilys! I would recommend to use the Merged DAC Structure (SM402000) screen to look for ways to link from APRegister to POReceipt. Have you already tried using this screen or the GI relations builder to find the stepping stones to get from AP to PO Receipts?

Here is what I see to link them:

Hi @dilys! I would recommend to use the Merged DAC Structure (SM402000) screen to look for ways to link from APRegister to POReceipt. Have you already tried using this screen or the GI relations builder to find the stepping stones to get from AP to PO Receipts?

Here is what I see to link them:

 

Yes, I use this to search for relation but in PO Receipt field apRefNbr and aPDocType is Null when I query in database

Hi @dilys,

Not sure if you can directly link AP Bill to PO Receipts, since you may have several receipts associated with a bill and vise versa.

Did you try adding the APTran and POReceiptLine tables to your report?

Here is an example of how you get the Receipt line linked to the AP Bill line. See attached my test GI for your reference.

Hello,

Is the the POReceipt → APRefNbr field always null?

I am following up this post as I am  trying to modify the PO Receipt form, PO646000, to reflect the AP BIll reference number by referencing the POReceipt → APRefNbr field. 

Using the example below I want to print the AP Billing Reference Nbr ‘003080’ for PO Receipt ‘PR001665’ on the form.  

When I modify the form and add the POReceipt → APRefNbr it displays a blank.

Following onto that, I created a GI with just the POReceipt DAC and referenced the  APDocType and APRefNbr fields in the results  grid.

The results showed nulls for the APDOCNbr field.