Custom Field on Customer Orderlines

Hi @Asadan ,

You can use the folling statement with argurment (the custom field I created is C_FIELD)

Argument:

v.customer_no, v.contract

Select:

SELECT C.CF$_C_FIELD FROM IFSAPP.IDENTITY_INVOICE_INFO_CFV C
WHERE C.COMPANY = IFSAPP.COMPANY_SITE_API.GET_COMPANY(:CONTRACT)
AND C.IDENTITY = :CUSTOMER_NO
AND PARTY_TYPE_DB = 'CUSTOMER'

Hope this wil help you,

Robert

Thank you for your reply, however, it still doesn’t work. I am trying to fetch value with Read Only from standard filed called “NUMERATION_GROUP” from identity_invoice_info_tab. 

So I think it should be something like below? But this didn’t work… 

Hi @Asadan ,

Why are you using both customer_id and customer_no?

customer_id does not even exist in the customer order line, so this will not work.

Another thing is the hard copy ‘30’ as a company. I am not sure how many companies you have, but I would notmake that hard copy. With my select you can see how to solve this.

so you can use the following for the numeration group field:

Argument:

v.customer_no, v.contract

Select:

SELECT C.NUMERATION_GROUP
FROM IFSAPP.IDENTITY_INVOICE_INFO C
WHERE C.COMPANY = IFSAPP.COMPANY_SITE_API.GET_COMPANY(:CONTRACT)

AND C.IDENTITY = :CUSTOMER_NO

AND PARTY_TYPE_DB = 'CUSTOMER'

Hope you will manage,

Robert

Hi Robert, thank you for your replay and I tried your select but it still doesn’t work… If someone could have done this please post here so I know it should be something wrong in our environment. 

Hi @Asadan ,

Please have a look at 

There @Link pasted a document about how to create a custom field. Maybe that document will be helping you out on this.

Good luck,

Robert