Apps10
We are trying to add Buyer_Code from Purchase_order to the Posting Proposals screen...but getting this error message
Userlevel 6
+14
Hello
by the argument change the v by a t
i tried to replace the v with t, still have the same error
Userlevel 7
+18
we’ve resolved a similar issue as below. Please follow it,
Error in creating a Custom Field | IFS Community
But in your example, you are referring non existing column name of the view POSTING_PROPOSAL_HEAD.
In CORE reference environment there is no column called po_ref_Number in POSTING_PROPOSAL_HEAD.
Please check whether there is a column called po_ref_Number in your database code POSTING_PROPOSAL_HEAD
HI Kelum
Po_Ref_Number is the field name for column PO Ref on our Posting Proposals screen.
I made a ticket for IFS and they were also having the same problem with this field.
I will post what the remedy was.
Thanks
Cindy
Userlevel 7
+18
Hi
“When a Select statement is set up for a Read-Only field, the arguments must exist in the base view or the base table for the LU, as well as in all approved detail views on that LU”
IFS documentation said as above.
The base view of logical unit PostingProposalHead is "posting_proposal_head” and PO_REF_NUMBER is not available there.
In Postal proposal window, PO_REF_NUMBER is comes from the view POSTING_PROPOSAL_INVOICE_FINAL and its not a base view.
you will get further assistance through the created Support ticket.
I decided to create a custom view and then use that to get the values for the custom field.
It was too difficult to find a LU in the system that actually linked the payment proposal invoice_id and PO number. :-(
Anyway moral of the story is that there is more than one way to skin a cat!
Cindy
Reply
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.