I connected to Tally using the ODBC connector and successfully accessed the Group, Ledger, and Vouchers tables. However, I was unable to locate the Accounting table. Could you provide guidance on accessing it?
This is good. However, can you please tell if we can have a Sales voucher table in which amount and sales voucher alternate units total would be shown so we can create dashboard on it that how much sales we done in amount as well as in alternate units i.e. kgs in a particular period ?
For alternative unit, you can utilize table named mst_uom where you would find 3 fields, base_units, additional_units and conversion (multiplication factor between base vs additional unit). You need to setup a Power BI measure to multiple quantity in table trn_inventory with conversion multiplier to derive quantity in alternate units.
@kingpingamerzarena you are correct, I think I mixed two different concepts together. I will appreciate if you can email me any demo / sample data for altenate units of Tally. I will attempt to integrate it in the utility & release an updated version of utility covering this. You can email me on info@excelkida.com
What if we want to get all data as like columnar option in tally. I need to connect power query with Tally directly without using sql server. i want to customize power query code based on my requirement.
If you want to connect Power Query to Tally directly, then you need to have good hold of TDL, generation of XML of reports, M Query scripting. Also, if you get any unreadable character, then your Power Query would fail. So, I recommend that use this utility where all the drawbacks have been fixed after years of my trial-error.
Sir kindly make a video on sales and purchase columnar report to excel with power query b coz forabove 10000 entry tally takes too much time to export in excel
I have already uploaded Sales Register video for Google Sheet & Power BI. You need to check out videos on my channel. Power BI report you can export to Excel, which is very fast, hardly takes 2-3 seconds even for 1 Lakh rows
Can you please create a complete power bi multi page project on tally which will display complete analysis from profit and loss to credit and debit and everything
1) "complete" is pretty broad-ended & subjective word, with different people having varied requirement. 2) Motto behind these tutorials is to demonstrate a small portion of report with how to implement it. Video tends to become long if I try to cover many things in a single video. So I tend to split up videos. I will suggest to check out all the connected videos on my channel & you will start understanding the concepts a bit in depth. In the coming future I will be uploading more such videos, as and when I get time to produce videos.
I connected to Tally using the ODBC connector and successfully accessed the Group, Ledger, and Vouchers tables. However, I was unable to locate the Accounting table. Could you provide guidance on accessing it?
Bro how you connect it ? Odbc se voucher table nehi aata Hain
ODBC does not support vouchers. That's the reason I have used XML in the utility which supports vouchers too.
@@ExcelKida iss methord se tally ka live connection hoga kya?
Agar Tally me koi new entry hota he to refresh marne se Pwr Bi update hoga?
This is good. However, can you please tell if we can have a Sales voucher table in which amount and sales voucher alternate units total would be shown so we can create dashboard on it that how much sales we done in amount as well as in alternate units i.e. kgs in a particular period ?
For alternative unit, you can utilize table named mst_uom where you would find 3 fields, base_units, additional_units and conversion (multiplication factor between base vs additional unit). You need to setup a Power BI measure to multiple quantity in table trn_inventory with conversion multiplier to derive quantity in alternate units.
@@ExcelKida mst_uom doesn't showing additional_unit & conversion of each stock item instead it showing types of conversion factors opened in tally.
@kingpingamerzarena you are correct, I think I mixed two different concepts together. I will appreciate if you can email me any demo / sample data for altenate units of Tally. I will attempt to integrate it in the utility & release an updated version of utility covering this. You can email me on info@excelkida.com
What if we want to get all data as like columnar option in tally. I need to connect power query with Tally directly without using sql server. i want to customize power query code based on my requirement.
If you want to connect Power Query to Tally directly, then you need to have good hold of TDL, generation of XML of reports, M Query scripting. Also, if you get any unreadable character, then your Power Query would fail. So, I recommend that use this utility where all the drawbacks have been fixed after years of my trial-error.
Can you please give this sample data
That will be really helpful. Thanks
Download link of sample data there in the video description
Sir kindly make a video on sales and purchase columnar report to excel with power query b coz forabove 10000 entry tally takes too much time to export in excel
I have already uploaded Sales Register video for Google Sheet & Power BI. You need to check out videos on my channel. Power BI report you can export to Excel, which is very fast, hardly takes 2-3 seconds even for 1 Lakh rows
Can you please create a complete power bi multi page project on tally which will display complete analysis from profit and loss to credit and debit and everything
1) "complete" is pretty broad-ended & subjective word, with different people having varied requirement.
2) Motto behind these tutorials is to demonstrate a small portion of report with how to implement it. Video tends to become long if I try to cover many things in a single video. So I tend to split up videos.
I will suggest to check out all the connected videos on my channel & you will start understanding the concepts a bit in depth. In the coming future I will be uploading more such videos, as and when I get time to produce videos.
nice i will watch your daily but i am not able do on my laptop plz help me
Email me the issue you are facing