Copy & Paste from Excel - SAP Business One: Tips & Tricks

Просмотров 5 тыс.

% 53

🎦 Video Description
Learn how to copy and paste information from Excel to SAP Business One.
💾 SAP Help Portal
help.sap.com/viewer/68a2e87fb29941b5bf959a184d9c6727/9.3/en-US/7cc6877ee5494f3cbb52aea5b629a727.html
📚 Chapters
00:00 - Introduction
00:18 - Copy Table Function
02:38 - Pasting into SAP Business One Tables
04:50 - Price List Copy & Paste
07:11 - Outro
💼 Working Remotely: Efficiently and Effectively Free Course ☕
remote.battleshipcobra.com (Free)
🧮 SQL FOR SAP BUSINESS ONE COURSE NOW AVAILABLE 📈
sql.battleshipcobra.com (50% off)
📊 CRYSTAL REPORTS FOR SAP BUSINESS ONE COURSE 💎
crystal.battleshipcobra.com (50% off)
🎉ADVERTISE IN MY VIDEOS 🎊
advertise.battleshipcobra.com
😎 More About BattleshipCobra
battleshipcobra.com/
💸 Support These Videos
donate.battleshipcobra.com/

Наука

Опубликовано:

21 дек 2020

Ссылка:

Скачать:

Готовим ссылку...

Добавить в:

Мой плейлист

Посмотреть позже

Комментарии : 8

@mrb627 3 года назад

Hey Mike. - How can we make this work for User Defined Tables?

@mrb627 3 года назад

@@BattleshipCobraSAP Thanks Mike. I have written a workaround with Boyum, but it involves knowing how many 'New' rows the user wants to add. Once the blank rows exist, the paste works as expected. It isn't the prettiest method, but it avoids having to get DTW involved at an end user level. Keep up the good work. Your videos have saved me more times than I care to share!

@petereden4259 2 года назад

Hi Mike, Can you do the same using BP codes in a journal? It doesn't seem to work for me

@BattleshipCobraSAP 2 года назад

Hey Peter! Not sure what you mean, guessing you are trying to copy and paste a subledger AR/AP thing in the journal entry window? I tried this and you're right, it just fails on adding a new row with a BP. You could try the Import from Excel option. I have a video on importing BPs but there is a "Journal Entry" option there too I have not played much with and it has a GL type selection. This might be a good video for me to do in the future.

@petereden4259 2 года назад

Thanks Mike, I will look into the Import from Excel. Loving your tutorials by the way, very easy to understand and fun too !