on 09-30-2008 12:19 AM
Hi Experts,
We could not find out any fields that can be used to disable issue material for production over planned quantity. Could it be possible to do that ? Pls resolve.
B'Regards,
Andres
Dear Experts,
Thx for your answer. I will test and let see the result either using SP_TN or UDF+query FMS. The result must suitable for us when running the B1 system
B'Regards,
Andres
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi,
here is the query:
SELECT CASE WHEN $[$13.U_ActIssue.NUMBER] >= '0'
OR (SELECT T1.U_IssueOvr FROM WOR1 T1 INNER
JOIN OWOR T0 ON T0.DocEntry = T1.DocEntry
WHERE T0.DocNum = $[$13.61.0] AND
T1.LineNum = ($[$13.60.NUMBER]-1)) = 'Y'
THEN 'N' END
do not forget to create user define fields i.e. IssueOvr and U_ActIssue.
The query FMS is assigned to the field U_Issueovr.
Let me know if you still confuse.
Rgds,
Hi,
the FMS will block the creation of Issue for production if the quantity input in the quantity column is over finished or planned quantity.
Do not forget to tick autorefresh when field changes tick box. Select the U.ActIssue field. you could give whatever the udf description and then select display saved user defined values radio button.
Rgds,
Hi Andres,
Are you trying to block adding issue for production ?
I think beside SP_TN, you could also use a certain UDF and using query formatted search to give info if the quantity is not over planned quantity. usually, there is a mandatory value in the udf, e.g. No. The UDF title could be used is over qty. The value is no. so, when system check the quantity field using formatted search, the value can be available or not depending on the quantity filled by user.
Rgds,
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Andres,
This cannot be done through any fields. This has to be handled using Transaction Notification Stored procedure.
I am not sure but I remember seeing a similar question and the solution posted on the Forum before
Suda
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
89 | |
7 | |
6 | |
3 | |
3 | |
3 | |
3 | |
3 | |
3 | |
3 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.