Skip to main content
Answer

Parameter Lookup OperationCD - GetFieldSchema

  • June 13, 2023
  • 4 replies
  • 235 views
nathantrauscht
Semi-Pro II
Forum|alt.badge.img

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.

1 Attachments

4 replies

K
Semi-Pro II
Forum|alt.badge.img+1
  • krausef77
  • Semi-Pro II
  • 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
  • nathantrauscht
  • Author
  • Semi-Pro II
  • 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
Chris Hackett
Community Manager
Forum|alt.badge.img
  • Chris Hackett
  • Acumatica Community Manager
  • September 10, 2024

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

Chris ~ Let us know how we're doing: https://forms.office.com/r/xmJUdZ1QE5 - A member helped you, please *Like* their post. A member provided an answer to your question, please mark it as *Best Answer*.
BenjaminCrisman
Acumatica Employee
Forum|alt.badge.img+4
  • BenjaminCrisman
  • Acumatica Support Team
  • 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.

Chris Hackett
Terms & ConditionsCookie settingsAccessibility statement
About Acumatica ERP system
Acumatica Cloud ERP provides the best business management solution for transforming your company to thrive in the new digital economy. Built on a future-proof platform with open architecture for rapid integrations, scalability, and ease of use, Acumatica delivers unparalleled value to small and midmarket organizations. Connected Business. Delivered.
© 2008 — 2024  Acumatica, Inc. All rights reserved