Skip to main content
Solved

Parameter Lookup OperationCD - GetFieldSchema


nathantrauscht
Semi-Pro II
Forum|alt.badge.img+1

Added Production Order Operation CD as a parameter/filter for AM625010 to print on necessary operation materials and barcodes.

 

It works, but I am struggling to make the Operation CD a lookup so the user does not need to reference production details to find the right Operation CD.

 

I have tried =Report.GetFieldSchema('AMProdOper.OperationCD,ProdOrdID') but that did not work. I’m not familiar with how the GetFieldSchema works, but I assumed it had to do with the parent table.

 

Any help is appreciated rpx zip file attached.

Best answer by BenjaminCrisman

@nathantrauscht The OperationCD isn’t a selector, so there isn’t a way to force a selector type schema to the field.

When you check the field on the Production Order screen you can see it just a text entry field:

Just a side note regarding the function mentioned, in order for the relationship like  =Report.GetFieldSchema('AMProdOper.OperationCD,ProdOrdID') to work, there must already be an established dependent relationship between the fields being used, in this case OperationCD and ProdOrdID, which there is not currently such a relationship.

You could customize the AMProdOper table to establish a dependent relationship, but I don’t know if also making a selector for the OperationCD is possible, it’s outside my expertise and you’d need to ask the question in the development help topic section.

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

4 replies

Forum|alt.badge.img+1
  • Semi-Pro I
  • 177 replies
  • August 21, 2024

@nathantrauscht have you been able to resolve this?
I am also struggling to find the correct Set-up for an Operation CD Parameter


nathantrauscht
Semi-Pro II
Forum|alt.badge.img+1
  • Author
  • Semi-Pro II
  • 174 replies
  • August 21, 2024

I have not figured out how to make it a look up yet for users to browse for an operation like they can the production order type and production order number


Chris Hackett
Community Manager
Forum|alt.badge.img
  • Acumatica Community Manager
  • 2640 replies
  • September 10, 2024

Hi @nathantrauscht were you able to find a solution? Thank you!


BenjaminCrisman
Acumatica Employee
Forum|alt.badge.img+4
  • Acumatica Support Team
  • 631 replies
  • Answer
  • September 12, 2024

@nathantrauscht The OperationCD isn’t a selector, so there isn’t a way to force a selector type schema to the field.

When you check the field on the Production Order screen you can see it just a text entry field:

Just a side note regarding the function mentioned, in order for the relationship like  =Report.GetFieldSchema('AMProdOper.OperationCD,ProdOrdID') to work, there must already be an established dependent relationship between the fields being used, in this case OperationCD and ProdOrdID, which there is not currently such a relationship.

You could customize the AMProdOper table to establish a dependent relationship, but I don’t know if also making a selector for the OperationCD is possible, it’s outside my expertise and you’d need to ask the question in the development help topic section.


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