Skip to main content
Question

Custom Field on Customer Orderlines

  • December 27, 2022
  • 5 replies
  • 233 views

Forum|alt.badge.img+8
  • Sidekick (Customer)
  • 25 replies

Hi! 

I am adding a Custom Field to Customer Order Line and need some help.

The field I am trying to add is Numeration group field that you found under Customer/Invoice/General tab.

 

I chose Read Only, gave Name and then tried with some Arguments but I get error message in the end, “Error in validation of custom field attribute…”

Does anyone try to help me how to write Arguments and Select Statement?

 

Thanks. 

 

5 replies

EqeRobertK
Superhero (Partner)
Forum|alt.badge.img+15
  • Superhero (Partner)
  • 231 replies
  • December 28, 2022

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


Forum|alt.badge.img+8
  • Author
  • Sidekick (Customer)
  • 25 replies
  • December 28, 2022

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… 

 


EqeRobertK
Superhero (Partner)
Forum|alt.badge.img+15
  • Superhero (Partner)
  • 231 replies
  • December 29, 2022

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


Forum|alt.badge.img+8
  • Author
  • Sidekick (Customer)
  • 25 replies
  • January 25, 2023

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. 


EqeRobertK
Superhero (Partner)
Forum|alt.badge.img+15
  • Superhero (Partner)
  • 231 replies
  • January 25, 2023

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


Reply


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings