Sage 100

We have a customer on Sage 100 2016 and want their lot numbers and serial numbers to print in a horizontal line instead of vertically under the line item. Has anyone changed the crystal form to show the serial numbers in a single row instead of vertically?

Check w/ @JimWoodhead

Yes , it is definitely possible. you need to use shared variables and concatenate then and print on the Group footer level. Let me know if you need a sample

@JimWoodhead - so like a manually running total? I would like to see a sample if you have one. Thanks in advance.

This 3m video shows how to do a subtotal, but you would use StringVars and keep adding on for each detail line. https://www.youtube.com/watch?v=v2NFzdOVz5M

Will do. To clarify. You suppress the serial number printing on the line level and instead add it to a ""serialno"" shared variable in a formula then print the variable in the group footer of the item. Note you will need to add a new grouping by item ( or line sequence) depending on your desired output

You can skip the Subreport stuff...

@SteveIwanowski - thanks I am checking this now. @JimWoodhead - I would still like to see the example when you find it.

Agreed @SteveIwanowski no subreports needed. I did it for a client already I will upload the form today.

Don't forget to wipe out the global variable when starting a new group.

I too am interested in doing this without a subreport. I've done it recently via a Subreport (for serial #'s) and it worked nicely. Of course upon doing it again for a different client (for both serial and lot), I'm having an issue, and I think the issue is lot # specific.

Here is a packing list I created with Concentrated Serial Numbers

thanks @JimWoodhead I just tested and it works exactly like my customer wants.

In case others can use it, I adjusted the Serial_Concat formula (below) in @JimWoodhead's .rpt so that it prints the qty in parentheses next to each lot/serial # (sample attached): shared Stringvar Serialnos; if {SO_InvoiceWrk.LotSerialNo} <>"""" and Serialnos="""" then Serialnos:={SO_InvoiceWrk.LotSerialNo} & "" ("" & totext({SO_InvoiceWrk.LotSerialQuantityShipped}, 0) & "")"" else if {SO_InvoiceWrk.LotSerialNo} <>"""" then Serialnos:=Serialnos+"", ""+{SO_InvoiceWrk.LotSerialNo} & "" ("" & totext({SO_InvoiceWrk.LotSerialQuantityShipped}, 0) &"")

Is there any way to fine tune it to differentiate between lot and serial #'s? SN's by their definition could only be one so it is redundant to display a (1) count for them.

@JeffSchwenk, I would expect that you could just include another if/then statement in that formula based on Tier Type.

Corrent @BrettZimmerman it is a matter of modifying the formula for what you what.