Пікірлер

• 
  @azam80277 күн бұрын

  thank you for the informative video. in my web client , accounting and production is not showing in the menu , can you tell me why ?

• 
  @sysconz3 күн бұрын

  Only journal entries are available in the web client under accounting and I guess production is not yet available in the web client.

• 
  @azam80277 күн бұрын

  what about project based budget sir ?

• 
  @azam80277 күн бұрын

  THANK YOU

• 
  @leoncar27Ай бұрын

  Thanks

• 
  @ToXisCo2 ай бұрын

  I need to to the same thing but with Import from Excel. I can't find the way to put a blank or null values from there. Anyone knows a tips for this ?

• 
  @sysconz2 ай бұрын

  I assume import from Excel does not have such a feature, you can try 0 or another character instead of null values.

• 
  @casafoot51763 ай бұрын

  Thank you for the video, but there is a method to import with vba excel ?

• 
  @sysconz2 ай бұрын

  Yes, if it can be tweaked and works like excel macro then it can be used to import data in SAP B1.

• 
  @casafoot51762 ай бұрын

  @@sysconz Do you have the script ?

• 
  @sysconz2 ай бұрын

  @@casafoot5176 Sorry don't have a script. Can refer a developer who can write it as paid service.

• 
  @casafoot51762 ай бұрын

  @@sysconz It's done without refer to a developer thank you

• 
  @irfanrasheed64984 ай бұрын

  This video provided a very clear explanation of DTW.

• 
  @siorge5 ай бұрын

  Thank you, this is one of the first SAP videos I've seen on KZread that was actually useful. Well done!

• 
  @sysconz5 ай бұрын

  Thanks, please like subscribe and share.

• 
  @MegaSonu755 ай бұрын

  Good

• 
  @AliShanpullat5 ай бұрын

  Sir please your WhatsApp Number

• 
  @sysconz5 ай бұрын

  [email protected]

• 
  @ThKlein-jv9tr7 ай бұрын

  Thanks for the detailed description and side notes! For me, the main takeaway is I can delete field values, but not complete records.

• 
  @gmailmartin279 ай бұрын

  What if my budget has hundreds of lines and is split between 2 dimensions?

• 
  @sysconz8 ай бұрын

  Yes, you should be able to upload it if DTW has a template relevant for the dimensions.

• 
  @NizikoGM10 ай бұрын

  Thank you!

• 
  @jillbentley344811 ай бұрын

  Do you have a video using the WTR19 bin locations importing

• 
  @sysconz11 ай бұрын

  Please have a look at the below video. Please support this channel by like, subscribing and sharing its content. kzread.info/dash/bejne/X5mVwdOCoNa7l7g.html

• 
  @jillbentley344811 ай бұрын

  great video - but I keep getting an error message 1470000838 - Invalid "SerialAndBatchNumbersBaseLine"; specify a valid "SerialAndBatchNumbersBaseLine"65171 do you know where I can get help on importing

• 
  @BhanuPratap-li3in11 ай бұрын

  Hi, Can you share the SAP B1 Hana complete query

• 
  @sysconz11 ай бұрын

  Please try the below query SELECT T0."WddCode", (SELECT a."Name" FROM OWTM a WHERE a."WtmCode" = T0."WtmCode") AS "Approval Template", X."CardCode", X."CardName", X."DocTotal" FROM "OWDD" T0 INNER JOIN WDD1 T1 ON T1."WddCode" = T0."WddCode" INNER JOIN ODRF x ON x."DocEntry" = T0."DraftEntry" AND x."ObjType" = T0."ObjType"

• 
  @user-ny4us7ov5p Жыл бұрын

  how to connect with you?

• 
  @sysconz Жыл бұрын

  [email protected]

• 
  @beniaminojewkes8027 Жыл бұрын

  Promo*SM

• 
  @AbdulAhad-fx4mo Жыл бұрын

  Hi can you share the complete query

• 
  @sysconz Жыл бұрын

  SELECT T0.[WddCode], (SELECT a.[Name] FROM OWTM a WHERE a.[WtmCode] = T0.[WtmCode]) as 'Approval Template' , X.CardCode, X.CardName, X.DocTotal FROM [dbo].[OWDD] T0 inner join WDD1 T1 on T1.[WddCode] = T0.[WddCode] inner Join ODRF x on x.DocEntry = T0.DraftEntry and x.ObjType = T0.[ObjType]

• 
  @NaveenKumar-hx8fo Жыл бұрын

  Help full

• 
  @NaveenKumar-hx8fo Жыл бұрын

  Thank you sir Completed sap b1 cource want me ......and continue sap b1 videos. Good explained

• 
  @sysconzАй бұрын

  Coming soon.

• 
  @vigneshwarms1645 Жыл бұрын

  Hi, its not working in SAP B1 hana 9.3 PL 11.

• 
  @sysconz Жыл бұрын

  Please convert it to HANA, This is for SQL

• 
  @SandsSenpai Жыл бұрын

  Hi. Can you share your query here? Please. It would be a great help.

• 
  @sysconz Жыл бұрын

  It looks i cannot msg you, here is the basic query you can modify SELECT T0.[WddCode], (SELECT a.[Name] FROM OWTM a WHERE a.[WtmCode] = T0.[WtmCode]) as 'Approval Template' , X.CardCode, X.CardName, X.DocTotal FROM [dbo].[OWDD] T0 inner join WDD1 T1 on T1.[WddCode] = T0.[WddCode] inner Join ODRF x on x.DocEntry = T0.DraftEntry and x.ObjType = T0.[ObjType]

• 
  @NaveenKumar-hx8fo Жыл бұрын

  sap b1 full course plese sir i request.

• 
  @sysconz Жыл бұрын

  Will try in next quarter, Actully full course requires a lot of time. Usully I provide instructor led trainings in a full class room environment with option to practice on SAP B1.

• 
  @MrHamtaq Жыл бұрын

  Please share dashboards creation and configuration. Thanks

• 
  @AbdulWahab-fx9qc Жыл бұрын

  good work..keep it up

• 
  @triconconsultant3758 Жыл бұрын

  Well-done jeep it up.

• 
  @adenirandeji6643 Жыл бұрын

  Thank you so much for this informative session. I have pended a task to create an approval on Delivery quantity > 10%+SO quantity on Hana DB. It has been so difficult because the client did not want TN for this task

• 
  @sysconz Жыл бұрын

  I am glad it was helpful, Stay tuned for more!!

• 
  @ivanpereira9820 Жыл бұрын

  Great Video,thanks!!!😄... I have a question: is possible to send custom crystal reports balance to multiple cursomers for email?

• 
  @sysconz Жыл бұрын

  Hi ivan, unfortunately, there is no standard feature to email custom crystal reports to multiple customers. We do have a tool (At an affordable price) to view crystal reports without login into SAP, we can add features according to your requirements and it will send custom crystal reports automatically to customers based on intervals. For more details please share your email or get in touch at [email protected].

• 
  @triconconsultant3758 Жыл бұрын

  Yes it's possible if you are using sap hana you can setup this feature on SAP analytical portal. They you can do exact same thing.

• 
  @sysconz Жыл бұрын

  @@triconconsultant3758 to send crystal report from analytics portal a user must exist in SAP so it's not the best approach to create a user for each customer.

• 
  @jonathanbrotto1991 Жыл бұрын

  Quick answer "/" character. My question is drop down with no NULL/blank option

• 
  @sysconz Жыл бұрын

  If its a mandatory field then definitely it cannot be set as null, If its an optional field and there is no validation in the database you should be able to set a null value in it even though it has to drop down.

• 
  @SAGopalakrishna2 жыл бұрын

  hi you made it very simple, please share your contact to reachout you for training and value addtions.

• 
  @sysconz Жыл бұрын

  [email protected]

• 
  @anonje Жыл бұрын

  How to display price list of SKUs in SAP ? What is the transaction code ?

• 
  @micheleclemetsen25312 жыл бұрын

  I found this very helpful! Do you have to upload the SPP2 template for volume discounts even if it doesn't apply? Or can you just upload OSPP and SPP1?

• 
  @sysconz2 жыл бұрын

  SPP2 stores discount and UOM info, if you are not using Manual UOMs (UOMs are defined in UOM groups) than its recommended to upload spp2 as well.

• 
  @baryalnoor26122 жыл бұрын

  Thanks for the video, was looking for the exact same procedure and found it. Much appreciated.

• 
  @MrTycoonkikin2 жыл бұрын

  So the Transaction Notification procedure its not created with the installation?

• 
  @sysconz2 жыл бұрын

  Customized codes has to be written as per requirements

• 
  @haiderabdullah72444 жыл бұрын

  Thanks sensei....

• 
  @joan34365 жыл бұрын

  Thank you

• 
  @MohammedAlsaada5 жыл бұрын

  Thank you