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 Adding "selected" criteria to a report?
hi all, i've been adding a purchase receipt label report to the purchase order receipts window PO.30.20.00 through customisation and the action button.
my issue is getting it to print individual lines rather than every line on the receipt.
Through the action button parameters i put in receipt number and type for the report but is there a way to use the "selected row" option so that i only print the label for the stock item on the line selected?
any ideas or alternative suggestions would be appreciated.
Thanks in advance.
As far as I know, you won't be able to use the Selected field for this. The Selected field on the POReceiptLine records is only kept in memory, and not something the gets persisted to the database. To this end, you can interact with and use the field values only within the current screen. The changes will not be passed around or available to other screens, such as the Report. You'll probably notice that the Report doesn't even see the Selected field.
Adding your own boolean Selected user defined field would be the best way to handle this I think. All of the steps you'd need to follow would be low/no code and in the training course T190 for Customizations. Specifically you'd want to:
Add a boolean field to the POReceiptLine DAC and DB table.
Add the field to the Purchase Receipts -> Document Details grid and mimic the layout options of the original Selected field.
Then your values will be stored in the DB when you save and available to be used in a report.
I would be interested in seeing if there was a better way of interacting with the reports, but this is the most straightforward way I know to perform any kind of "selective" detail reporting.
hi Wyatt, thanks that's great! the workaround i've done (till i can try the above) is a side panel that links to a GI which has line specific information - in this case on the receipt it's the ReceiptSplitLine.SerialLot - in the GI, i've linked the serial through navigation to a form that contains the information i want on the label - inventory allocation details.....i've added an action to that form that points to a label that has prod description, serial and location...simple as that....lol