Skip to main content
Solved

Ability to copy from an excel worksheet and paste lines in to any grid like screen in Acumatica

  • February 16, 2022
  • 6 replies
  • 379 views
  • Translate All

We recently migrated from MS Dynamics SL 2018 to Acumatica. There is one feature we used a lot in MSD that is missing in Acumatica: the ability to copy from excel and paste information in any grid like screen.

For example, if we had a spreadsheet set up with the same columns, in the same order as the allocation screen, we could copy the information from there and paste into the software.

It would be very helpful to not have to upload an invoice allocation or a JE.

 

Best answer by vkumar

Hi @mmalta 

As suggested above, post a request on ideas page i.e, https://community.acumatica.com/ideas with requirement details.

Regards,

View original

6 replies

Kandy Beatty
Captain II
Forum|alt.badge.img+18

Hi @mmalta  This feature does exist in the current system.

For example on the Journal transactions, you would simply hit the Load Records from File button and you can upload an excel from there. Also, make sure your excel matches Acumatica for the upload or it will not work. 

 

Translate

  • Author
  • Freshman I
  • February 16, 2022

Hi,

Thanks for responding. I appreciate the insight!

We currently use the upload feature, which requires uploading the excel file as opposed to a copy/paste directly onto the screen.

 

Thanks again.

 

Translate

Kandy Beatty
Captain II
Forum|alt.badge.img+18

@mmalta  You can always suggest that for future considerations. 

Translate

Forum|alt.badge.img+12
  • Acumatica Support Team
  • Answer
  • February 17, 2022

Hi @mmalta 

As suggested above, post a request on ideas page i.e, https://community.acumatica.com/ideas with requirement details.

Regards,

Translate

kratzert
Jr Varsity III
Forum|alt.badge.img
  • Jr Varsity III
  • April 11, 2022

Copy/pasting LINES from a spreadsheet (not the entire Excel file) is a standard feature in many software, even old GP and SL. We really need this in Acumatica. 

Translate

Forum|alt.badge.img

I have added idea on community  please upvote it - 

 

Translate