I have Custom Fields within Work Order Purchase Requisition Lines that I would like displaying on the Purchase Requisition Lines but I am unable to work out how I get them to display.
Can anyone provide any help on what I need to be linking by or the code I need to get this to work?
Thanks
Best answer by EqeRobertK
Hi
There are several ways to do so, but herewith an example with using a select statement.
It is only possible to have the filed as a read only field.
I have created custom field on the WO Part requisition line:
Then I create a Custom field on the PR line (read only):
With the following argument (v.requisition_no, v.RELEASE_NO, v.LINE_NO)
and select (SELECT RL.CF$_TEST FROM IFSAPP.PART_WO_REQUIS_PURCH_LINE_CFV RL
WHERE RL.REQUISITION_NO = :REQUISITION_NO
AND RL.LINE_NO = :LINE_NO
AND RL.RELEASE_NO = :RELEASE_NO)
This results that the field will show the custom field on the WO with the value which was entered there:
Is this what you were looking for?
PS: it should alos be possible the an expression instead of the select statement.
Good luck,
Robert
this is what I am trying to do but I confess I really have no idea.
The TVS Code exists in the WO Purchase Req Lines and I want it to be visible on the Purchase Req Line Screen
+15Hi
There are several ways to do so, but herewith an example with using a select statement.
It is only possible to have the filed as a read only field.
I have created custom field on the WO Part requisition line:
Then I create a Custom field on the PR line (read only):
With the following argument (v.requisition_no, v.RELEASE_NO, v.LINE_NO)
and select (SELECT RL.CF$_TEST FROM IFSAPP.PART_WO_REQUIS_PURCH_LINE_CFV RL
WHERE RL.REQUISITION_NO = :REQUISITION_NO
AND RL.LINE_NO = :LINE_NO
AND RL.RELEASE_NO = :RELEASE_NO)
This results that the field will show the custom field on the WO with the value which was entered there:
Is this what you were looking for?
PS: it should alos be possible the an expression instead of the select statement.
Good luck,
Robert
thank you so so much
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
