SAP Business One Hidden feature | Copy and paste from Excel
December 29, 2021
Recent Posts
- Finance and Operations Integration: Where ERP Projects Often Succeed or Fail
- From Batch to Shelf: How Better Systems Help Food Manufacturers Reduce Waste, Improve Traceability and Protect Margins
- Irish Manufacturing Growth: Are Your Systems Ready to Scale?
- AI and Compliance in Financial Services: How to Innovate Without Losing Control
- Odoo 19.4: The Key New Features Businesses Should Know
Want to make your Microsoft 365 work harder for your business?
and we’ll tailor a solution that’s just right for you.
Whether you are copying from marketing documents or goods received in inventory documents, the option to copy from the excel document to paste to SAP B1 data sheets makes it very easy on the go. It automatically does other calculations, like speed, tax etc at the same time.
Setup:
- Copy the excel data > paste under corresponding SAP sheet
- Make sure that all the columns in excel and columns in SAP B1 are the same.
Shows copy-pasted data from an excel sheet automatically assigned in SAP B1 functionalities.
Usability: While the user is creating any marketing Documents, Inventory transfer, Goods Receipt and issue user can copy the data from excel and paste it into SAP Business one ‘n’ number of lines. To complete the process smoothly user needs to maintain the columns in excel which needs to be matched with SAP document columns.
Target Integration is a SAP Business One Partner and helps you get benefited with this new advanced technology. Adapt these changes & always stay ahead in your business. Contact our SAP Business One Consultants today
English (UK) 
English (United States) 
English (Ireland) 
English (India)