You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

Subledger Details resulting in Duplicate Lines

edited Jun 28, 2021 6:52PM in Reporting and Analytics for ERP 1 comment

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:

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!