OK. My lack of knowledge is really going to show here. For reference, we use Sage 100 2019 Manufacturing.
I have a highly customized Picking Ticket created in Crystal Reports. We are a manufacturer, and when a customer orders from us, the Picking Ticket will display, on a new line, each Item Code purchased. For any of those items, we may have multiple LOT numbers. Above the Item Code we have a UDF that displays industry standard Hazardous Material Codes. However, if there are multiple LOT Numbers for a single Item Code, the UDF will only print above the first LOT.
We use these Picking Tickets as Bills of Lading for logistics companies. Occasionally, a company will reject the Picking Ticket and tell us we need to display the UDF above each LOT Number, even if it is of the same product.
What I would like to do is to find a way to force the UDF to print directly above each Item Code even if the item is a duplicate. I want it to print based on LOT Number rather than the Item. Here is an image that hopefully describes what I want to do. Thanks in advance for any assistance!