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