Solved

Custom field question/Help

  • 6 September 2022
  • 9 replies
  • 280 views

Userlevel 3
Badge +10

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

icon

Best answer by CallumW 7 September 2022, 15:52

View original

9 replies

Userlevel 3
Badge +10

some screen shots...

Userlevel 6
Badge +14

 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. 

Userlevel 6
Badge +12

@chajash 

Could you please mention the exact steps you followed here?

Userlevel 6
Badge +15

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

Userlevel 3
Badge +10

@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

Userlevel 6
Badge +15

We are on Apps 10 UPD 15, however I can’t imagine that would be the issue

Userlevel 3
Badge +10

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 

 

Userlevel 6
Badge +14

@chajash,

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

Userlevel 3
Badge +10

@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