SAP Business One Hidden feature | Copy and paste from Excel
December 29, 2021
Recent Posts
- From Excel Chaos to Automated Operations: How Power Apps Transformed a Field Service Business
- Power BI vs Excel: Which Reporting Tool Is Right for Your Business?
- Smarter Call Scheduling with Power Automate, SharePoint and Microsoft Teams
- We’re Heading to the Odoo Business Show in Birmingham: Here’s What We Want to Talk About
- Only One in Six UK Businesses Are Using AI. Is Manufacturing Falling Behind?
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 (United States) 
English (UK) 
English (Ireland) 
English (India)