Search found 3 matches
- Tue Mar 18, 2025 6:40 am
- Forum: PPT 's
- Topic: workings file - Integrated Case Study
- Replies: 0
- Views: 26
workings file - Integrated Case Study
workings file - Integrated Case Study
- Tue Mar 18, 2025 3:48 am
- Forum: Integrated Case Study - Day1 (ERP)
- Topic: SQL
- Replies: 3
- Views: 344
Re: SQL Date Filter
Code: Select all
Select $Name, $Createdby, $CreatedDate, $Masterid, $Alterid, $Alteredon, $Alteredby, $Updateddatetime, $LastVoucherDate, $Parent, $_PrimaryGroup, $$AscrAmt:$openingBalance, $$AscrAmt:$_ClosingBalance from ledger where $CreatedDate >= $$Date:"01-04-2024" - Tue Mar 18, 2025 2:25 am
- Forum: Integrated Case Study - Day1 (ERP)
- Topic: Tally DayBook and Ledger Exercises
- Replies: 18
- Views: 653
Re: Tally DayBook and Ledger Exercises Ex 1
Code: Select all
SELECT $Name, $_PRimaryGroup, $$ascramt:$ClosingBalance FROM Ledger WHERE $_PrimaryGroup = "Sundry Debtors" AND NOT $$IsDr:$ClosingBalance