SAP Business One – Copy and Paste Table Content

SAP B1 Copy and Paste

SAP Business One – Copy and Paste Table Content

 

Have you ever wanted to copy the content of one SAP Business One document to another? or to MS Excel? SAP business One allows you to copy table from document (such as A/P invoice or sales order) to another document. In addition, you can copy table from SAP Business One document to MS Excel and vice versa all on the fly!

 

 

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 Business One!

 

Come and discuss with the Inecom team to see how we can help transform the future of your business systems with SAP Business One 9.3.
Call 1-800-155-999 for more detail and book your workshop here: https://www.inecom.com.au/contact-us/