Hi,
I want to get the information on the applied documents to the Payments and Applications form (AR302000) to a copy of the standard report that we are customizing. The standard report is AR Register Detailed (AR622000). We have used the following relationships to get the relevant data to the report.
But the data does not display in the report as expected.
can anyone please assist me on getting the relevant data to the report..
Best answer by Laura02
View original
+18
Hello,
To make sure we understand the task: you are trying to add the Paid document details to the Payment records on your AR report?
It looks like you have joined the ARPayment table to ARAdjust using the Payment fields. If you have multiple companies you may wish to add Branch. You may wish to check that all key fields are used in this join.
To answer the rest of your question, it’s helpful for us to see the unexpected results. Do you have duplicates? Duplicates are usually caused by incorrect join; see above suggestion. Is the data missing? If data is missing, show us what fields you have added to report, to represent the paid documents.
Thank you.
+4
Hi
Have you tried linking directly to ARRegister to get these payment details?
Otherwise, as
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.
