Hi @Nicky , please see below,

inventory_part_api.get_prime_commodity(contract,part_no)

Thanks,

Jamie

Hi Jamie, many thanks for taking the time to reply :) 

I still get this pesky error! 

Can you show me the expression you are adding?

Hi Jamie, 

Here is the expression:

Please try the following,

inventory_part_api.get_prime_commodity(t.contract,t.part_no)

It did not like that either 

@Nicky can you completely remove your custom fields and retry again?

It should be working :(

I will give it another go :)

Hi, so completely removed, logged out and back in again.. 

but still errors, sorry its being a pain!   I managed to get the column in using this

 but i am missing the data after reloading the configuration and refreshing, tbh its more of me trying anything (with a limited skill set)

Give this a bash please using the select option.

Arguments = v.requisition_no, v.line_no, v.release_no, v.contract

Select Statement = 

SELECT PRIME_COMMODITY FROM INVENTORY_PART WHERE CONTRACT = :contract AND PART_NO = purchase_req_line_part_api.Get_Part_No(:requisition_no, :line_no, :release_no)

I will have a go!! Thank you for your time :)

Hi i was able to approve and publish 

But when reloading the configuration 

The system does not restart the page for me to select the new column 

Can you make sure the view name is approved here,

If you click here and approve PURCHASE_REQ_LINE_ALL then click OK. You can the Synchronise and the field should then be visible.

the issue is that none of the views are approved for the customer fields.

Just unapproved and did it all again :) 

YOU DID IT Thank you very very much for your time and patience !!

No worries. Happy to help