Huge lifesaver and great video. Thanks for sharing. I love your method, it's quick and straight forward. Awesome!

Great topic, great explanation! Thank you, Michael! You made me jump ahead on some issues.

Excellent trainer that speak clearly and demo was smooth without hicucp. Very well done training video. Thanks alot really appreciate it.

Thanks for the clear instruction, this was very useful! You got me already at the battleship cut scene :D

@martijnkorbee1635

3 жыл бұрын

Haha it did had a little scare factor.

Thanks Mike. learned a lot

very well explained , thanks

@BattleshipCobraSAP

2 ай бұрын

Thanks for watching!

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

Thank you so much

Thanks from Pakistan!

@BattleshipCobraSAP

2 жыл бұрын

Thanks Usama! Don't forget to add me on LinkedIn (linkedin.battleshipcobra.com) to stay in touch, M

@munzilla

2 жыл бұрын

@@BattleshipCobraSAP Sure! and you're welcome

Boy oh boy, you're fast! xD But, great tutorial nonetheless. Thumbs up player.

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?

Hey Michael...is there any tutorial on how can i import inventory opening balances with DTW? Thank you in advance!

Can you do a video on how to inactivate a customer with DTW?

Hi! How do I manual sales post of Excel File into SAP B1

@BattleshipCobraSAP

Жыл бұрын

Hi Aamir, you can watch my video on how to import invoices here: kzread.info/dash/bejne/nHqE1pWOfNDZfco.html (you can just switch this to be orders or whatnot, the templates are all the same)

How to upload opening balance for AP and AR in SAP B1?

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,

@pmsneto79

7 жыл бұрын

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!!

@araobenjamin

6 жыл бұрын

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/

Little too fast, but clearly explained

Thanks Mike, is there any chance of getting a template for sales order import for mass data import

@BattleshipCobraSAP

Жыл бұрын

Hi Jessy, check out my video on importing invoices, it is basically the same for orders and I include a template. Video is here: kzread.info/dash/bejne/nHqE1pWOfNDZfco.html (the template is linked in the video description and pinned comment). Thanks for watching!

Wanted to import OITW (warehouse), serials, etc maybe you could make video showing all of them

@BattleshipCobraSAP

2 жыл бұрын

Hi Azam, I have an idea to do inventory opening balances which should cover this topic. But this is a great idea, thanks!

How do you go about just updating certain fields I,e just columns A & K?

@BattleshipCobraSAP

4 ай бұрын

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!

@StuartMorris-ur5bg

4 ай бұрын

​@@BattleshipCobraSAPGot errors when leaving them blank so unmapped the additional fields and it seems to work. Thank you for your great videos

Hey @mike can you do a video on how to import A/R invoices through DTW. Thanks

@BattleshipCobraSAP

Жыл бұрын

Hi Tariq! I did do this video, you may have already seen it here: kzread.info/dash/bejne/nHqE1pWOfNDZfco.html

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

@geokost

3 жыл бұрын

Oh great job Michael, i will check it immediately. Thank you in advance!

Thank you good video. Can you please show me how can I DTW Fixed Asset with opening balance

@user-ow4vl2vv5k

3 жыл бұрын

Michael Taylor many thanks.

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 :)

@tugbablt5979

6 жыл бұрын

Thanks for everything. The note was very useful. We have fixed the server name field. There is no trouble. :)

i need to know how to add a new Bp

@usamaakhtar5554

5 жыл бұрын

@@BattleshipCobraSAP Thnx Michael for both videos.

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

@BattleshipCobraSAP

11 ай бұрын

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!

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

@alexutsis5251

7 жыл бұрын

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

@alexutsis5251

7 жыл бұрын

FYI: we are dealing with 10,000+ items.

@alexutsis5251

7 жыл бұрын

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

Bill Of Materials and routing.

@Suir1972

6 жыл бұрын

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.

@Suir1972

6 жыл бұрын

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.

@Suir1972

6 жыл бұрын

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.