Import From Excel or SQL Database

Accountsoft Import From Excel or SQL Database

Introducing Accountsoft Import From Excel or SQL Database, a powerful AutoCount Plugin designed to streamline the data migration process with unparalleled efficiency and flexibility. Whether you're transitioning from legacy systems or integrating diverse database structures, this indispensable tool simplifies the task, saving you valuable time and resources.

Our Import From Excel or SQL Database plugin is meticulously crafted to replace tedious manual data entry, offering a seamless and error-free migration experience. With its comprehensive support for various transaction types, including A/R and A/P invoices, credit notes, payments, refunds, and sales transactions, it empowers users to effortlessly transfer critical data into AutoCount.

One of the standout features of Accountsoft's Import From Excel or SQL Database is its robust functionality for value conversion prior to import. This empowers users to customize and optimize data according to their specific requirements, ensuring smooth integration with AutoCount's data structures.

Furthermore, our plugin offers advanced mapping capabilities, enabling seamless alignment of data fields between source databases and AutoCount. With intuitive preview functionality, users can confidently review import results before finalizing the process, ensuring accuracy and consistency throughout.

Accountsoft's Import From Excel or SQL Database supports a wide range of file formats, including Excel (.xls, .xlsx) and CSV, as well as direct SQL database imports. This versatility allows for effortless data extraction and import from various sources, facilitating a smooth transition to AutoCount.

Moreover, our plugin simplifies the creation of multiple new debtors and facilitates batch conversions with just a single click, enhancing efficiency and productivity.

Experience the power of streamlined data migration with Accountsoft's Import From Excel or SQL Database plugin, your trusted partner for seamless integration and unparalleled convenience. Unlock new possibilities for data management and take your AutoCount experience to new heights.

Why Accountsoft Import From Excel or SQL Database?

Seamless Migration: Effortlessly transition from legacy systems to AutoCount with our intuitive plugin, eliminating the need for manual data entry and ensuring a smooth migration process.

Comprehensive Transaction Support: With support for a wide range of transaction types including A/R and A/P invoices, credit notes, payments, refunds, and sales transactions, our plugin covers all your data migration needs.

Advanced Value Conversion: Customize and optimize data before import with powerful value conversion capabilities, allowing you to tailor data to fit AutoCount's requirements and ensure accuracy.

Intuitive Mapping: Easily align data fields between source databases and AutoCount using our intuitive mapping functionality, ensuring seamless integration and consistent data formatting.

Preview Functionality: Review import results before finalizing the process with intuitive preview functionality, giving you confidence in the accuracy and integrity of your data.

Versatile File Format Support: Import data from a variety of file formats including Excel (.xls, .xlsx) and CSV, as well as direct SQL database imports, providing flexibility and convenience.

Efficient Batch Operations: Simplify the creation of multiple new debtors and perform batch conversions with just a single click, enhancing efficiency and productivity.

Enhanced Data Management: Experience the power of streamlined data migration with Accountsoft's Import From Excel or SQL Database plugin. Unlock new possibilities for data management and take your AutoCount experience to new heights.

Release2.18 (10/08/2020)
- Knock Off Date set to DateTime.Now.Date if Knock Off Date is earlier than Knock Off Invoice's Date (Reason: Error: unable to import RV earlier than inv date)

Release 2.19 (12/08/2020)
- Add SubTotal into SACN
- When Import SACN, if SubTotal is not blank then Get Unit Price & Qty to calculate SubTotal, else Get Qty and SubTotal to calculate UnitPrice 

Release 2.20 (24/03/2021)
- Add Import Sales Order (Only for Excel)
- Allow to add UDF & UDFDTL