Hi Jessy, check out my video on importing invoices, it is basically the same for orders and I include a template. Video is here: th-cam.com/video/jFPt3ULmsMg/w-d-xo.html (the template is linked in the video description and pinned comment). Thanks for watching!
Hello Sir! I am very thankful to you because I learned a lot of stuff from you regarding sap business one. Sir I want some help from you regarding sap b1. Sir I want to copy Chart of Account from one existing company to another new company. Sir please make a new video tutorial for this request. Thanks in advance
Hi Michael, I'm having trouble when I try to update a current B&R. The material is not being recognized. I put the first line in as 0 but subsequent lines (1,2,3 etc) are not recognized. Any suggestions?
For updating you usually only need the primary key (BP code, item code for example) and then as long as you have the right column name you can update whatever you want. As few as two columns can work for updates. Thanks for watching!
Thank you so much, Michael! Awesome!!! It is very useful!! Just a question. Is there any functionality that enables us to upload a file the automatically, like a job (robot). For instance, I would like to upload a customer file master data automatically every time that these files are copied to a specific repository at the server. Thanks and all the best,
Hey Michael, Thank you so much for getting back to me. Great material you sent me!!! I took a look at other videos from your channel, Congratulation! Good job!!
Hello Michael! This is a very good topic but I didn't understand how to automatically update data in DTW from a template file. Is there a configuration in B1 DTW for this? (Also, this link isn't working.) Update: I just found a working link with the explanation here: blogs.sap.com/2014/01/29/how-to-configure-a-scheduled-data-import-with-dtw-data-transfer-workbench/
Hi Aamir, you can watch my video on how to import invoices here: th-cam.com/video/jFPt3ULmsMg/w-d-xo.html (you can just switch this to be orders or whatnot, the templates are all the same)
hello Michael. the video has been very useful. I have a question. I get an error like this when opening the first user. "Connection status (US) connection to SAP-B1 has failed ERROR CODE:(-10) The specified resource name cannot be found in the image file" how to solve this problem? thanks for everything :)
Hello Michael, Would you run a tutorial for the DTW transfer of the inventory counting to update the OnHand and Available fields in Inventory? Thank you
We are trying to adjust the OnHand volumes for our items once we concluded the inventory count. This is for the 12/31/2016 date inventory balance...well this can be treated as the opening balance for the 2017. Thanks
One more thing: doing this from the Inventory counting and then inventory posting does not work well as we are dealing with the live system and the items volumes change on daily bases...A little deviation is OK. Thanks
Need tutorial to import Goods Received Po with batch / Serial through DTW And also same for Deliver Order As i am migrating data from One system I am stick with batch file setting Thanks
Usually in an implementation we want the customer to finish copying GRPOs and deliveries to invoices to avoid this issue. Then all we need is the current AR / AP / stock and trial balance. Make your life easier and see if the customer can do this. Way easier than creating all of these intermediary documents. To load your serial / batch stock (and normal stock) you can just use a regular Goods Receipt. I will add this as a video topic to cover. I have planned to do a full financial implementation video but have not done it yet. Thanks for watching!
Hi Michael, I have the two files you mentioned above. OITT is for the "header" but it's the ITT1, where all the bill of materials and routing (B&R) information sits, that I'm having issues. I have no problem uploading a new part and new B&R, it's just when I try to update an existing B&R that I'm having a problem. It will recognize the first line of the bill of materials if I have the first line numbered "0". It will not recognize subsequent items and send back an error saying that the item doesn't exist, but the items do exist. Any help would be much appreciated.
Hi Michael. I am currently doing exactly that at the moment. I was looking for a quicker way to do this as I have 62 of these to do. I know what I asking is hard for you to advise on as you would probably need to be here and see exactly what I'm doing before you could find a solution. Thanks you for you help anyway. I have subscribed to your channel and will keep an eye on it.
Do you work with CRYSTAL REPORTS? If so a video on that would be great. I have limited experience with them and having a freelancer video would be very helpful.
![ปฏิเสธไม่ไหว (Crush on you) - LIPTA feat. No One Else [Official MV]](http://i.ytimg.com/vi/NBw1jF342vw/mqdefault.jpg)
Excellent trainer that speak clearly and demo was smooth without hicucp. Very well done training video. Thanks alot really appreciate it.
Huge lifesaver and great video. Thanks for sharing. I love your method, it's quick and straight forward. Awesome!
Thank you so much Michael Taylor. the lesson was very much useful for me
Sir Can you add video on " Adding on new business partners"
Thank you
Great topic, great explanation! Thank you, Michael! You made me jump ahead on some issues.
Thanks for the clear instruction, this was very useful! You got me already at the battleship cut scene :D
Haha it did had a little scare factor.
Thanks from Pakistan!
Thanks Usama! Don't forget to add me on LinkedIn (linkedin.battleshipcobra.com) to stay in touch, M
@@BattleshipCobraSAP Sure! and you're welcome
very well explained , thanks
Thanks for watching!
Wanted to import OITW (warehouse), serials, etc maybe you could make video showing all of them
Hi Azam, I have an idea to do inventory opening balances which should cover this topic. But this is a great idea, thanks!
Thanks Mike, is there any chance of getting a template for sales order import for mass data import
Hi Jessy, check out my video on importing invoices, it is basically the same for orders and I include a template. Video is here: th-cam.com/video/jFPt3ULmsMg/w-d-xo.html (the template is linked in the video description and pinned comment). Thanks for watching!
Hello Sir!
I am very thankful to you because I learned a lot of stuff from you regarding sap business one. Sir I want some help from you regarding sap b1. Sir I want to copy Chart of Account from one existing company to another new company. Sir please make a new video tutorial for this request. Thanks in advance
Hey Michael...is there any tutorial on how can i import inventory opening balances with DTW?
Thank you in advance!
Hi Michael, I'm having trouble when I try to update a current B&R. The material is not being recognized. I put the first line in as 0 but subsequent lines (1,2,3 etc) are not recognized. Any suggestions?
How do you go about just updating certain fields I,e just columns A & K?
For updating you usually only need the primary key (BP code, item code for example) and then as long as you have the right column name you can update whatever you want. As few as two columns can work for updates. Thanks for watching!
@@BattleshipCobraSAPGot errors when leaving them blank so unmapped the additional fields and it seems to work. Thank you for your great videos
Can you do a video on how to inactivate a customer with DTW?
Hey @mike can you do a video on how to import A/R invoices through DTW. Thanks
Hi Tariq! I did do this video, you may have already seen it here: th-cam.com/video/jFPt3ULmsMg/w-d-xo.html
Thank you so much, Michael! Awesome!!! It is very useful!!
Just a question. Is there any functionality that enables us to upload a file the automatically, like a job (robot). For instance, I would like to upload a customer file master data automatically every time that these files are copied to a specific repository at the server.
Thanks and all the best,
Hey Michael, Thank you so much for getting back to me. Great material you sent me!!!
I took a look at other videos from your channel, Congratulation! Good job!!
Hello Michael! This is a very good topic but I didn't understand how to automatically update data in DTW from a template file. Is there a configuration in B1 DTW for this? (Also, this link isn't working.)
Update: I just found a working link with the explanation here:
blogs.sap.com/2014/01/29/how-to-configure-a-scheduled-data-import-with-dtw-data-transfer-workbench/
Hi! How do I manual sales post of Excel File into SAP B1
Hi Aamir, you can watch my video on how to import invoices here: th-cam.com/video/jFPt3ULmsMg/w-d-xo.html (you can just switch this to be orders or whatnot, the templates are all the same)
Little too fast, but clearly explained
Thank you good video. Can you please show me how can I DTW Fixed Asset with opening balance
Michael Taylor many thanks.
Thanks Mike. learned a lot
Thank you so much
Hey Michael, i would like to ask how do i import my data both in Bill to and Ship to in Address tab via DTW
Oh great job Michael, i will check it immediately. Thank you in advance!
hello Michael. the video has been very useful. I have a question.
I get an error like this when opening the first user.
"Connection status (US)
connection to SAP-B1 has failed ERROR CODE:(-10) The specified resource name cannot be found in the image file"
how to solve this problem?
thanks for everything :)
Thanks for everything. The note was very useful.
We have fixed the server name field. There is no trouble. :)
How to upload opening balance for AP and AR in SAP B1?
Boy oh boy, you're fast! xD
But, great tutorial nonetheless. Thumbs up player.
Hello Michael,
Would you run a tutorial for the DTW transfer of the inventory counting to update the OnHand and Available fields in Inventory? Thank you
We are trying to adjust the OnHand volumes for our items once we concluded the inventory count. This is for the 12/31/2016 date inventory balance...well this can be treated as the opening balance for the 2017. Thanks
FYI: we are dealing with 10,000+ items.
One more thing: doing this from the Inventory counting and then inventory posting does not work well as we are dealing with the live system and the items volumes change on daily bases...A little deviation is OK. Thanks
Need tutorial to import Goods Received Po with batch / Serial through DTW
And also same for Deliver Order
As i am migrating data from One system
I am stick with batch file setting
Thanks
Usually in an implementation we want the customer to finish copying GRPOs and deliveries to invoices to avoid this issue. Then all we need is the current AR / AP / stock and trial balance. Make your life easier and see if the customer can do this. Way easier than creating all of these intermediary documents. To load your serial / batch stock (and normal stock) you can just use a regular Goods Receipt. I will add this as a video topic to cover. I have planned to do a full financial implementation video but have not done it yet. Thanks for watching!
i need to know how to add a new Bp
@@BattleshipCobraSAP Thnx Michael for both videos.
Bill Of Materials and routing.
Hi Michael, I have the two files you mentioned above. OITT is for the "header" but it's the ITT1, where all the bill of materials and routing (B&R) information sits, that I'm having issues. I have no problem uploading a new part and new B&R, it's just when I try to update an existing B&R that I'm having a problem. It will recognize the first line of the bill of materials if I have the first line numbered "0". It will not recognize subsequent items and send back an error saying that the item doesn't exist, but the items do exist. Any help would be much appreciated.
Hi Michael. I am currently doing exactly that at the moment. I was looking for a quicker way to do this as I have 62 of these to do.
I know what I asking is hard for you to advise on as you would probably need to be here and see exactly what I'm doing before you could find a solution.
Thanks you for you help anyway.
I have subscribed to your channel and will keep an eye on it.
Do you work with CRYSTAL REPORTS? If so a video on that would be great. I have limited experience with them and having a freelancer video would be very helpful.