Skip to main content
Answer

Lot / Serial Number not populating in the report parameter?

  • September 20, 2023
  • 2 replies
  • 230 views

Forum|alt.badge.img

I want to populate  [AMMTran.LotSerialNbr] 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. 

Best answer by BenjaminCrisman

@Rajginoya There is no schema for the Lot/Serial number, so when you use the function to ‘GetFieldSchema’ there isn’t anything to display.

You would need to maybe create a custom selector to show the Lot/Serial as a selector lookup, otherwise you would need to enter one manually

 

2 replies

BenjaminCrisman
Acumatica Employee
Forum|alt.badge.img+4
  • Acumatica Support Team
  • Answer
  • September 26, 2023

@Rajginoya There is no schema for the Lot/Serial number, so when you use the function to ‘GetFieldSchema’ there isn’t anything to display.

You would need to maybe create a custom selector to show the Lot/Serial as a selector lookup, otherwise you would need to enter one manually

 


Forum|alt.badge.img
  • Author
  • Jr Varsity III
  • October 11, 2023

=Report.GetFieldSchema('UsrInventoryLotSerialContainer.LotSerialNbr,InveID')