cancel
Showing results for 
Search instead for 
Did you mean: 

Copy & Paste from Microsoft Excel

Former Member

Dear Experts,

We are using SAP Business One Version 9.2 PL 02 and we have the following question:

When we copy large amount of data from Microsoft Excel (more than 2000 lines), to a Sales Quotation, it takes too long for the process to complete.

We were wondering how the process can speed up . Maybe we should use a specific Excel template?

Thank you in advance

Kind Regards

Vassilis

Accepted Solutions (1)

Accepted Solutions (1)

Johan_H
Active Contributor
0 Kudos

Hi Vassilis,

With any amount of rows larger than say 50, copy pasting from Excel is just going to be slow. With the amount of rows you are talking about, copy-paste from Excel is not the right solution. You really need to consider the DTW, or some method, like an addon with the DI Server, that uses XML.

Regards,

Johan

Answers (1)

Answers (1)

kothandaraman_nagarajan
Active Contributor
0 Kudos

Hi,

Even If we copy 200 lines, It consumes more time. May be you can try,

1. Add only item code, unit price and qty in excel sheet

2. Create multiple sales quotations instead of one if possible.

3. Try with duplicate option.

Regards,

Nagarajan