Exporting Data to Excel

                                                            

The best approach to work with Export in Accpac is by entering a sample transaction directly via the user interface (UI) and then exporting it using Accpac Export in the format you require, such as Excel or CSV or ODBC. The exported file can then be used to prepare your data for import.

Data can be exported for all the masters, setups.

To Export the data from Accpac go to the required screen and following path:

File optionsà Export

Once clicked on Export, it will open a new screen where the user has to select the type of file format in which data should be exported.

Also select the File Location path where the exported file will be saved. Once the path is selected, it displays the various detail sheets that will be exported.

There are several features available while exporting the data as mentioned below:

Ø  The user can export only required columns in the sheet by selecting them. This would help to reduce the file size.

Ø  There is a Set Criteria feature, where the user can set the various criteria’s for export

For Ex, If the user wants to export only some specific data from the system say, if there are Stock and non stock items imported in the system but if it is required to export only the stock item, then click Set criteria, select stock item column from columns dropdown, click on Add, it will be added in the field criteria column, click on the first cell, a dropdown will appear, select Yes from dropdown, click Ok and export. This would export only the stock items in the sheet.

The same procedure applies for other column criteria.

Ø  There is a Save Script option which allows saving the Set criteria script at a specific location, so that the next time when the user wants to export the sheet with the same set criteria, the script can be loaded from the path where it was saved using the Load Script button.

Indian ERP vs Global ERP

What is the basic difference between an Indian ERP and a global ERP?

It is a misnomer that there exists these two different kinds of ERP's. The difference criteria can be a "local" ERP or a "multinational" ERP. The difference criteria can also be of whether it is an Indian company who is making this ERP exclusively for Indian market or a international brand which is setting up a local office and selling their "international" ERP in India.

An Indian ERP can be a "global" ERP as proved by a number of homegrown systems like Ramco while a international recognized brands like SAP, Sage and Microsoft can easily merge themselves into a Indian localization and cater to the system depending on their depth of localization. BUT all these systems are "global" ERP because at any time they can also cater to any other international client with minimum of fuss. In Indian context, the Indian ERP is usually a small home grown system with a few functionalities resembling an ERP system with bits and pieces of Accounting, Operations etc which is touted as an ERP system. They are usually much cheaper than their global counterparts and that is what makes them attractive to the end user. But is an investment worth it? The global brands have usually tried and tested the system worldwide in thousands of industries worldwise and they are carrying this experience to build up a system which will work for thousand and oneth customer too. It is a gradual process of value addition like in any industry but this is usually overlooked by the Indian buyers who just look at the price tag, the name of the company or their sales pitch which includes "an Indian product will be better for Indian industry".

The key advantages of any Global systems are:

- Used worldwide in different industry and hence usually has the best practices built in the system

- Bugs and issues are immediately fixed because it affects so many organizations worldwide and it is not meant to be fixed for a single customer.

- Implementation time is if the service provider is good as the system need not be customized

- GAAP priciples and best practices are followed

- In the long run, the ROI of the system is totally recouped because of lesser bugs in the system and lesser customization.

- Very less chance of the software vendor to be fold up and leave you in a lurch.

- Finally, most of the global system have been localized to meet your taxes and other aspects (at least Sage Accpac ERP can claim to be totally India compatible) and they are doing the localization in a much better way because of the inherent strength of development tools.


The key thing here is to select the right system provider who provides you with the correct solution rather than looking for the local vs global debate. Select any global brand but select your system provider carefully who has the experience in the market to develop and implement it.

If you have further query, do not hesitate to send an email at sales@greytrix.com for further discussion regarding why is a particular system much better for your industry need and how would it make more logical chocie to select a global system.