Combining Inventory Item Serial Numbers on Sales Order Line  Topic is solved

Support for Crystal Reports within Jiwa.

Combining Inventory Item Serial Numbers on Sales Order Line

Postby Iain » Fri Mar 09, 2018 12:48 pm

Hi,
The Jiwa Sales Order Crystal Report MNT30000 - Invoice.rpt prints serial numbers on separate lines. ie. If I sell ten of one item I get one line for the the sale and another ten lines for the serial numbers (see attachment).
How can I combine the serial numbers into one line that grows if necessary? Preferably this would be via a formula that concatenates SO_LineDetails.SerialNo records.
Cheers, Iain
Attachments
SO Extract - serial numbering.jpg
Iain
I'm new here
I'm new here
 
Posts: 1
Joined: Wed Feb 04, 2015 8:31 am

Re: Combining Inventory Item Serial Numbers on Sales Order L  Topic is solved

Postby Scott.Pearce » Fri Mar 09, 2018 1:06 pm

Use a couple of formulae in Crystal. One to build the concatenated list of serial nos (UpdateSerialConcatenation), and another to print out the results (ShowConcatenatedSerials). UpdateSerialConcatenation needs to be placed in a details section, supressed, and perhaps modified to reset the string on change of InvoiceLineID.

UpdateSerialConcatenation
Code: Select all
WhilePrintingRecords;
StringVar ConcatenatedSerials;

If ConcatenatedSerials <> "" Then
    ConcatenatedSerials := ConcatenatedSerials + ", ";

ConcatenatedSerials := ConcatenatedSerials + {SO_LineDetails.SerialNo};



To print the output:

ShowConcatenatedSerials:
Code: Select all
WhilePrintingRecords;
StringVar ConcatenatedSerials;


Have a play around with the above approach and see what you can come up with. If using MNT30000 - Invoice.rpt, you may need to delete the existing SerialNumbers subreport, and link SO_Lines and SO_LineDetails into the main report for these formulae to work.
Scott Pearce
Senior Analyst/Programmer
Jiwa Financials
User avatar
Scott.Pearce
Jiwa Senpai
Jiwa Senpai
 
Posts: 494
Joined: Tue Feb 12, 2008 10:27 am
Location: North Sydney, New South Wales
Topics Solved: 158


Return to Crystal Reports

Who is online

Users browsing this forum: No registered users and 1 guest

cron