Tally Connector V 2

[admin]

Issue indentified with GSTIN update in versions 3.0 and above .
Will shortly release a new build
- CA J Ramajayam


Please click to download the TDL and Sample Data File and Excel Workings



https://1drv.ms/f/s!Amio4TKO9rtzlrJVVRj ... w?e=goygJO



Query to get Ledger Master Data

Code: Select all

SELECT $Name, $_PrimaryGroup, $Parent, $OpeningBalance, $ClosingBalance, $_PrevYearBalance, $IsRevenue, $PartyGSTIN, $MasterId, $AlterID, $Nature_Led, $UpdatedDate, $UpdatedTime, $CreatedBy, $CreatedDate, $AlteredDate, $AlteredBy, $LastVoucherDate, $CompanyName, $Year_from, $Year_to, $Company_number, $Path FROM A__M_Ledger

Query to get the DayBook Data

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

Query to get the Stock Master Data

Code: Select all

SELECT $MasterId, $AlterID, $Name, $PartnoParent, $Category, $OpeningBalance, $ClosingBalance, $ClosingRate, $ClosingValue, $LastPurcCost, $LastPurcDate, $LastPurcParty, $LastPurcPrice, $LastPurcQty, $LastSaleDate, $LastSaleParty, $LastSaleQty, $LastVoucherDate, $EnteredBy, $GSTTypeofSupply, $CostingMethod, $ValuationMethod, $BaseUnits, $AdditionalUnits, $_HSNCode, $_IntegratedTax, $_CentralTax, $_StateTax, $_HSNDescription, $_InwardQuantity, $_InwardValue, $_OutwardQuantity, $_OutwardValue, $CompanyName, $Year_from, $Year_to, $Company_number, $Path
FROM A__M_Stock

Forensics Query

Code: Select all

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

Power Query - Query Method

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

Power Query - Data Source Method

Code: Select all

let
    Source = Odbc.DataSource("dsn=TallyODBC64_9000", [HierarchicalNavigation=true, SqlCapabilities=[LimitClauseKind=LimitClauseKind.Top]]),
    VenkateshwaraTraders_Database = Source{[Name="VenkateshwaraTraders",Kind="Database"]}[Data],
    TallyUser_Schema = VenkateshwaraTraders_Database{[Name="TallyUser",Kind="Schema"]}[Data],
    A__M_Ledger_Table = TallyUser_Schema{[Name="A__M_Ledger",Kind="Table"]}[Data]
in
    A__M_Ledger_Table

GIT Link

https://github.com/ramajayam-CA/TallyConnector-V2.0

[umangthakkerca]

sir how this utility(TDL) is to be used and what type of report it will generate. kindly guide.

[admin]

sir how this utility(TDL) is to be used and what type of report it will generate. kindly guide.

We will post a video on the same soon sir