Import enquiry

[bws-vishnu]

Is this will import all data from tally, like sales order, purchase ledger etc?

[bws-vishnu]

Are you importing all table data from the tally table or only importing some part of data?

[dhananjay1405]

I will say, I am importing majority of the tables (a.k.a Collections in TDL terminology) say around 12-13 from Tally raw level data and included crucial fields (you can say around 100+) using which you could prepare many MIS reports. Sales Order, Purchase Ledger, etc are in-built reports of the Tally. So, do not expect separate table for each report. The data you mentioned is there in the database scattered across multiple tables. You need Power Query, SQL Query, or Excel formula / pivot to formulate logic to transform the raw level data into processed report.

Kindly check out video series by name "Excel Dashboard" where I have explained in detail how data of Tally is arranged into multiple tables & how to prepare reports for it.

[bws-vishnu]

Hi, in the inventory table, I can see sales and purchase items with some number, but I can't find the exact inventory data, such as the closing stock. Can we perform closing stock operations using this?

[dhananjay1405]

Closing Stock you will find in mst_stock_item table with hard-coded value as on to date specified while exporting.