How To Integrate Your Tally Data With Database?

The dynamic nature of ODBC means that changes are automatically updated.

Not all Tally users are familiar with setting up ODBC connections and engaging an expert to set this up and normalize data exchange does help.

Specify data from external data sources and select the new database queries after which you choose the data source.

Switch to excel and you can view all the selected columns.

If a purchase bill is entered it enhances the inventory level and when a sales bill is issued the quantity is deducted from the inventory.

Then there are times when an external inventory package may be the first point of data collection such as through barcode scanners for incoming inventory.