Skip to main content

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

some screen shots...


 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. 


@chajash 

Could you please mention the exact steps you followed here?


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


@CallumW 

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


We 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 @CallumW 

 


@chajash,

See my comment above. Your enumeration does not match the return value of the function. Switch to e.g. FndBoolean.


@Hans Andersen exactly right!

My custom field now works as it should!

Sorry it took a couple of trys for me to understand!

Appreciate your patience!

Thanks

Cindy


Reply