Transcription

Export Data of Vouchers in Excel Pivot Table-1.0Alpha Automation Pvt. Ltd.Head Office104-The Grand Apurva, Nr. Hotel Fortune Palace,Nr. Digjam Circle, Airport Road - JAMNAGAR –Gujarat (India)Phone No. : 91-288-2713956/57/58, 9023726215/16, 9099908115, 9825036442Email: [email protected] OfficeRajkot: 807-Dhanrajni Complex, Nr. Hotel Imperial Palace, Dr. YagnikRoad, RAJKOT (Gujarat).Gandhidham: 92-GMA Building, 2nd Floor, Plot No. -297, Sector-12B.GANDHIDHAM (Gujarat)Export Data of Vouchers in Excel Pivot Table-1.0Page 1

2020 Alpha Automation Pvt. Ltd. All rights reserved.Tally, Tally 9, Tally9, Tally.ERP, Tally.ERP 9, Shoper, Shoper 9, Shoper POS, Shoper HO, Shoper 9POS, Shoper 9 HO, Tally Developer, Tally. Server 9, Tally Developer, Tally. Developer 9, Tally.NET,Tally Development Environment, Tally Prime, TallyPrimeDeveloper, Tally Prime Server, TallyExtender, Tally Integrator, Tally Integrated Network, Tally Service Partner, Tally Academy & Power ofSimplicity are either registered trademarks or trademarks of Tally Solutions Pvt. Ltd. in India and/orother countries. All other trademarks are properties of their respective owners.Version: Alpha Automation Pvt. Ltd. /Export Data of Vouchers in Excel Pivot Table/1.0/ March-2021Export Data of Vouchers in Excel Pivot Table-1.0Page 2

Export Data of Vouchers in Excel Pivot Table-1.0Introduction By Default in Tally, User can Export Data of only Sales and PurchaseVouchers in Excel Pivot table. This Add-on allows user to Export Data of SalesOrders & Purchase Order, Debit Note & Credit Note in Excel Pivot Table.Benefits User Gets all Data of Vouchers and Relevant Masters in Pivot Table in ExcelColumns. It is very useful for further Analysis, Generation of MIS Reports andExport to any other Software for further processing.What’s New? Compatible with TallyPrimeImportant!Take back up of your company data before activating the Add-on.Once you try/purchase an Add-on, follow the steps below to configure the Add-on and useit.Installation1.Copy the TCP file in TallyPrime Folder.2.Gateway of Tally F1 (Help) TDL & Add-on F4 (Manage Local TDL) SelectYes in Load TDL on Startup and give the file name of TCP File. After pressing theEnter Key will show TDL Status which should be as Loaded.System requirements:No additional hardware / software infrastructure is required for executing and operationthis applications moduleExport Data of Vouchers in Excel Pivot Table-1.0Page 3

1. Activate the Add-on.For TallyPrime Release 1.0Go to Gateway of Tally F1: Help TDL & Add-On F6: Add-On Features.Alternatively, you may press CTRL ALT T from any menu to open TDLManagement report and then press F6: Add-On FeaturesSet “Yes” to the options “Enable to Export Data of Vouchers in Excel PivotTable?"Export Data of Vouchers in Excel Pivot Table-1.0Page 4

Detailed User Guide:1. Go To Display Statements Of Accounts Statistics Sales Order :Export Data of Vouchers in Excel Pivot Table-1.0Page 5

2. Go To Export Configuration As Shown Below :Export Data of Vouchers in Excel Pivot Table-1.0Page 6

3. Export Sales Order Register As Shown Below :Note: Similarly Export Pivot Table in Purchase Order ,Credit Note and Debit Note.Export Data of Vouchers in Excel Pivot Table-1.0Page 7

FAQWhich version/release of TallyPrime does the add-on support?This add-on will work only from TallyPrime Release 1.0 onwards.How will I get support for this [email protected] or call us at 91-288-2713956/57/58, 91-9023726215/16,9099908115, 9825036442.If I need some enhancements / changes to be incorporated for the add-on, whomshould I contact?Please to write to us on [email protected] with your additional requirements andwe will revert to you in 24 hours.Will new features added be available to us?We offer one year availability of all support and new features free of cost. After one year,nominal subscription cost will be applicable to you to continue to get free support andupdates.What will happen after one year?There is no fixed annual charge to be payable mandatory. However if any changes arerequired in our Add-On to make compatible with New Release of TallyPrime then themodification Charges will be applied.I am using a multi-site. Can I use the same Add-on for all the sites?No, one Add-on will work only for 1 site. You need to purchase again if you want to use thesame Add-on for more sites.TDL Management screen shows errors with the Add-on. What do I do?Check whether the error is because of the Add-on or because of clashes between 2 TDLs(An add-on is also a TDL). In case of clashes, disable one or more TDLs and check whichExport Data of Vouchers in Excel Pivot Table-1.0Page 8

TDL has the error. If the Add-on has a problem, you can report it to us.My Tally went into educational mode after installing the add-on. What do I do?Go into Gateway of Tally Press F1 (Help) TDL & Add-on Press F4 and removethe Add-on from the list and Restart Tally.Export Data of Vouchers in Excel Pivot Table-1.0Page 9

Vouchers in Excel Pivot table. This Add-on allows user to Export Data of Sales Orders & Purchase Order, Debit Note & Credit Note in Excel Pivot Table. Benefits User Gets all Data of Vouchers and Relevant Masters in Pivot Table in Excel Columns. It is very useful for further Analysis, Generation of MIS Reports and