Enable your users to import data from an Excel spreadsheet into Macola
The Macola-Excel Import Utility tool by Harvest Ventures is a tool to import master data such as sales orders, purchase orders, items, customers and vendors from an Excel spreadsheet directly into the Macola or Progression database. This utility is available for purchase in full or based on specific data import requirements.
Features
Schedule orders to be copied from databases or from live orders
Import orders from websites with any kind of format
Load items from old companies or replace old item numbers
Flexible database options
Able to input the source database and the destination database
Automatically runs multiple routines
Users can run multiple import routines automatically, one after another
Input and Output can be any format
The dynamic mapping tool included with this utility enables the source and output files to be specified
Execute queries for Excel
Allows users to execute a query from a selected database to generate an Excel file that can then be import into Macola
The Intercompany Sales Order tool eliminates duplicate entries when you have two companies. This tool makes it so that users can seamlessly copy purchases and sales orders from the parent company into another company.
Harvest Ventures’ EFT (Electronic Funds Transfer) utility provides Macola users with the functionality to create EFT export files for any bank or currency.
Improve consistency and eliminate manual unit conversion. The additional information is stored in the Item Master and displays in various views and reports throughout Macola.
This tool is designed to speed up your entry of Accounts Payable (AP) vouchers clearing multiple Purchase Order (PO) receipts on a single screen. It streamlines your business by reducing manual AP vouchers.
