Copy Data From SAP Business One

Export Content from SAP B1 to Spreadsheet

1. Open any marketing document. Right click the document form and choose “Copy Table”.

2. Go to Excel, right click and choose “ Paste”. You will see the document lines have copied over to the spreadsheet.

Paste Data into SAP Business One

Import Spreadsheet Data into SAP B1

1. After you edit the data, you can select these items as documents lines and copy the table.

2. Open any of the Marketing document. First to fill in the Business Partner data. On the document line, right click and choose paste.

You will see the data in Excel has been copied over to SAP Business One!

Free Consultation

Talk to our consultant, call us now or email us your enquiry

+603-8075 8819

Enquiry

KDS Consulting Sdn Bhd
(769998-P)

D-3-53, IOI Boulevard, Jalan Kenari 5,
Bandar Puchong Jaya,
47170 Puchong, Selangor,
Malaysia.

JB Office

Manhattan @ Menara Hartamas, Block B, #08-10,
Jalan Austin Heights 8/2,
Taman Mount Austin,
81100 Johor Bahru,
Malaysia.