Code: Select all
SELECT $Name, $_PrimaryGroup, $$AsDramt:$ClosingBalance FROM Ledger WHERE $_PrimaryGroup = "Sundry Creditors" and $$IsDr:$ClosingBalanceCode: Select all
SELECT $Name, $_PrimaryGroup, $$AsDramt:$ClosingBalance FROM Ledger WHERE $_PrimaryGroup = "Sundry Creditors" and $$IsDr:$ClosingBalance