Skip to main content
DD-GLT-003 Three Companies, Four Dates, One Close — GL, Trial Balance, Bank and Budget Get the data →
DD-GLT-003-Q034 Hard

Duplicate supplier invoices

A duplicate is a second posted PI journal with the same EntityCode, PartyCode, supplier invoice number (Reference) and amount (credit to 20000); invoices with no Reference are not duplicates. What is the total value of the duplicates (the second postings only), in USD?
Expected
One amount in USD, 2 decimals · KPI card
Tables
FactJournalLines, DimParty · columns
  • FactJournalLines
  • DimParty
  • JournalID
  • EntityCode
  • PartyCode
  • Reference
  • SourceCode
  • Credit
  • EnteredOn

Discussion

No one has posted here yet. Ask something, compare your result, or share how you solved it.

A free account takes a minute. Your draft is kept while you sign in. Need help? Message us

Create a free account Sign in