Rahul
- Total activity 20
- Last activity
- Member since
- Following 0 users
- Followed by 0 users
- Votes 1
- Subscriptions 5
Activity overview
Latest activity by Rahul-
Rahul commented,
@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
-
Rahul created a post,
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 commented,
Hi Yaremi It works perfectly Thanks a lot Regards Rahul
-
Rahul commented,
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...
-
Rahul commented,
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
-
Rahul commented,
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')...
-
Rahul created a post,
Message to alert Inactive Item
AnsweredHi 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 commented,
Hi Nadav It works perfectly Thank you very much Much appreciated Regards Rahul
-
Rahul commented,
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...
-
Rahul commented,
Hi Nadav Thanks for your reply It works and a message pops up when there is no BOM also, how do I add the below criteria so that it ignores anything that belongs to this item group code? OITM.[Itms...