Hi all, I want to create new GI which can show the total cost of purchase receipt and total amount of bill but I dont know how to link because there is no link between 2 screens
Thanks in advanced.
Solved
How to link AP Bill (AP301000) with Purchase Receipt (PO302000) to create new GI ?
Best answer by aborisova37
Hi
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.
+4Hi
Here is what I see to link them:
1 person likes this
BenjaminCrisman wrote:
Hi
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
+1Hi
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.
~Anna
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.
Reply
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.