Hi,
I want to create a report in Payments and Application form.
when I create a record in invoices form, A record will automatically create in Applications history tab in the Payments and Applications form.
how can I make the relationship in the Report Designer to connect Invoices form and this record to the Payments and Applications form to fetch the data in the invoice form?
I want to create a Report in the Payments and Applications form to get inventoryID, Desc from ARTan.
Thanks.
Best answer by Manikanta Dhulipudi
Hi
Below attached Generic inquiry gives you the details on the relations to initate the reportd design
+15Hi
Below attached Generic inquiry gives you the details on the relations to initate the reportd design
+19Hello,
In addition to Manikanta’s answer above, the relationship between Billing documents and AR Payments is found in ARAdjust table. To show invoices and payment details in the same GI or report, we join from ARInvoice (on Ref Number & Type) to ARAdjust (onAdjusted Reference Number and type), then from ARAdjust (on Adjusting Reference Number and Type) to ARPayment (on Ref Number and Type).
It’s very similar in AP when joining AP Bill to AP Check.
Laura
Thanks very much for the help
So if i join ARTran to ARInvoice, should I be able to display [ARTran.InventoryID] ?
+15Hi
Thank you
Hi
Can you share the Generic Inquiry template here?
Thanks
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
