Export/Import

86771

• The title of the form in export screen was being displayed as Voucher Printing, resolved: When a voucher was exported in alteration mode from Day Book, title of the form in the Export Report screen was being displayed as Voucher Printing.

  Now, while exporting a voucher/report the title of the export screen will appear as Exporting Vouchers/Reports, respectively.

73739

• The file exported from E-Mail IDs report contained all the ledgers, when only one group was selected for export, resolved: In the E-Mail IDs screen in Exception Report, if group filter is applied using F4: Group option and then exported, the output files contained all the ledgers instead of only the selected group.

  Now, when the list of ledgers in the E-Mail IDs screen are filtered and exported, the output file will display only the filtered list, and not the entire list of ledgers.

51168

• An MAV error was being displayed while importing masters from an .sdf file after loading SDFExportImport.tdl, resolved: The error message "Import object" could not find description was being displayed while exporting and importing masters after configuring SDFExportImport.tdl. This occurred when masters contained Tariff as one of the attributes.

  This functionality has now been integrated into the application, and tdl configuration has been done away with.

82450, 88308, 67476

• Information was being captured twice in the exported excel file of Group of Accounts report, resolved: When the options Show Cost Centre Details also, Show Inventory Details also, and Show Bank Details also were enabled in the Group of Accounts, respective information was being captured twice in the exported excel file.

  Now, related information is not captured twice when the report is exported in the Excel format.

62707

• When Ledgers of All Accounts were exported to Excel, the exported file was appearing incorrectly aligned, resolved: When Ledgers of All Accounts were exported to Excel with the option Show Billwise Details also set to Yes, the columns in the exported file were not aligned correctly.

Go to Gateway of Tally > Multi Account Printing > Accounts Books > Ledger > All Accounts and click E: Export to export the file to Excel.

Now, the Vch Type, Vch No., Debit, and Credit column are aligned correctly.

49203

• When exporting POS invoice to excel format, the sheet name was being displayed as POS Invoice Print, resolved: When exporting POS invoice to excel format, the sheet name in the output file was being displayed as POS Invoice Print when Default Print Title field in Voucher Type was blank.

  Now, if the Default Print Title field in Voucher Type is blank, the title will be printed as POS INVOICE.

52827

• In Windows XP, error message was displayed while exporting a report with logo to HTML format, resolved: In Windows XP, while exporting a report with logo to HTML format, the error message “Attempting to open” was being displayed.

  Now, the report with logo can be exported to HTML format.

67514

• Reports exported in JPEG or PDF format were not opening automatically in Windows XP, resolved: In Windows XP, when any report/voucher was exported in JPEG or PDF format with the option Open Exported File set to Yes, the file was not opening automatically after exporting.

  Now, exported files will automatically open in Windows XP when the option Open Exported File is enabled during export.

69454

• Date was being displayed twice when Note Summary was exported to PDF or Excel, resolved: When the Fixed Asset group details were exported from the Note Summary in PDF or Excel format, the date information was appearing twice in the output file. Similar issue was observed while printing the report.

  Now, the date stamp displayed in the centre below the title will be removed, and it will only appear in the top right corner.

61297

• Voucher header was appearing repeatedly in exported XML file, resolved: While exporting voucher from Multi Account Printing in xml format, the voucher header was repeated in out file.

  Now, voucher header will appear once in the xml file when exported from Multi Account Printing.

47577

• Date and Particulars column details were overlapping when Ledger Vouchers report for purchase ledger was exported to Excel, resolved: When Ledger Vouchers report for a purchase ledger is exported to excel, the name of items was being displayed in Date column instead of Particulars column. This occurred when the format is set to Detailed and Show Inventory Details also is set to Yes in the Export Report screen.

  Now, exporting of a report in excel by enabling Show Inventory Details also will not result in overlap of information in the output file.

47942

• When exporting Day Book to .pdf or .jpeg format, columns were overlapping, resolved: Now, exporting of reports such as Day Book in .pdf or .jpeg formats will not affect the formatting of the out file and there will be no overlap of columns.

42330

• Columns were not aligned properly when Day Book was exported to .pdf or .jpeg format, resolved: When the Day Book was exported to .pdf or .jpeg formats the output file was not aligned properly. This occurred when the option Show Narrations also and Show Entered/Altered By are set to Yes in the Export Report screen.

63531

• Effective Date was being changed to voucher date in imported excise invoice, resolved: When excise invoice with effective date and voucher date is imported, the effective date recorded in the transaction was replaced by voucher date.

  Now, dates recorded in the excise voucher will be retained after importing.

56793

• The issue of the Vertical Balance Sheet displaying inconsistent borders when exported in Excel format, resolved.

55945

• The screen was going blank while exporting masters in SDF Format, resolved: After downloading and configuring SDF Format TCP from Download Centre, the SDF format is available for selection in the Format field of export configuration screen. Then, when the masters are exported selecting the SDF format, the screen was going blank.

  Now, the masters can be exported to SDF format, and the screen retains the content.

50068

• Incorrect information was displayed in the log created while importing/exporting masters by combining opening balance, resolved: The log displayed all masters as combined when Combine Opening Balances is selected while importing. The information of masters that are created and altered without combining opening balances was not updated in the log file.

  Now, the import function will update the log file with correct information.

79272

• Improper alignment of ledger narrations in reports exported to Excel: The ledger level narrations appeared incorrectly aligned in the excel file when a report was exported by enabling the option Show Narrations also.

  When a report was exported to excel by enabling the option Show Narrations also (in Export Report screen), the narrations in the transaction were displayed in the Particulars column and were aligned to left. However, if the option Narrations for each entry was enabled for the voucher type, then ledger level narrations for that specific voucher type appeared to be aligned to right in the exported Excel.

60797

• Improper alignment of Bank Reconciliation Statement when exported, resolved: When the Bank Reconciliation Statement was exported by enabling the option Show Narration also the details in the output file were not aligned properly.

  When the option Show Narrations also was enabled in the Export Report screen for Bank Reconciliation statement the narration in the vouchers should be displayed in the Particulars column, but the narration was displayed in the voucher type column. This has been resolved.

69422

• The issue of Party’s Name not being displayed in the exported Excel file of Job Work Out Order Outstanding report, resolved: You can now view the Party’s Name details in the exported Excel file of the Order Outstanding report for Job Work Out Reports. This issue has been resolved by adding details of the party to Order Outstanding report for Job Work Out Reports when exported in Excel format.

  To generate Job Work Orders Outstanding report for all items:

  • Go to Gateway of Tally > Display > Job Work Out Reports > Order Outstanding > Orders

  • Drill down from the item

  • Press F6: Item and select All Items

  • Then export in Excel format

  The resulting output file displays Party’s Name column, which allows the user to identify the party with outstanding orders.

43043

• The option Export for Pivot Table has been provided in the Exporting Summary screen: You can now get despatch details while exporting Sales Register in Excel (Spreadsheet) format.

78934

• Exporting Group Outstanding report with contact details to excel format: The issue of contact details not displaying when outstanding report for sundry debtors group is exported to excel is resolved.

  When you export Outstanding Report for Sundry Debtors group (under Multi Account Printing) in Excel format. The contact details are not displayed in the exported excel file even when the option Show Contact Details is enabled in the Export Report screen. This issue has been resolved to display contact details – name of contact person and telephone number in separate columns for each debtor in the excel file.

54418

• If an error occurred while importing an xml file, the error message was not appearing, resolved : During importing of an xml file, if the xml structure in the file was not correct, then the import was not happening. No error message appeared when the import failed.

  Now, if the import fails, error message is displayed.

98119

• An MAV error was being displayed while exporting data to Microsoft Excel, resolved: While exporting a report with more lines than the number of rows in the Excel sheet, an MAV error was being displayed.

  Now, the export program will close after updating the number of lines in the Excel sheet.

52145 

• Unable to copy item from one company to another by changing the company master in the item alteration screen, resolved: When an item master is opened in alteration mode and saved in another company by switching the company master using F3: Company button, an error “Stock Item ‘ ‘ already exists!” was being displayed. This occurred when standard rates was enabled and configured for the item.

See also: