Since Version 9.1, SAP Business One allowed users to copy table content from document (such as A/P invoice or sales order) to another document or MS Excel in both directions.

Example 1: Export content from document to MS Excel.

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 AR invoice document lines have copied over to the excel sheet.


Example 2: Import MS Excel data into SAP Business One

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


2. Open any of the Marketing document here I use AR invoice as an example. 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.


If you need assistance, feel free to contact us.
Contact Us
by MTC Systems on Jul 11, 2016 9:35:45 PM

Leave a comment

Related posts

No Restriction When Setting Revenue Accounts in SAP

SAP Business One is designed to fit all types of businesses. For example, usually we set the revenue accounts of a business as...

MTC Systems
By MTC Systems - November 14, 2017
Tips When Reading Forms in SAP Business One

It can be inconvenient when you company receives a document with a long list of items. Finding a specific item can also be...

MTC Systems
By MTC Systems - November 10, 2017
Tracking the Inventory Counting in SAP Business One

Inventory is an important direction of most of the manufactural companies. Inventory counting and tracking can be helpful in...

MTC Systems
By MTC Systems - February 2, 2017