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
  • 218 views

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
Did this topic help you find an answer to your question?

6 replies

Kandy Beatty
Captain II
Forum|alt.badge.img+16
  • Captain II
  • 2209 replies
  • February 16, 2022

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. 

 


  • Author
  • Freshman I
  • 5 replies
  • 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.

 


Kandy Beatty
Captain II
Forum|alt.badge.img+16
  • Captain II
  • 2209 replies
  • February 16, 2022

@mmalta  You can always suggest that for future considerations. 


Forum|alt.badge.img+12
  • Acumatica Support Team
  • 871 replies
  • 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,


kratzert
Jr Varsity III
Forum|alt.badge.img
  • Jr Varsity III
  • 50 replies
  • 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. 



Reply


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings