Top N Debtors from Tally

[admin]

Copy paste the below code in the Calculator Panel of Tally and Press Enter

Code: Select all

SELECT Top 3 $Name, $_PrimaryGroup, $Parent, $$AsCrAmt:$_ClosingBalance from Ledger where $_PrimaryGroup is like "Sundry Debtors" and  $$isdr:$_ClosingBalance and $_ClosingBalance > 0  order by $_ClosingBalance

[/size]

[Rathinagiri]

Nice one. For creditors please change to Sundry Creditors and order by desc since dr baance is positive.