Skip to main content
Solved

Using a Custom Field as a parameter in Read Only Custom Field (APS9)


Forum|alt.badge.img+4

Hi All,

I’m trying to create a custom field that looks up the planner of a part (using INVENTORY_PART_API.Get_Planner_Buyer) where the company is always 1 and the part number is an other custom field in a custom logical unit I’ve created. Please see the image below:

 

Here is the error I’m getting during validation:

 

Best answer by BOrion

Well it looks like there is something else going on with our application. This should work, and does work for other users. I have a ticket with IFS to investigate. Thanks!

View original
Did this topic help you find an answer to your question?

paul harland
Superhero (Employee)
Forum|alt.badge.img+24

hello,

try cf$_nc_part

(you’re missing an underscore)


Forum|alt.badge.img+9
  • Hero (Partner)
  • August 28, 2020

INVENTORY_PART_API.Get_Planner_Buyer('1',v.cf$_nc_part)


Forum|alt.badge.img+4
  • Do Gooder (Customer)
  • August 31, 2020

Thank you guys for the replies, however, I still get the same error.

 

Custom Field Expression
Error

 


Forum|alt.badge.img+9
  • Hero (Partner)
  • August 31, 2020

try v.cf$_nc_part

 

v

not

t

 

v = variable


Forum|alt.badge.img+4
  • Do Gooder (Customer)
  • August 31, 2020

I tried v as well with the same error.

 

I always thought the v in this expression was view and t was table. Thanks for that clarification!


Forum|alt.badge.img+7
  • Hero (Customer)
  • August 31, 2020

Did you try without both v and t as well?


Forum|alt.badge.img+4
  • Do Gooder (Customer)
  • August 31, 2020
djay wrote:

Did you try without both v and t as well?

Yes, both have been attempted. It seems as though any time I try to reference any custom field in another Read Only field, the same error is present.


Forum|alt.badge.img+9
  • Hero (Partner)
  • August 31, 2020

That’s strange.

Look at the example below:

Inventory Part M1010-123 has Planner = TOOK

Another Inventory Part ZAK01 has CF “Nc Part” value referring to part M1010-123.

Another CF “Nc Part Planner” works fine.

 

Nc Part Planner definition:

 


Forum|alt.badge.img+7
  • Hero (Customer)
  • August 31, 2020
BOrion wrote:
djay wrote:

Did you try without both v and t as well?

Yes, both have been attempted. It seems as though any time I try to reference any custom field in another Read Only field, the same error is present.

Yes. I have experienced same when using read-only custom fields in select statements. But for expressions using read-only custom fields work.


Forum|alt.badge.img+4
  • Do Gooder (Customer)
  • August 31, 2020

Well it looks like there is something else going on with our application. This should work, and does work for other users. I have a ticket with IFS to investigate. Thanks!


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