Skip to main content
Solved

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

  • August 27, 2020
  • 10 replies
  • 1019 views

Forum|alt.badge.img+4
  • Do Gooder (Customer)
  • 5 replies

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!

10 replies

paul harland
Superhero (Employee)
Forum|alt.badge.img+24
  • 547 replies
  • August 27, 2020

hello,

try cf$_nc_part

(you’re missing an underscore)


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

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


Forum|alt.badge.img+4
  • Author
  • Do Gooder (Customer)
  • 5 replies
  • 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)
  • 51 replies
  • August 31, 2020

try v.cf$_nc_part

 

v

not

t

 

v = variable


Forum|alt.badge.img+4
  • Author
  • Do Gooder (Customer)
  • 5 replies
  • 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)
  • 27 replies
  • August 31, 2020

Did you try without both v and t as well?


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

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)
  • 51 replies
  • 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)
  • 27 replies
  • August 31, 2020

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
  • Author
  • Do Gooder (Customer)
  • 5 replies
  • Answer
  • 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!