Skip to main content
Question

Operation ID not populating in the report parameter

  • September 20, 2023
  • 3 replies
  • 77 views
R
Jr Varsity III
Forum|alt.badge.img

 

 

I want to populate  [AMMTran.OperationID] as the report parameter. I have added the parameter in the schema but nothing is showing up on the report screen.

This is how I see this empty selector. 

3 replies

palbores
Jr Varsity I
Forum|alt.badge.img+1
  • palbores
  • Jr Varsity I
  • 42 replies
  • September 20, 2023

Hi @Rajginoya, have you tried using this OrderType instead of MaterialNo? Operation ID will depend on the OrderType and ProOrderID for it to get/populate the related data.

=Report.GetFieldSchema('AMMTran.OperationID, OrderType, ProdOrdID')

~ Phil
hkabiri
Chris Hackett
2 people like this
  • hkabiri
    hkabiri
  • Chris Hackett
    Chris Hackett
R
Jr Varsity III
Forum|alt.badge.img
  • Rajginoya
  • Author
  • Jr Varsity III
  • 17 replies
  • September 27, 2023
palbores wrote:

Hi @Rajginoya, have you tried using this OrderType instead of MaterialNo? Operation ID will depend on the OrderType and ProOrderID for it to get/populate the related data.

=Report.GetFieldSchema('AMMTran.OperationID, OrderType, ProdOrdID')

Report Parameter
Screen

 

Chris Hackett
Community Manager
Forum|alt.badge.img
  • Chris Hackett
  • Acumatica Community Manager
  • 2783 replies
  • November 2, 2023

Hi @Rajginoya 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*.

Reply


Most helpful members this week

Terms & ConditionsCookie settings

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
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