Hi community,
As User’s requirement on Journal Account Detail Tracking, we customize Screen GL633500 by adding PO Nbr, Receipt nbr on each line. However, there are many duplication data on the new report comparing to original one.
here is my schema builder (blue block above is the original one, blue block below the additional relations)
Appreciated for your advance support to remove the duplication data as shown in below sample
Regards,
+18
Hello,
Can you show the join on the three last Relationships that are custom to your report?
When we have too many results or too few results, the table Join is nearly always at issue.
When APInvoice is joined to APTran we need to join on both Reference number and DocType to Trantype.
When Batch is joined to INRegister, may need multiple fields too.
Laura
hi
here, the rest relations
all the relation based on the DAC Shema browser.
When you have both the AP Invoice and AP Tran table connected it will duplicate the AP Invoice data for every AP Tran line within that invoice.
For example, if you have AP invoice XYZ and in that invoice’s detail section you have four different transaction level lines, lets call them 1, 2, 3, and 4, the result will display four lines in your GI or report, one for each line in the detail section. You will end up with:
Invoice Number, Line Detail
XYZ, Line 1
XYZ, Line 2
XYZ, Line 3
XYZ, Line 4
Anything else that is connected will also repeat in the same manner.
+18
Hello,
Building on what HGilbert said, you may Group the data on the report by one of the APTran fields (by PO Receipt #?). Bills with multiple lines, each with different Receipt numbers will continue to list separately, multiple lines, one per Receipt.
Laura
Appreciated if there any workaround for this issue.
I’m trying to understand what your desired result is from your screen shot above.
Should this be displaying just the two highlighted lines? Once for each different description?
If so, perhaps try grouping by this field and see if that helps.
Another possibility is that you may need to utilize a sub report. The main report would call up just the invoice table, and then pass a parameter through to the subreport which can be linked to the APTran table. This would prevent the duplication in the main report as you would not have the APTran table connected there.
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.
