Search found 4 matches
- Tue Mar 18, 2025 7:25 am
- Forum: Integrated Case Study - Day1 (ERP)
- Topic: Email Script in Pyhton
- Replies: 2
- Views: 100
Re: Data Extracted from tally and Sent to Multiple Person Via Mail
import pyodbc import warnings import pandas as pd import time from datetime import datetime import pathlib import subprocess import os warnings.filterwarnings('ignore') pyodbc.drivers() import pandas as pd server = 'localhost,9000' #database = 'database_name' # enter database name cnxn = pyodbc.con...
- Tue Mar 18, 2025 3:07 am
- Forum: Integrated Case Study - Day1 (ERP)
- Topic: Tally DayBook and Ledger Exercises
- Replies: 18
- Views: 650
Re: Tally DayBook and Ledger Exercises EX16
Code: Select all
Select $Name, $Parent, $Closingbalance from Ledger where $_PrimaryGroup = 'Sundry Creditors' And $Closingbalance > 100000- Tue Mar 18, 2025 3:01 am
- Forum: Integrated Case Study - Day1 (ERP)
- Topic: Tally DayBook and Ledger Exercises
- Replies: 18
- Views: 650
Re: Tally DayBook and Ledger Exercises Ex 15
Code: Select all
Select $Name, $Parent, $Closingbalance from Ledger where $_PrimaryGroup = 'Sundry Debtors' And $Closingbalance > 100000- Tue Mar 18, 2025 2:30 am
- Forum: Integrated Case Study - Day1 (ERP)
- Topic: Tally DayBook and Ledger Exercises
- Replies: 18
- Views: 650
Re: Tally DayBook and Ledger Exercises Ex 3
Code: Select all
SELECT $Name, $_PRimaryGroup, $$ascramt:$ClosingBalance FROM Ledger WHERE $_PrimaryGroup = "Loans (Liability)" AND NOT $$IsDr:$ClosingBalance