Page 1 of 1
TDL V4
Posted: Mon Mar 17, 2025 1:54 am
by admin
Please Login to Download
From the Below Link
Re: TDL V4
Posted: Mon Mar 17, 2025 7:02 am
by admin
Code to Download the daybook
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
Re: TDL V4
Posted: Mon Mar 17, 2025 7:02 am
by admin
Power Query Code
Code: Select all
let
Source = Odbc.Query("dsn=TallyODBC64_9000", "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")
in
Source
Re: TDL V4 Exercise 13
Posted: Tue Mar 18, 2025 4:16 am
by Dhana
SELECT $Name, $VoucherNumber, $Date, $LedgerName, $Party_LedName, $Amount, $Path FROM A__DayBook where $LedgerName is like 'Cash' AND $Amount > 10000