Search found 3 matches
- Tue Mar 18, 2025 4:31 am
- Forum: Integrated Case Study - Day1 (ERP)
- Topic: Tally DayBook and Ledger Exercises
- Replies: 18
- Views: 665
Re: Tally DayBook and Ledger Exercises 13
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
- Tue Mar 18, 2025 4:16 am
- Forum: Integrated Case Study - Day1 (ERP)
- Topic: TDL V4
- Replies: 3
- Views: 270
Re: TDL V4 Exercise 13
SELECT $Name, $VoucherNumber, $Date, $LedgerName, $Party_LedName, $Amount, $Path FROM A__DayBook where $LedgerName is like 'Cash' AND $Amount > 10000
- Tue Mar 18, 2025 3:07 am
- Forum: Integrated Case Study - Day1 (ERP)
- Topic: Tally DayBook and Ledger Exercises
- Replies: 18
- Views: 665
Re: Tally DayBook and Ledger Exercise 5
Code: Select all
SELECT $Name, $LedgerName, $OpeningBalance, $_closingBalance FROM Ledger WHERE $OpeningBalance = $_closingBalance