Tally Connector V 5 - Beta Trial

[admin]

Please click here to download

https://workdrive.zohopublic.in/externa ... ef68c07a96


We are still in touch with the developer to give a Community version for a long term demo .

Until then please use this trial version of PAID TDL For the Next 30 Days with Pyhton Integration

For Any issues please email to Ram@ramajayam.in


More SQL queries here

https://github.com/ramajayam-CA/TallyCo ... Accountant



Daybook

For Calculator Panel

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

For Power Query (Advanced Editor)

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

Ledger Forensics

For Calculator Panel

Code: Select all

Select $Name, $Createdby, $CreatedDate, $Masterid, $Alterid, $Alteredon, $Alteredby, $Updateddatetime, $LastVoucherDate, $Parent, $$AscrAmt:$openingBalance, $$AscrAmt:$_ClosingBalance from ledger order by $Alterid desc

For Power Query (Advanced Editor)

Code: Select all

let
    Source = Odbc.Query("dsn=TallyODBC64_9000", "Select $Name, $Createdby, $CreatedDate, $Masterid, $Alterid, $Alteredon, $Alteredby, $Updateddatetime, $LastVoucherDate, $Parent, $$AscrAmt:$openingBalance, $$AscrAmt:$_ClosingBalance from ledger order by $Alterid desc")
in
    Source

GST Single Sheet Data

Code: Select all

SELECT $MKey, $Date, $Vch_Type_Parent, $Vendor_Invoice_Number, $Vendor_Invoice_Date, $MVoucher_Number, $TTV_Revenue, $TTV_BalanceSheet, $CgTax, $SgTax, $IgTax, $CessTax, $Vendor_CustomerName, $Vch_GSTIN, $Led_GSTIN, $PlaceOfSupply, $COMPANY_GSTIN FROM AA_T__GSTSheet

For Power Query (Advanced Editor)

Code: Select all

let
    Source = Odbc.Query("dsn=TallyODBC64_9000", "SELECT $MKey, $Date, $Vch_Type_Parent, $Vendor_Invoice_Number, $Vendor_Invoice_Date, $MVoucher_Number, $TTV_Revenue, $TTV_BalanceSheet, $CgTax, $SgTax, $IgTax, $CessTax, $Vendor_CustomerName, $Vch_GSTIN, $Led_GSTIN, $PlaceOfSupply, $COMPANY_GSTIN FROM AA_T__GSTSheet")
in
    Source

Cost Center

Code: Select all

SELECT $Key, $MasterId, $AlterID, $VoucherNumber, $Date, $VoucherTypeName, $VchTypeParent, $Lineno, $Type, $Particulars, $CC_Name, $CC_Amt, $Led_Group, $Vendor_Inv_Number, $Vendor_Inv_Date, $UpdatedDate, $UpdatedTime, $Nature_Led, $CompanyName, $Year_from, $Year_to, $Company_number, $Path
FROM A_CostCenter

[cvpawar]

Thank you so much for Tally Connector V5 Beta Trial. This is working good with Tally prime. However, this is not working with Tally Erp 9

[admin]

Thank you so much for Tally Connector V5 Beta Trial. This is working good with Tally prime. However, this is not working with Tally Erp 9

You can update the data to new version and use

[cvpawar]

Thank so much for TDL. When will be the long term demo version will be available? Whether this TDL (Tally Connector V5) will expire on 13.5.2025? What is option for Paid longer term version of BASIC Tally connector TDL?

[admin]

Thank so much for TDL. When will be the long term demo version will be available? Whether this TDL (Tally Connector V5) will expire on 13.5.2025? What is option for Paid longer term version of BASIC Tally connector TDL?

Link to purchase the paid version of TDL


https://docs.google.com/forms/d/e/1FAIp ... g/viewform

[meetamitesh]

the link provided by you for downloading Beta Trial V5 Tally connector - is broken - UNABLE TO DOWNLOAD
https://workdrive.zohopublic.in/externa ... ef68c07a96