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

The 5 Most Common ERP Objections

Making the decision to upgrade from a basic accounting software to a robust ERP system can come with challenges. Not everyone will be on board or open to the idea of change. Throughout our years in practice, we have found the following common objections to adopting a new software.  Read More

Submitted by Ally Donahue on Fri, 01/22/21 - 11:33

ERP Hierarchy of Needs

Maslow's Hierarchy of Needs a psychological concept that people are willing to fulfill basic needs before pursuing higher level needs. This theory was created in 1943 by Abraham Maslow. The five levels, physiological, safety, connection, esteem, and self-actualization are all components of what humans need. Just like we need these basic necessities, so does a company when implementing a new ERP system. All five levels in an ERP sense are vital to future system success. Below you will find a creative infographic highlighting the similarities of each human need to each ERP need. Read More

Submitted by Ally Donahue on Fri, 01/15/21 - 12:36

Why an ERP System Isn’t “One Size Fits All”

Have you seen the phrase, “One Size Fits All”, marked on different types of clothing? Most items labeled as such usually are very plain and have a standard size to accommodate most. Of course there are outliers and truly not everyone can fit in a one sized option. This is also true of  ERP systems; they cannot be “One Size Fits All” due to complexities. Read More

Submitted by Ally Donahue on Fri, 01/08/21 - 10:27

Whatever Your ERP Needs, We Have the Solution!

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