Page 2 of 2
Re: Tally DayBook and Ledger Exercises EX28
Posted: Tue Mar 18, 2025 3:43 am
by Sreehari
Code: Select all
Select $Name, $_PrimaryGroup, $Parent, $$ascramt, $DebitTotals from Ledger where $_PrimaryGroup is like 'Fixed Assets' And $DebitTotals > 0
Re: Tally DayBook and Ledger Exercises 13
Posted: Tue Mar 18, 2025 4:31 am
by Dhana
SELECT $Name, $VoucherNumber, $Date, $LedgerName, $Party_LedName, $VoucherTypeName, $Amount, $Path FROM A__DayBook where $LedgerName is like 'Cash' AND $VoucherTypeName is like 'Payment' AND $Amount > 10000
Re: Tally DayBook and Ledger Exercises 19
Posted: Tue Mar 18, 2025 4:37 am
by Mpahalith
SELECT $Key, $MasterId, $AlterID, $VoucherNumber, $Date, $VoucherTypeName, $Led_Lineno, $Type, $LedgerName, $Amount, $Led_Parent, $Led_Group, $Party_LedName, $Vch_GSTIN, $Led_GSTIN, $Party_GST_Type, $GST_Classification, $Narration, $EnteredBy, $LastEventinVoucher, $UpdatedDate, $UpdatedTime, $Nature_Led, $Led_MID, $CompanyName, $Year_from, $Year_to, $Company_number, $Path FROM A__DayBook where $Led_Parent like "%Cash%" or $Led_Parent like "%Bank%"
Re: Tally DayBook and Ledger Exercises EX28
Posted: Tue Mar 18, 2025 4:37 am
by Sreehari
Code: Select all
SELECT $Key, $MasterId, $AlterID, $VoucherNumber, $Date, $VoucherTypeName, $Led_Lineno, $Type, $LedgerName, $Amount, $Led_Parent, $Led_Group, $Party_LedName, $Vch_GSTIN, $Led_GSTIN, $Party_GST_Type, $GST_Classification, $Narration, $EnteredBy, $LastEventinVoucher, $UpdatedDate, $UpdatedTime, $Nature_Led, $Led_MID, $CompanyName, $Year_from, $Year_to, $Company_number, $Path FROM A__DayBook where $Led_Parent is like 'Fixed assets'
Exercises Ex No: 10
Posted: Tue Mar 18, 2025 4:39 am
by Jey Prasaath
SELECT $Key, $MasterId, $AlterID, $VoucherNumber, $Date, $VoucherTypeName, $Led_Lineno, $Type, $LedgerName, $Amount, $Led_Parent, $Led_Group, $Party_LedName, $Vch_GSTIN, $Led_GSTIN, $Party_GST_Type, $GST_Classification, $Narration, $EnteredBy, $LastEventinVoucher, $UpdatedDate, $UpdatedTime, $Nature_Led, $Led_MID, $CompanyName, $Year_from, $Year_to, $Company_number, $Path FROM A__Daybook where $VoucherTypeName ="Sales" AND $Type="Credit"
Re: Tally DayBook and Ledger Exercises 32
Posted: Tue Mar 18, 2025 4:42 am
by Tarun
Code: Select all
SELECT $Key, $MasterId, $AlterID, $VoucherNumber, $Date, $VoucherTypeName, $Led_Lineno, $Type, $LedgerName, $Amount, $Led_Parent, $Led_Group, $Party_LedName, $Vch_GSTIN, $Led_GSTIN, $Party_GST_Type, $GST_Classification, $Narration, $EnteredBy, $LastEventinVoucher, $UpdatedDate, $UpdatedTime, $Nature_Led, $Led_MID, $CompanyName, $Year_from, $Year_to, $Company_number, $Path FROM A__DayBook where $GST_Classification is not null
Re: Tally DayBook and Ledger Exercise 2
Posted: Tue Mar 18, 2025 4:47 am
by Abinaya
Code: Select all
SELECT $Name, $_PrimaryGroup, $$AsDramt:$ClosingBalance FROM Ledger WHERE $_PrimaryGroup = "Sundry Creditors" and $$IsDr:$ClosingBalance
Re: Tally DayBook and Ledger Exercises 12
Posted: Tue Mar 18, 2025 4:49 am
by R.Kisshorekaran
SELECT $Key, $MasterId, $AlterID, $VoucherNumber, $Date, $VoucherTypeName, $Led_Lineno, $Type, $LedgerName, $Amount, $Led_Parent, $Led_Group, $Party_LedName, $Vch_GSTIN, $Led_GSTIN, $Party_GST_Type, $GST_Classification, $Narration, $EnteredBy, $LastEventinVoucher, $UpdatedDate, $UpdatedTime, $Nature_Led, $Led_MID, $CompanyName, $Year_from, $Year_to, $Company_number, $Path FROM A__Daybook where $VoucherTypeName ="Journal"
Re: Tally DayBook and Ledger Exercises No.11
Posted: Tue Mar 18, 2025 5:18 am
by SRO0666239
Code: Select all
SELECT $Key, $MasterId, $AlterID, $VoucherNumber, $Date, $VoucherTypeName, $Led_Lineno, $Type, $LedgerName, $Amount, $Led_Parent, $Led_Group, $Party_LedName, $Vch_GSTIN, $Led_GSTIN, $Party_GST_Type, $GST_Classification, $Narration, $EnteredBy, $LastEventinVoucher, $UpdatedDate, $UpdatedTime, $Nature_Led, $Led_MID, $CompanyName, $Year_from, $Year_to, $Company_number, $Path FROM A__Daybook where $VoucherTypeName ="Purchase"