Skip to main content
Question

Display Lot/Serial Numbers in a separate list without repeating item lines in the delivery note

  • November 28, 2025
  • 1 reply
  • 20 views

Forum|alt.badge.img

Hello everybody,

I have the following scenario:

A set consists of two components:

  • a certificate,

  • a 20-item box, which can contain one or more lot/serial numbers.

In the delivery note, the information should be displayed as follows:

  1. Line for the certificate

  2. Line for the item (20-item box)

  3. Below the item line, a list of all associated lot/serial numbers should appear – regardless of whether there is one or multiple lots.

The lot/serial numbers come from the field:
[SOShipLineSplit.LotSerialNbr]

Problem:
When I use a separate detail section for the lot/serial numbers in the report, Acumatica repeats the item line for each lot/serial number. This causes duplicate or multiple item lines, which is not desired.
I need a way to display the item line only once and list all associated lot/serial numbers below it in a single consolidated view.

Question:
What is the recommended approach or report setting to display the item line only once and show a consolidated list of all lot/serial numbers from the SOShipLineSplits underneath?

Thank you for your support!
Pantea
 

 

1 reply

bwhite49
Captain II
Forum|alt.badge.img+10
  • Captain II
  • December 1, 2025

In this case, you might look into creating a sub report. A sub report is a separate report that you can pass parameters to and display information based on those parameters. In this case you might use the ship line nbr and the lot serial number as parameters in your sub report.

The end result will be a list of tracking numbers under the lot number, without any duplication.

Here is a video that looks helpful