In order to allow me to focus on Consulting (click here) and Courses (click here), I continue to review all posts here in the Forums, but, in general, I'm only personally responding to posts that I mark as #AcumaticaTnT (click here). For Questions (click here), others may respond, or you can post over at Community.Acumatica.com (click here).
Questions Parameters for a report to print from Kit Assembly
I have a client that manufactures products and packages these in Cartons. As they roll off the production line they are stacked onto a pallet. When the pallet is full they generate a new lot from the kit assembly and then print a label to go onto the pallet. They want to print each label as the pallet is wrapped rather than in bulk at the beginning or end of the production run so that they have the time that the label was printed. There are three pallet wrapping stations so there could potentially be three orders being processed at the same time.
I have written the report to print the pallet labels using the Production Order number and Lot / Serial number as input parameters and it runs fine. What I want now is to add logic to the parameters.
I already have the list of values populating correctly for the kit assembly using the following view name - =Report.GetFieldSchema('INKitRegister.RefNbr'). I would like to restrict this list to only Kit Assemblies that have a Balanced status as there will be several in the system for future orders that will be on hold and plenty that are Completed. I would also like the Default Value for the parameter to be the largest value that has a status of Balanced - this I have not been able to achieve. I have tried using the Max( ) function in the Default Value field but this gives me a runtime error.
The second parameter can either be the line number or the lot/serial number. I can't get the list of values to default here at all - for the view name I have tried =Report.GetFieldSchema('INKitTranSplit.LotSerialNbr.RefNbr') , =Report.GetFieldSchema('INKitTranSplit.LotSerialNbr.RefNbr') , =Report.GetFieldSchema('INKitTranSplit.LineNbr.RefNbr'). I would like the list of values to be restricted to the RefNbr selected in the previous parameter and also default to the largest number in the selection.
Can anyone help me with the syntax for this? Is it even possible?
Thanks in advance... John