B1 validation SQL condition- Using multiple Items on deferents formtype

Answered

franck aubert joel thomas gaha

• October 11, 2018 11:36

 Dears

Can someone give me a help.

I'm performing a MRP module for a client throught a remote desktop. The client use B1 Usability 2017 version  that do not include MRP validation document for production order. I created a UDF with 3 options (Pedning as defaut, QC_Approval and Rejected). I want to set up a restriction for a certains users

I want to create a B1 validation and a UF that could do this

1- If the value in the UDF formtype -65211 is not equal to QC_Approval and If the user x want to change the statut of the Production order in the Fromtype 65211 form Planned to Released. I want the system to Block.

2- You can advise me a another way but i don't have acces to the server to use the native Store procedure

 

UDF: Formtype: -65211, Item: U_MRP

PO statut: Formtype: 65211, Item: 10

Looking forrward

Best regards

Vote

0

• Official comment

  

  Yaremi Miranda Lopez

  • October 19, 2018 17:19

  Hello Franck,

  Due to the difficulties of the requirement, I suggest you contact your Partner to get help and information, this is a very specific scenario that you're trying to achieve.

   

Please sign in to leave a comment.