Tally Connector Community V 6

[admin]

Please login to download the TDL File



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

[sarathaca]

Thank you sir.

[coolyash]

Dear Sir,

Your TDLs have been very helpful to me and many others in the CA community. I really appreciate the hard work you have put in developing them.

I am very interested in learning how to create TDLs like these. Can you guide me on where to start with?

Thank You.

[walimbe.swanand]

Thank you sir for this wonderful TDL.
I am encountering following error while showing the DayBook Report
Data of `$Party_LedName`, `$Vch_GSTIN`, `$Led_Parent`,`$Led_GSTIN`, etc is showing as Demo
Attaching the image for your ready reference: https://drive.google.com/file/d/16zU4ms ... drive_link

[mchopda]

I am having the same issue.

[umangthakkerca]

i have loaded this tdl today in tally prime 6 version but it showing expired in status column. also kindly share some description about this TDL. is this TDL help to export day books and other leder master with balance through ODBC in excel?

[admin]

Thank you sir for this wonderful TDL.
I am encountering following error while showing the DayBook Report
Data of `$Party_LedName`, `$Vch_GSTIN`, `$Led_Parent`,`$Led_GSTIN`, etc is showing as Demo
Attaching the image for your ready reference: https://drive.google.com/file/d/16zU4ms ... drive_link

Sir that demo means its blocked by the developer as a paid version

[037403]

I have down loaded CA TDL Community V 19.04.tcp, on clicking this it asks "how do you want to open this", "look for an app in microsoft store". please help me to download and attach to tally this TDL. i have seen demo yesterday in one webinar. it gives excellent features.

[037403]

Thanks I could do it with the help of AI

[ksraoca]

Dear Sir, How to download the addon file