Tricky~23min

The Credit Phantom

Month-end AP reconciliation balances perfectly. Finance is happy. But someone in the vendor relations team noticed ₹27.2L in return credits that seem to have come back twice. The summary numbers hide it. The detail doesn't.

Tables you'll query

vendorspurchase_ordersledger_entries

What you'll learn

SubqueriesJOINsAggregations & GROUP BY
Investigate this case →