Import BOMs into SAP Business One with the DTW (Data Transfer Workbench)

Просмотров 2,4 тыс.

% 30

🎦 Video Description
Using the DTW, you can upload BOMs (bill of materials) into SAP Business One.
💾 Download Resources
Video Examples: www.battleshipcobra.com/youtube-download/DTW_BOM_Import.zip
📚 Chapters
00:00 - Introduction
01:46 - Preparing Excel DTW Import Files
11:36 - Importing via DTW
19:09 - 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/

Наука

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

20 ноя 2022

Ссылка:

Скачать:

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

Добавить в:

Мой плейлист

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

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

@ArminVndg Год назад

Hi, a little bit different question, but hopefully you can help :) how does it possible to import with DTW mass orders to SAP with the partner's second or third address? SAP import the first address by default.

@BattleshipCobraSAP Год назад

Hi Ármin, yes it's possible I just tried it in my test environment. Just use the columns in the DTW template for PayToCode and ShipToCode. Use the code from CRD1.[Address] as the key. I have a video on importing documents here: ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-jFPt3ULmsMg.html

@badnews8123 Год назад

Hi Mike, how this run with ITT2 - Stages?

@BattleshipCobraSAP Год назад

Hi Max, in the DTW samples there is an exact example of the BOM import with stages. You have to set the LineNum in ITT1 to the exact number it will appear on the BOM (IE, even with the number of stages you have to put the right row) and then same on the ITT2 template (LineNum is exactly the line it will be on the BOM). BUT, remember it's a zero-base LineNum meaning it starts from the zero as the first row. So just -1 to all your rows. IE, row 2 = LineNum of 1 etc. You have to look at the StageEntry and StageId in the ORST table (SELECT * FROM ORST should show you the references). I hope that makes sense!

@vitorotaviodecastro6060 Год назад

Hey I have been watching your videos for a while. Great content keep it up. Do you have discord?

@BattleshipCobraSAP Год назад

Hi Vitor! Thanks for checking out my content. I only have Discord for gaming, I don't use it for professional stuff. If you want to send me a message then LinkedIn is the easiest for me (linkedin.battleshipcobra.com/)

@amoscookie1336 Год назад

why is dfltwhse is not in a template ?

@BattleshipCobraSAP Год назад

Hello! I'm not sure what column this is and if it's not in my basic template you don't need it. My video shows the easiest way to import, there is no requirement to have every column. I remove columns that are not needed to make things easier.