We have a report that prints the pack list along with Lot Serial Nbr. Currently the items on a shipment are repeating multiple times because the items are located on multiple locations.
How can we display items along with lot serial number, total shipped qty but not have it split these lines based on location?
We currently have it grouped by Sales Order Nbr and Order type.
I have also attached the rps file of the report for reference. Thank you for the help in advance!
Best answer by Robert Sternberg
Hi
Please take a look at the attached, I have highlighted the section footer in green which only prints once per lot/serial group. Notice how the detail section prints for every shipment line.
To finalize this solution you will need to:
+7Hi
| Inventory ID | Qty | Lot/Serial Nbr |
|---|---|---|
| Invt001 | 3 | 0001, 0002, 0003 |
If not could you provide a quick mockup similar to the above of what you are looking for?
Thanks!
Hi
thank you for your response. It should look something like this below:
| Inventory ID | Lot Serial Nbr | Shipped Qty |
|---|---|---|
| 123 | 001 | 463 |
| 123 | 002 | 500 |
| 456 | 003 | 412 |
| 456 | 005 | 320 |
| 897 | 004 | 140 |
+7Please try adding a group by of [SOShipLineSplit.LotSerialNbr]
If you need help please upload an rpx file rather than an rps file. More info on this here - https://www.augforums.com/acumatica-rps-versus-rpx-file-types/
Hi
We did try grouping by lot serial nbr but that did not work. Is there a different way we can try? I have attached the rpx file below. The reason why they are duplicating is because of different locations
Below is a snapshot from our database. We also grouped by Lot Serial, Location and Inventory ID on the report and that did not work either.
thank you!
+7Hello, thanks for the file, you are seeing this because you are still reporting in the detail (ungrouped section) of the report, if you move your fields into a grouped section you will only see one result line per group. Do not put anything in the detail section unless you want it to print ungrouped results.
Hi
+7Hi
Please take a look at the attached, I have highlighted the section footer in green which only prints once per lot/serial group. Notice how the detail section prints for every shipment line.
To finalize this solution you will need to:
Hi
This was an excellent example to help me solve a similar problem on T&M project invoices - thank you.
Hi
| Inventory ID | Qty | Lot/Serial Nbr |
|---|---|---|
| Invt001 | 3 | 0001, 0002, 0003 |
If not could you provide a quick mockup similar to the above of what you are looking for?
Thanks!
Hi
+7Hi
Please create a new variable in the details section. Call the new variable $CSVLotSerial, for the value formula use Concat($CSVLotSerial, ‘, ’, [SOShipLineSplit.LotSerialNbr]) with a reset group of ItemLot and a reset expression of =’’.
Replace the field where you would like to see the CSV values with $CSVLotSerial
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
