Rahul

@Apollo Cherniak Create a B1 Validation Configuration and a Universal Function Configuration as below.  Select No Condition, just execute function and put your UF there Hope it works for you Regards

• Ver comentario
• 20 de agosto de 2020 06:31
• 0 votos

SQL Condition to Change Tab Colour

Hi Experts I have created a B1 Validation Configuration and couple of Universal Function Configuration, but it doesn't seem to work and I can't figure out what the problem is. Still learning  The a...

• Rahul
• 20 de agosto de 2020 06:07
• 1 seguidor
• 0 comentarios
• 0 votos

Hi Yaremi It works perfectly Thanks a lot Regards Rahul

• Ver comentario
• 25 de mayo de 2020 00:26
• 0 votos

Hi Luca I am trying to create a message box so that when a user is entering a Product Code in the Sales Order and that Product Code is inactive in the Item Master Data it will show a message to ale...

• Ver comentario
• 5 de mayo de 2020 07:35
• 0 votos

Still doesn't want to play ball   IF ((SELECT TOP 1 frozenFor FROM T0.OITM WHERE T0.ItemCode=$[$38.1.0])='Y') BEGIN SELECT 'STOP' [result] END

• Ver comentario
• 5 de mayo de 2020 07:17
• 0 votos

I put two open (( and two close )) and still getting an error. Is there an easy way to figure out where it is missing?   IF ((SELECT TOP 1 frozenFor FROM dbo.OITM WHERE T0.ItemCode=$[$38.1.0])='Y')...

• Ver comentario
• 5 de mayo de 2020 07:05
• 0 votos

Message to alert Inactive Item

Hi Experts I am trying to create a message box so that when a user is entering a Product Code RDR1.[ItemCode] in the Sales Order and that Product Code is inactive in the Item Master Data OITM.[froz...

• Rahul
• 5 de mayo de 2020 06:23
• 4 seguidores
• 8 comentarios
• 0 votos
• Respondida

Hi Nadav It works perfectly Thank you very much Much appreciated Regards Rahul  

• Ver comentario
• 30 de abril de 2020 05:39
• 0 votos

Hi Nadav Sorry i am still a beginer at this Tried the below, but it wont work   IF (NOT EXISTS (SELECT TOP 1 O.CODE FROM dbo.OITT O WHERE O.CODE = $[$38.1.0])AND T0.[ItmsGrpCod] <> '288') FROM OITM...

• Ver comentario
• 28 de abril de 2020 23:54
• 0 votos