UPLOAD OR EXPORT DATA USING EXCEL IN ACUMATICA

Acumatica provides users with a simple way to upload data to quickly create transactions. It may be a Journal Transaction, Lines on a Sales Order or Purchase Order, or Price Worksheet , where you can easily upload data from excel.

Anywhere you see this button,       you can upload data from Excel.

Just like creating this transaction manually, you can apply settings like transaction date and description. When you click on the Load Records From File button you can browse for the file (it can be .xlsx or .csv).

After clicking UPLOAD, it will confirm the Common Settings and allow for you to map the fields. Columns to the left are from your file. The file on the right can be set to where it should upload.

 

After clicking OK it will upload the data. You can then make any corrections or changes as needed. It’s that simple! Then, you can treat the transaction as if you manually entered it and save a release.

Similarly, whenever you see the Excel button , you can export the data out to Excel.

Acumatica makes it very feasible to upload and export data to Excel. These feature makes data easily accessible and available to your employees in a quick way. Do you need more help using Acumatica? We have a Tips and Tricks page for answers to common Acumatica troubleshooting. If you are interested in one-on-one support, please visit our Support page or shoot us an email at satkins@4acc.com!


Solutions by Industry

What's New

Private versus Public Cloud

The term “cloud” has become common in the ERP world. Migration or moving to the cloud is becoming more popular as technology evolves. While your data can be moved to the cloud, there are different ways that data can be stored: public or private. Below are the differences between public and private cloud hosting environments. Read More

Submitted by Ally Donahue on Fri, 04/02/21 - 1:46

Your Brain on ERP

Just as your body needs your brain and central nervous system, your business needs an integrated ERP system. Read More

Submitted by Ally Donahue on Fri, 03/26/21 - 1:40

Benefits of Ongoing Staff Software Training

After ERP implementation, employees who will use the technology are trained on how to use the new software. However, software systems are constantly improving and updating which can cause employees confusion while working in the system. By hosting ongoing staff software training, your staff will feel confident and prepared to do their job effectively and be well versed in the updated technology.  Read More

Submitted by Ally Donahue on Fri, 03/19/21 - 1:44

Whatever Your ERP Needs, We Have the Solution!

Or call us for a free consultation 866-379-3799