I have a request to take the Boolean Field “Payment Schedules Exist” from Purchase Order
And to place it as a custom field on Supplier Payment Proposal Details. I am a little stumped, I have tried adding it as an Expression Boolean field, but no information comes through.
Order_Reference = Order_No
Best answer by CallumW
Works fine for me:
Custom Field Setup:
Read Only / Expression
Expression Statement: PUR_ORD_PAY_SCHED_LINE_API.Exist_Pay_Sched_Lines(ORDER_REFERENCE)
Enumeration/Boolean
Enumeration: FndBoolean
I have tried adding it as an Expression Boolean field, but no information comes through
I presume you are calling pur_ord_pay_sched_line_api.Exist_Pay_Sched_Lines().
It returns varchar2. -’TRUE’ or ‘FALSE’. If your enumeration do not contain these values it might just fail.
+14Could you please mention the exact steps you followed here?
+16Works fine for me:
Custom Field Setup:
Read Only / Expression
Expression Statement: PUR_ORD_PAY_SCHED_LINE_API.Exist_Pay_Sched_Lines(ORDER_REFERENCE)
Enumeration/Boolean
Enumeration: FndBoolean
What version / update of IFS are you using?
Curious because I have just tried in a different environment and still not working for me.
I am on Apps10 UPD 13
Thanks
Cindy
+16We are on Apps 10 UPD 15, however I can’t imagine that would be the issue
Interestingly enough I can get the Order_No to show up just not working as checkbox
We have the Boolean field working in other LUs so pretty sure that is not the issue.
I also still have the Expression on PSE_2 from above and its working for
See my comment above. Your enumeration does not match the return value of the function. Switch to e.g. FndBoolean.
My custom field now works as it should!
Sorry it took a couple of trys for me to understand!
Appreciate your patience!
Thanks
Cindy
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
