I have a report style built off of the Sales Order Acknowledgement form that needs to return the expiration date of a part lot, which is not part of the data definition out of the box.
I have a custom field that stores the Lot Num. What I was attempting was to create a stored procedure that uses company, part num, and lot num variables to return the expiration date of that part lot.
I ran into trouble when attempting to utilize the report fields as parameters. I wanted the report to pass in its native company, native Part Num from the line, and custom Lot Num fields into the report on a per-release level, but the report said I cannot use fields as parameters.
Any idea how I might accomplish this task?