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
0 Answer(s)

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   Limebox   Become a Sponsor