Do you have a list of ledger column which is useful for report and how can I add it to your readymade code?I also need columns for stock item. Thanks! Useful and working video, easy and quick to follow
Yes, in the GitHub project, you will find few more Power Query for the same. You need to copy paste that XML, and modify the column names step accordingly. Alternatively, I will suggest to check out Excel Dashboard series where all these things are readymade in the CSV files which you can import in Excel via Power Query
Unfortunately DayBook cannot be imported using this technique. You will have to use Tally to Database utility to generate CSV files and then import transaction files merging them via Power Query. You will find 2-3 videos demonstrating this on this RUclips channel
i am using tally education mode . when i am running any of the power query which contains a replace value command , the tally software shows a popup of an error and closes. Due to that error- the powerquery cannot connect further
This method has many limitations. For cost centre thing, you will have to wait for my series on Power Query based ETL of Tally data loaded into SQL Server
I am also currently exploring if Tally accepts any XML command to extract Sales Register. Tally's TDL documentation for XML reporting commands is vague, so I am able to grab very limited data from Tally. Will upload a video & power query of it, when I get a solution for this
Nope. Not supported via this method. You need to use Tally to Database utility, to generate CSV & calculate receivable / payable. Search for video series by name "Excel Dashboard" on this channel. You should get 5-6 videos where this is covered.
Let me clear some confusion. I never use ODBC in the videos. ODBC is totally different from XML. So kindly clarify if you are trying to use XML method demonstrated in this video or ODBC ?
Hi Sir, We have "1 Bill to & multiple Ship to Address" in our invoices, and we like to filter it by Ship to Address, do you have any TDL or any other way in Tally prime itself
Stock Items is like another table inside each row, unfortunately this technique suffer a lot many limitations. For that you will have to use my Tally to SQL Server approach, which support this. Keep an eye on the channel since few videos covering this scenario are in my upcoming list
sir, how can i get a particular expenses ledger transactions in a condensed format (i want as like it is displaying while entering into a p&l expenses ledger)
@@ExcelKida Sir, i'm having an expenses ledger, in that, one voucher entry has multiple credits and multiple debits. However, by navigating to Gateway of tally - Profit & Loss A/c - [That particular expense Ledger] - it will display the ledger in a condensed view in default - from that screen i can simple export that (as like it is displayed, instead of three dots in ledger column for vouchers having more debits and credits in your above video) into excel by using Alt+E. Now, i need to get the same by using power query
No, that's not possible as Power Query supports tabular data. Condensed view for multiple debit/credit is theoretically tree structure data, which Power Query does not supports (table inside a row of data)
@@ExcelKida Simply i want fetch only the party ledgers instead of all the ledgers used in every vouchers... i think i need modifications in the xml _body line of your code and in the part $$StringFindAndReplace:$FldLedger:'""':'""""'. Here i want to add only party ledger names instead of adding all other ledgers used in a voucher which belongs to primary group other than Sundry creditors, debtors and sub groups of these two
In Tally you can open multiple companies at a time & select any company. Then click add column & then select other branches company one by one. Tally will automatically merge figures
You can export Sundry Debtor balances via Trial Balance power query video I have shared. But for transactions of multiple ledgers, Power Query is not suitable. For that you need to use Tally to Database utility, which can export all transactions & then you can filter out this
I don't know if you can apply Group Voucher filter (since I am not using Tally internal reports, but a raw database access method). But you can pull complete vouchers with Debit / Credit, which already I am using in Tally to Database utility. But I will not recommend doing this directly via Excel to Tally via Power Query, as Power Query cannot handle clean-up of unreadable characters, which can break output. Plus your Excel has risk of getting out of memory in this method. So better I will recommend you to use Tally to Database method & then use Power BI to connect with that database, which I have already demonstrated in few videos.
@@ExcelKida sir, my ledger vouchers report has some issues. When there is no voucher number in vouchers, it automatically shows the ledger name in the voucher number column and shows the amount in the ledger column . I think when we delimited with a comma for the fields it is splitting in this way. Kindly suggest me a solution, sir.
Not via this Power Query method as it suffers terrible limitations. You will have to use Tally to SQL Server utility (video for those already on my channel)
This technique works only for single company. I have released another video which covers your requirement. Check the below link ruclips.net/video/cpfpCJPGSMA/видео.html
Excellent Thank you very much. I want to extract entire Daybook with debits and credit accounts . is that possible using power query. could you please guide me. Thanks
If you go through my latest video on preparing Ledger Voucher report of Tally in Power BI report, indirectly I am importing entire transactions (Day Book is limited thing I will say) using Power Query. In next few video, I will be demonstrating on possibilities with that data
It was a magic show with some light on how things are done at the back stage in nutshell. Magic is a art & every art requires hours of learning & practise. In short, you can expect few more videos on this, in future. Trailer is must for every movie, as it creates enthusiasm to watch movie to be released in future. Only limitation is, director is short of time, so movie will be shot in pieces like web series, episode by episode :)
Unfortunately this technique faced lot of downsides & limitations. You can give a try to the Tally to Database technique where I have demonstrated Sales Register export where I have arranged data in columnar format
Great video implemented every steps and it worked, but i want to add two more columns for group name and parent group. could you please help me regarding that.
Thanks for your sincere efforts. Was helpfull analyzing my Tally Prime Data. But when I import purchase vouchers, only basic invoice value (i.e. invoice value without GST, Discounts, round offs etc)gets into the excel sheet. Can you please fix this please?
That's not error, but a limitation by design. This method relies on Tabular data as output. So this works perfectly for voucher entries with single debit & credit. But when you have multiple debit/credit, it converts to nested row inside another row. In Excel, it is impossible to paste an entire table inside single cell. Tally does this by manually programming this scenario using TDL, which internally sets value of each cell & spans output in multiple rows for such scenario, which technically breaks table. Power Query works on Tabular output. Tally never uses Table concept of Excel but a traditional approach of writing value cell by cell.
You need to keep target company Active (i.e. selected in bold) in Tally. To keep scripting minimal, I didn't introduce specific company data import & instead kept it to default selected company
Hi, Superb idea. You have done a great job. I have One question. I tried this and working fine for all ledgers except for ledgers with character "&" in its name. How to sort this out for ledger name with these kind of special characters? Thanks in Advance.
Hi I am targeting sales ledger for importing all sales voucher but I am not able to get quantity coloumn can u pls guide me And also I need to import pending bills details Thanks in advance
Unfortunately this method can import only tabular format information. Item & Quantity wise breakup is sort of table inside a cell (tree type of data), which is un-supported. Pending bills report I will have to check if it can be easily imported or not
Tumcha video khup upayogi aahe, tumcha code pan chalalay, pan ek trass aahe ki tithun fakta ekach ledger cha data query madhe ye toy. Tya sathi sagla tally data fetch karnyasathi kase code lihayche te sangal tar khup chan hoil.
ह्या approach मधे फक्त एकच ledger येणार एका वेळी, multiple supported नाही, , multiple साठी Tally to Excel Dashboard video तुम्ही बघू शकता ज्यात तसे करता येते utility वापरुन
Hello sir, How are you. Sir I have one doubt Generally we have multiple branches will be maintained like 1000 1001 1002 like that and multiple ledger accounts. How can we get all the companies all the ledgers
That requires a really complex Power Query scripting. I remember doing this for a client where we had consolidated data of 97 branches using Power Query loop. There is no generic way of doing this, depends on case to case basis. Also in this loop scripting requires huge RAM like 24 to 32 GB
Possible reasons/solutions 1) Ensure that you enable Tally XML Server (set that option value to Both from dropdown) from Advance Features of Tally 2) This method does not use ODBC, as ODBC suffers 32/64 bit connectivity issue. It uses Power Query to connect using XML 3) In the previous video (Realtime linking of Tally with Excel), I have demonstrated how to enable XML capability of Tally, you can refer that as it is one time setting
@@ExcelKida sir I tried as per your video of balance sheet automation but it is showing empty table in power query. U r right about above error that it is because i am using connection through ODBC. But it is showing empty table as per XML linking method. I am clarifying some points here that I am using tally prime which is education version.
The Power Query approach works even in Tally Prime (I tested it recently). In educational version, XML server restricts many things (otherwise people might create a backdoor to use all functionalities), so yes educational version might be the main cause
@@ExcelKida okk...thanks a lot for help. One more thing I want to ask u that can we use tdl coding in power query to create and extract the reports directly in excel?? If it is possible then there are vast opportunity to get reports as required in excel.
Power Query approach I demonstrated is written in TDL (in XML format) only. Any TDL, which can prepare output in tabular format can be sent by Power Query to Tally to fetch CSV format data
Sir, i tried your TB extract - "trial-balance-for-period.pq" can the same be generated cost centre wise? Also, the ledger Cash can be generated cost centre wise?
No. Internally "Ledger" collection does not have any field which provides cost centre wise break-up of Balance. Also, Tally does not offer any report for such. This method/approach not possible. You will have to use Tally to Database utility, which contains transactions for cost centre. I am definitely going to plan a tutorial for that in future, since this is a common requirement
can i get the same results if i use it in power bi? also, is there a query to pull out a specific ledger i.e. Ledger of Dhananjay. would appreciate a revert :)
1) Yes you can pull it from Power BI too using Web Request HTTP POST method, by sending that XML in your Post request body 2) You can pull specific group of ledgers using TDL filters. You will have to carefully modify that XML & need to have some TDL knowledge. But I will not recommend this, as I am of opinion that let Google Sheet or Power BI handle filtering thing, so that we have a flexibility
Tally does not offer easy ways of automation. So overall I found, SQL query method to be most flexible. If you know how to play with SQL query, then you can design any report which you can think of. I personally use SQL in maximum of my clients scenario
Kindly email me this query. Unfortunately RUclips chat does not allows pasting of screenshot in comments section. I will reply you back with trick of where to add these fields in XML
You need to go to advance setting of Tally & enable XML Server feature of Tally (one time setting), I have demonstrated this in another video of Power Query (real-time linking of financials with Excel)
For VBA, you will get the required material on Tally official documentation of 3rd Party Integration PDF. I have not developed VBA Macros for this. Personally I don't advice using VBA, as it is outdated. Power Query is very efficient in this, as many times you need to do some transformation of data which comes from Tally, which is handy in Power Query
This error comes when you use old version of Tally ERP. Make sure you are using latest release of Tally ERP 9 (6.6.3 I think is latest). Tally Prime also supports this
Sure I will give it a try. I am still exploring TDL for giving columnar setting to a report, as these things are graphically visible easily while operating Tally, but a bit difficult to spot out in TDL report specification
Technically I am not pulling data from Ledger Voucher report of Tally (which has running balance field), but directly from Tally database fields. Running total is dynamically calculated by Tally & not available in raw level database. So, you will have to introduce this field manually into Excel output, by adding extra column at the end & putting formula of [adjacent top cell Closing Balance + Credit - Debit]. In short you need trial balance report also imported into Excel (which I have already demonstrated in another video), so that you can pick-up opening balance for these calculations.
yes sure, I will be drafting & uploading a detailed Power Query, which will expose many fields of Ledger, Group & Voucher table. Just keep an eye on that Power Query project
![Noob To Max With DRAGON REWORK In Blox Fruits [FULL MOVIE]](http://i.ytimg.com/vi/LnBMOinoOvA/mqdefault.jpg)
Thank you very much for this .. I've spent the last couple of months looking for this ...
Very nice Topic covered by you with unique method
Do you have a list of ledger column which is useful for report and how can I add it to your readymade code?I also need columns for stock item. Thanks! Useful and working video, easy and quick to follow
Yes, in the GitHub project, you will find few more Power Query for the same. You need to copy paste that XML, and modify the column names step accordingly.
Alternatively, I will suggest to check out Excel Dashboard series where all these things are readymade in the CSV files which you can import in Excel via Power Query
Thanks for the efforts! Can you tell me how to extract a daybook using power query
Unfortunately DayBook cannot be imported using this technique. You will have to use Tally to Database utility to generate CSV files and then import transaction files merging them via Power Query. You will find 2-3 videos demonstrating this on this RUclips channel
i am using tally education mode . when i am running any of the power query which contains a replace value command , the tally software shows a popup of an error and closes. Due to that error- the powerquery cannot connect further
Educational Mode not recommended
Hey Thank you for the video, it helped me alot. Can you also let us know how can we insert cost centre column as well. It will be of a great help
This method has many limitations. For cost centre thing, you will have to wait for my series on Power Query based ETL of Tally data loaded into SQL Server
do you have any program for importing invoice data from excel to tally
How many entry do you want import
Hi, Can we extract columnar sales report?
I am also currently exploring if Tally accepts any XML command to extract Sales Register. Tally's TDL documentation for XML reporting commands is vague, so I am able to grab very limited data from Tally. Will upload a video & power query of it, when I get a solution for this
Can we get bill receivable and bills payable for particular group, please help, in power query, your videos are very helpful
Nope. Not supported via this method. You need to use Tally to Database utility, to generate CSV & calculate receivable / payable. Search for video series by name "Excel Dashboard" on this channel. You should get 5-6 videos where this is covered.
thank for response, sale details alone is it possible to pull from day book instead receipt/payment
No not possible
Day Book is internally a tree-based report. Unfortunately, Excel supports only tabular reports
hello sir.. thanks for the video..but l use 2016 excel vertion ..l dont see the ODBC 9000 tally file n my excel(other sources) ..help please
You need to enable XML Server port from Tally for this.
@@ExcelKida it is enabled but the problem is this ..when you open excel to import it through a power query..it doesn't show the odbc file
Let me clear some confusion. I never use ODBC in the videos. ODBC is totally different from XML. So kindly clarify if you are trying to use XML method demonstrated in this video or ODBC ?
Hi Sir,
We have "1 Bill to & multiple Ship to Address" in our invoices, and we like to filter it by Ship to Address, do you have any TDL or any other way in Tally prime itself
In Tally Prime 4.0, you may be able to filter it, as it's filter is pretty much advanced.
Sir what would be the query to get billed qty value for all items
Stock Items is like another table inside each row, unfortunately this technique suffer a lot many limitations. For that you will have to use my Tally to SQL Server approach, which support this. Keep an eye on the channel since few videos covering this scenario are in my upcoming list
sir, how can i get a particular expenses ledger transactions in a condensed format (i want as like it is displaying while entering into a p&l expenses ledger)
???
Can you describe it a bit in detail ? Not getting what you are asking
@@ExcelKida Sir, i'm having an expenses ledger, in that, one voucher entry has multiple credits and multiple debits. However, by navigating to Gateway of tally - Profit & Loss A/c - [That particular expense Ledger] - it will display the ledger in a condensed view in default - from that screen i can simple export that (as like it is displayed, instead of three dots in ledger column for vouchers having more debits and credits in your above video) into excel by using Alt+E. Now, i need to get the same by using power query
No, that's not possible as Power Query supports tabular data. Condensed view for multiple debit/credit is theoretically tree structure data, which Power Query does not supports (table inside a row of data)
@@ExcelKida Simply i want fetch only the party ledgers instead of all the ledgers used in every vouchers... i think i need modifications in the xml _body line of your code and in the part $$StringFindAndReplace:$FldLedger:'""':'""""'. Here i want to add only party ledger names instead of adding all other ledgers used in a voucher which belongs to primary group other than Sundry creditors, debtors and sub groups of these two
sir, is there any possibilities to use $IsPartyLedger(if anything available like this) before set the ledger names?
Hello Sir,
Great video.
Sir, How can we get all vouchers for a specific group for e.g. Sundry Debtors ?
Exploration in progress
@@ExcelKida Awaiting for your video Sir
Hi brother
I need your help on the below
Group company having many division logins so i need to generate tb company wise ledger wise tTB
In Tally you can open multiple companies at a time & select any company. Then click add column & then select other branches company one by one. Tally will automatically merge figures
Can we export sundary debtors balance and last payment made by them of aal leaders
You can export Sundry Debtor balances via Trial Balance power query video I have shared. But for transactions of multiple ledgers, Power Query is not suitable. For that you need to use Tally to Database utility, which can export all transactions & then you can filter out this
Sir, can we get group vouchers through power query with multiple lines which contain debit and credit, instead of ledger vouchers?
I don't know if you can apply Group Voucher filter (since I am not using Tally internal reports, but a raw database access method). But you can pull complete vouchers with Debit / Credit, which already I am using in Tally to Database utility. But I will not recommend doing this directly via Excel to Tally via Power Query, as Power Query cannot handle clean-up of unreadable characters, which can break output. Plus your Excel has risk of getting out of memory in this method.
So better I will recommend you to use Tally to Database method & then use Power BI to connect with that database, which I have already demonstrated in few videos.
@@ExcelKida Sir, Thank you for your response.
Can we get multiple ledger filters at the same method?
@@ExcelKida sir, my ledger vouchers report has some issues. When there is no voucher number in vouchers, it automatically shows the ledger name in the voucher number column and shows the amount in the ledger column .
I think when we delimited with a comma for the fields it is splitting in this way.
Kindly suggest me a solution, sir.
Hello, thanks for sharing this information.
Can we get sales order voucher data ?
Only total amount, ledger name/group. ..Not item wise
Not via this Power Query method as it suffers terrible limitations. You will have to use Tally to SQL Server utility (video for those already on my channel)
Sir, I have Multiple Branch in tally, how to get company name in "Trial Balance (for the period)" report
This technique works only for single company. I have released another video which covers your requirement. Check the below link
ruclips.net/video/cpfpCJPGSMA/видео.html
@@ExcelKida Sir It Is Possible to Get Comapny name using XML Request
Yes, you can introduce one more column with value ##SvCurrentCompany which would fetch active company name
@@ExcelKida Thanks !
Excellent Thank you very much. I want to extract entire Daybook with debits and credit accounts . is that possible using power query. could you please guide me. Thanks
If you go through my latest video on preparing Ledger Voucher report of Tally in Power BI report, indirectly I am importing entire transactions (Day Book is limited thing I will say) using Power Query. In next few video, I will be demonstrating on possibilities with that data
@@ExcelKida Thank you so much. let me review
you are a magician, it works only for you
It was a magic show with some light on how things are done at the back stage in nutshell. Magic is a art & every art requires hours of learning & practise. In short, you can expect few more videos on this, in future. Trailer is must for every movie, as it creates enthusiasm to watch movie to be released in future. Only limitation is, director is short of time, so movie will be shot in pieces like web series, episode by episode :)
Hi Dhananjay appreciate your presentation and kudos to you for sharing the code.
I Small question i have how can we export columnar ledgers
Unfortunately this technique faced lot of downsides & limitations. You can give a try to the Tally to Database technique where I have demonstrated Sales Register export where I have arranged data in columnar format
Great video implemented every steps and it worked, but i want to add two more columns for group name and parent group. could you please help me regarding that.
For that you will have to import ledger-table.pq also in Power Query & then merge both
Thanks for your sincere efforts. Was helpfull analyzing my Tally Prime Data. But when I import purchase vouchers, only basic invoice value (i.e. invoice value without GST, Discounts, round offs etc)gets into the excel sheet. Can you please fix this please?
That's not error, but a limitation by design. This method relies on Tabular data as output. So this works perfectly for voucher entries with single debit & credit. But when you have multiple debit/credit, it converts to nested row inside another row. In Excel, it is impossible to paste an entire table inside single cell. Tally does this by manually programming this scenario using TDL, which internally sets value of each cell & spans output in multiple rows for such scenario, which technically breaks table. Power Query works on Tabular output. Tally never uses Table concept of Excel but a traditional approach of writing value cell by cell.
Hi
If more than one company is loaded in tally, how to specifically select ledger voucher from one particular company?
Thanks in advance.
You need to keep target company Active (i.e. selected in bold) in Tally. To keep scripting minimal, I didn't introduce specific company data import & instead kept it to default selected company
@@ExcelKida ok. Thanks.
Hi, Superb idea. You have done a great job.
I have One question. I tried this and working fine for all ledgers except for ledgers with character "&" in its name. How to sort this out for ledger name with these kind of special characters?
Thanks in Advance.
& = &
You can refer this link where they have given a chart special character
www.ibm.com/docs/en/was-liberty/base?topic=manually-xml-escape-characters
@@ExcelKida Thanks a lot.
Hi
I am targeting sales ledger for importing all sales voucher but I am not able to get quantity coloumn can u pls guide me
And also I need to import pending bills details
Thanks in advance
Unfortunately this method can import only tabular format information. Item & Quantity wise breakup is sort of table inside a cell (tree type of data), which is un-supported. Pending bills report I will have to check if it can be easily imported or not
@@ExcelKida we can export all sales as data for pivot table in the export command.
How can import different types of ledger like sales , purchase etc.
This method works on single ledger, not group of ledgers. So you will have to make repeat it for all ledgers under it
Hi , This is not working for me. In Voucher # , I get Amount and ledger and narration are blank
Share me the screenshot over my email ID (you will find at last of video), then only I can tell you what might be issue
@@ExcelKida Check Inbox
Emailed you back the (possible) resolution
I am facing same problem..please help
Tumcha video khup upayogi aahe, tumcha code pan chalalay, pan ek trass aahe ki tithun fakta ekach ledger cha data query madhe ye toy. Tya sathi sagla tally data fetch karnyasathi kase code lihayche te sangal tar khup chan hoil.
ह्या approach मधे फक्त एकच ledger येणार एका वेळी, multiple supported नाही, , multiple साठी Tally to Excel Dashboard video तुम्ही बघू शकता ज्यात तसे करता येते utility वापरुन
Dear sir all payment voucher import just like receipt payment report
Hello sir, How are you.
Sir I have one doubt
Generally we have multiple branches will be maintained like 1000 1001 1002 like that and multiple ledger accounts.
How can we get all the companies all the ledgers
That requires a really complex Power Query scripting. I remember doing this for a client where we had consolidated data of 97 branches using Power Query loop. There is no generic way of doing this, depends on case to case basis. Also in this loop scripting requires huge RAM like 24 to 32 GB
Thanks for the reply I spread this channel to my friends.
Please make any solution for purchase register columnar with hsn number, I tried but it's not done please
Yes sure
Sir Now this query is not working in my system, even previous query is showing error in brackets like < >
This issue comes because you are using Tally Prime version 2.0.1 which has a bug. Just downloaded Tally Prime to 2.0.0 by re-installing it
Hii I tried this but I got error that "IM002 : ODBC DRIVER MANAGER : driver not found" do u hve solution???
Possible reasons/solutions
1) Ensure that you enable Tally XML Server (set that option value to Both from dropdown) from Advance Features of Tally
2) This method does not use ODBC, as ODBC suffers 32/64 bit connectivity issue. It uses Power Query to connect using XML
3) In the previous video (Realtime linking of Tally with Excel), I have demonstrated how to enable XML capability of Tally, you can refer that as it is one time setting
@@ExcelKida sir I tried as per your video of balance sheet automation but it is showing empty table in power query. U r right about above error that it is because i am using connection through ODBC.
But it is showing empty table as per XML linking method.
I am clarifying some points here that I am using tally prime which is education version.
The Power Query approach works even in Tally Prime (I tested it recently). In educational version, XML server restricts many things (otherwise people might create a backdoor to use all functionalities), so yes educational version might be the main cause
@@ExcelKida okk...thanks a lot for help.
One more thing I want to ask u that can we use tdl coding in power query to create and extract the reports directly in excel?? If it is possible then there are vast opportunity to get reports as required in excel.
Power Query approach I demonstrated is written in TDL (in XML format) only. Any TDL, which can prepare output in tabular format can be sent by Power Query to Tally to fetch CSV format data
Hi, please could you also guide on extracting sales and purchase register.
Purchase Register contains dynamic columns, this method does not support extracting dynamic data
Sir, i tried your TB extract - "trial-balance-for-period.pq" can the same be generated cost centre wise? Also, the ledger Cash can be generated cost centre wise?
No. Internally "Ledger" collection does not have any field which provides cost centre wise break-up of Balance. Also, Tally does not offer any report for such. This method/approach not possible. You will have to use Tally to Database utility, which contains transactions for cost centre. I am definitely going to plan a tutorial for that in future, since this is a common requirement
Sir cost centre information bhi hamre liye bahut jaruri hei please help
Not possible directly by this method. You need to use Tally to Database utility, and then pull data into Excel for that applying PIVOT tables
Can we get Cost Centre in this?
Yes, but not supported in this realtime method.
For cost centre data, you need to use Tally to Database Server method
How to import group vouchers instead of ledger vouchers
For that, you need to go via Tally to SQL Server utility, which import all the vouchers & then you can filter out specific vouchers
can i get the same results if i use it in power bi?
also, is there a query to pull out a specific ledger i.e. Ledger of Dhananjay.
would appreciate a revert :)
1) Yes you can pull it from Power BI too using Web Request HTTP POST method, by sending that XML in your Post request body
2) You can pull specific group of ledgers using TDL filters. You will have to carefully modify that XML & need to have some TDL knowledge. But I will not recommend this, as I am of opinion that let Google Sheet or Power BI handle filtering thing, so that we have a flexibility
@@ExcelKida is there a way which isnt as complicated through sql?
Tally does not offer easy ways of automation. So overall I found, SQL query method to be most flexible. If you know how to play with SQL query, then you can design any report which you can think of. I personally use SQL in maximum of my clients scenario
sir, informative video, pl be a little slow in explanation, not able to follow as power query is new..
Noted
nice..but this is missing an important field "voucher Number"...how to include that also..???
Kindly email me this query. Unfortunately RUclips chat does not allows pasting of screenshot in comments section. I will reply you back with trick of where to add these fields in XML
Sir I I'll try many time but entry didn't show
Ensure you unblock Tally XML Server access, it might be the reason
@@ExcelKida how to resolve this error localhost.9000
You need to go to advance setting of Tally & enable XML Server feature of Tally (one time setting), I have demonstrated this in another video of Power Query (real-time linking of financials with Excel)
Sir how can we import tally all ledger using vba ,creating a specific button for 'import ledgers from tally ' in Excel please make a video on this sir
For VBA, you will get the required material on Tally official documentation of 3rd Party Integration PDF. I have not developed VBA Macros for this. Personally I don't advice using VBA, as it is outdated. Power Query is very efficient in this, as many times you need to do some transformation of data which comes from Tally, which is handy in Power Query
Good job bro
Is there anything like this for SAP?
I never had any chance to work on SAP, as all my clients mostly used Tally. So no idea about SAP
Me getting Error! In tally
'Function:stringfind and replace
Could not fine description
Plz help
This error comes when you use old version of Tally ERP. Make sure you are using latest release of Tally ERP 9 (6.6.3 I think is latest). Tally Prime also supports this
Thank you we have older version will try to update
Please Share the Power Query for Extract specific Tally Ledgers in Columnar report Format
Sure I will give it a try. I am still exploring TDL for giving columnar setting to a report, as these things are graphically visible easily while operating Tally, but a bit difficult to spot out in TDL report specification
Thanks of Lot for your Valuable supports and prompt replay
Sir ledger ka running balance bhi kaise dikhayi dega in real time... Please help.... Btw love your videos
Technically I am not pulling data from Ledger Voucher report of Tally (which has running balance field), but directly from Tally database fields. Running total is dynamically calculated by Tally & not available in raw level database. So, you will have to introduce this field manually into Excel output, by adding extra column at the end & putting formula of [adjacent top cell Closing Balance + Credit - Debit]. In short you need trial balance report also imported into Excel (which I have already demonstrated in another video), so that you can pick-up opening balance for these calculations.
तुम्ही कुठल्या शहरात राहता?
नागपुर
please add the vch no and Ref no
yes sure, I will be drafting & uploading a detailed Power Query, which will expose many fields of Ledger, Group & Voucher table. Just keep an eye on that Power Query project
@@ExcelKida thanks bro
Waiting for your next video
Thank you
how to get all transaction of all ledger with date?
That is not possible directly through this approach. I will be shortly coming with Power BI tutorial for this