Subledger Details resulting in Duplicate Lines
Content
I've created a subledger with details, but am noticing the lines are duplicating for my results. I've built the results in a normal table format as well in a pivot table format thinking the pivot table would strip out the duplicate and I could just apply "average" to the results for each line. But the duplicate still comes over.
Can anyone provide some insight as to why this is happening? I'm including my sql code as an attachment. Thanks in advance..dw
Code Snippet
SET VARIABLE PREFERRED_CURRENCY='User Preferred Currency 1';SELECT 0 s_0, "Subledger Accounting - Journals Real Time"."- Header Information"."Invoice Number" s_1, "Subledger Accounting - Journals Real Time"."- Header Information"."Invoice Type Name" s_2, "Subledger Accounting - Journals Real Time"."- Payment Information"."Status Meaning" s_3, "Subledger Accounting - Journals Real Time"."- Supplier Profile"."Supplier Name" s_4, "Subledger Accounting - Journals Real Time"."- Supplier Profile"."Supplier Number" s_5, "Subledger Accounting - Journals Real Time"."Accounting Class"."Accounting Class Meaning" s_6, "Subledger Accounting - Journals Real Time"."Balancing Segment"."Balancing Segment Code" s_7, "Subledger Accounting -
Tagged:
1