SuiteAnalytics Data Duplication

Trying to figure out a way to remove duplicates. I need to pull all invoices and then show how they were paid and the amount of every line item (Main line has to be false). When the invoice has multiple payment methods (credit memo and invoice or multiple payments on the same invoice.) the line item amount gets duplicated and therefore overstates revenue.

 

Has anyone found a way to ensure line items don’t get duplicated when pulling the  Related transactions – Next — transaction payment type?

Rookie Asked on December 9, 2021 in SuiteAnalytics.
Add Comment
1 Answer(s)

I can’t believe that nobody has answered this simple question in over a year. The SQL “DISTINCT” keyword will solve that problem instantly:

https://www.w3schools.com/sql/sql_distinct.asp

Rookie Answered on May 24, 2023.
Add Comment

Your Answer

By posting your answer, you agree to the privacy policy and terms of service.
  • This site made possible by our sponsors:   Tipalti   Celigo   Become a Sponsor   Become a Sponsor