Solved

Lot / Serial Number not populating in the report parameter?

  • 20 September 2023
  • 2 replies
  • 61 views
R
Rank
Userlevel 1
Badge

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. 

icon

Best answer by BenjaminCrisman 26 September 2023, 18:38

View original

2 replies

BenjaminCrisman
Rank
Userlevel 7
Badge +4

@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

 

R
Rank
Userlevel 1
Badge

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

Reply


Terms & ConditionsCookie 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 — 2023  Acumatica, Inc. All rights reserved