With Open Database Connectivity (ODBC) you can dynamically exchange data between Tally.ERP 9 and any other application dynamically. Using 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.
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 go to List of Accounts, 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 Part Number column and paste in StockItem.`$MailingName’
Resolution for the above stated problem will be provided in Tally.ERP 9 Series B JAS (July, August, September) Release.
RK Solutions is an authorized solution provider of Tally Solutions Pvt. Ltd. for its various products & services Located at Chennai, India, the company has been providing scalable, reliable, and highly efficient solutions to clientele across the World.
RK Solutions is an authorized associate partner of Tally Solutions Pvt. Ltd. Located in Chennai, India, the company has been providing scalable, reliable and highly efficient tally customisation to clientele across the World.