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.
Best answer by aborisova37
View originalHow to link AP Bill (AP301000) with Purchase Receipt (PO302000) to create new GI ?
Userlevel 7
+4
Hi
Here is what I see to link them:
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
Userlevel 5
+1
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.
Userlevel 2
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 username or e-mail address. We'll send you an e-mail with instructions to reset your password.