Displaying Serial Numbers on Shipment Confirmation

​@rkenna, If you add any detailed or line-level information to the group headers, it will group the detailed information and display only one record from that group. I recommend creating a separate detail section and replicating this to verify if the same issue occurs.

​@ranjithduraisamy72 

I did do this, but it gave me the same result unfortunately.

It seems like Lot serial attribute package published in your instance. Can you please share your xml file of your report? So, I can check, when I have time.

I’d check to see how you’ve joined the Shipment table to the Lot/Serial table - It seems like maybe you need to add an additional relationship about the order line or something similar.

It looks like you are using lotserialattribute package, that might be problem. you need to add the lot serial attribute table in your joint condition.

Hi ​@rkenna 

I tested on version 2024.R1 and it works fine. Please refer to the .rpx file I attached.

Best Regards,

NNT

Hi ​@nhatnghetinh 

Thank you for your response. The issue I see with what you sent is it is pulling in only one lot/serial, even though the quantity is more than one (see screenshot). 

If items are serialized, and there is a quantity of 5, then there will be 5 serial numbers listed. See my screenshot above in my initial post, but these are assigned on the Line Details. 

Thank you,

RJ

Thank you for sharing your solution with the community ​@rkenna!

Hello ​@rkenna ,

I followed the instructions exactly as described, but in my case the items on the Shipment Confirmation are shown twice when I enter the LOT number.

I’ve attached the file here. Would you be so kind as to take a look and let me know what might be causing this? Thank you very much in advance for your help.

Hi ​@pbavili ,

Can you please send me what the report output looks like, as well as some screenshots of the shipment including the line details? Feel free to message me directly should you not feel comfortable sharing on the community post.

-RJ

​@rkenna 
 

Hi rkenna,

Sorry to reach out out of the blue. I’m experiencing the same issue as pbavili described in the post

Below is what the output of the report currently looks like on my side.

Thank you for your help.

Hi ​@Bravo94 ,

It looks like this file has been altered significantly from the original Shipment Confirmation report, or it is a completely customized report built from scratch, so it is hard to tell what might be causing this not being familiar with the rest of the report. If you look at my screenshots above, you will see the LOT numbers are in the DetailSection where the line notes would be, and the other line information is in the group header Section 4. It looks like in your report there are 4 detail sections, and 2 of them are completely empty. 

Hi ​@rkenna ,

I have tried both options, with and without a subreport.

I would like to mention that I am doing this for set items. Each set consists of two items: one with a LOT number and one without.

When using the subreport, the LOT number does not appear. When not using the subreport, the Set-Item is displayed twice.

I have also attached the report and the subreport for your review. I would be very grateful if you could have a look.

Kind regards

Hi ​@pbavili,

Thanks for sharing these. Unfortunately, due to this appearing to be a fully customized layout report, I am not able to troubleshoot the issue as I do not have full knowledge of the layout and the groups inside of it. If it was an alteration of the standard Acumatica layout, I would be able to troubleshoot, but this is a customized layout. 

Apologies,

-RJ