Building Reports off the Packages Tab in Shipments
I'm currently working on building dynamic carton labels that pull data from the packages tab in the Shipments work space. One of the problems I'm having is getting the page to reset on a new carton. The report header is printing on every page(as it should) but the details section skips the first page and collects all data on the remaining pages. I.E., a shipment has 3 cartons. Carton 1 has 15 of X widget, 2 has 22 of Y widget and 3 has 10 of Z widget packed inside. The report is reading as label 1 - just header(SO #, PO #, description, customer); label 2 - header and 15 of X widget, 22 of Y widget; label 3 - header and 10 of Z widget. The report is pulling the correct # of cartons from the shipment and creating the correct # of labels. But the details are not mapping the contents for Box 1, Box 2, Box 3.
Let me know if I can give more detail. I tried to make it concise, but it may sound scattered.
Thanks, cheers and stay safe.
Sounds like you're close. If the label header info is in the page header section then all you should need is a page break in the detail section.
Include some screenshots or samples of your report if it's more complicated than that.
I tried page breaks, but the pages are defined by how many cartons are on the shipment. With a page break, a shipment of 3 cartons generated 5 labels, one for the 'front page' and broken pages for the remaining cartons.
I've attached the rpx file if anyone has some time to look through it.
Here is a live example. The stock items are also tripling, but I think I have a fix for that.
I would try consolidating your two groupings into just one (SOShipment.ShipmentNbr, SOOrder.SOOrderNbr, SOPackageDetail.LineNbr). The joins also seem odd to me, but I use a third-party packing solution and don't have experience with item-level package detail in Acumatica or data to play with.
UPDATE: I managed to get the report working right. And have published it! I added an action to the Shipment>Reports tab on the form, BUT it runs the report without parameters, effective returning an empty report. I noticed on the 'Shipment Confirmation' report the action type is 'Graph Action' and the action on my new report is 'Run Report'. Anyone know how I can add the box label report as a graph action? Or of another way to pull the data for the selected shipment when using the report tab?
Screenshots are for context.
There are two ways to add a report to a screen:
1. Automation Steps (the old way) where you don't control the parameters.
2. A Customization Project (the new way) where you do control the parameters.
Which way did you use?