Exporting Stock Item’s Part Number to Excel through ODBC
With Open Database Connectivity (ODBC) you can dynamically exchange data between Tally.ERP 9 and any other application dynamically. Using the ODBC feature, you can transfer data from Tally.ERP 9 to Microsoft Word or Excel. Currently, while extracting Stock Item details from Tally.ERP 9 to Excel, the Part Number specified in the respective item is not being fetched through ODBC.
ALTERNATE SOLUTION/WORKAROUND
Create the required excel through ODBC and insert a new column manually as StockItem.`$MailingName’. Then in Tally.ERP 9, go to Stock Summary, and in F12: Configuration, for the option “Appearance of Stock Item Names” select the appearance type – Name (Part No). After this configuration goes to List of Accounts, the report displays the item name with the part number. From List of Accounts, Export the stock item details to Excel. The Exported Stock Details will contain the Part Number along with other details. From this excel copy the data in the Part Number column and paste in StockItem.`$MailingName’
RESOLUTION TIMELINES
Resolution for the above-stated problem will be provided in Tally.ERP 9 Series B JAS (July, August, September) Release.