Sage 100

Printing invoice tracking numbers. I'm doing this with a subreport on SO Invoices. I link to SO_InvoiceTracking. This works fine the first time through. However, if a user goes to reprint an invoice from history the tracking number is not there. Presumably, this is because once the invoice is posted SO_InvoiceTracking is emptied and the contents move to AR_InvoiceHistoryTracking. Am I missing a more elegant way to do this or do I need to create a second subreport based on AR_InvoiceHistoryTracking and just presume that one or the other subreport values would print but both wouldn't hold values at the same time?

Update: Added a second subreport using the AR_InvoiceHistoryTracking. That seemed to work. I don't think there would be an instance when the two would both be populated so I just put one right next to the other with a slight overlap.

SOInvoiceWrk contains tracking numbers, and that's what I used for both active and history invoices.

Perfect! I knew I was overlooking something. Thanks!

@WayneSchulz, are you able to get more than 4 tracking #'s to print. Mine still shows just the first four and then ""etc."".

In this specific case I don't think we are using more than 2-3 tracking numbers so I haven't noticed.

If you're okay with only showing _up to_ the first four tracking #'s and ""etc."" at the end, you can just use the 'Tracking Numbers' field in the S/O Invoice Wrk file (which I think also works if printing from Invoice History). Otherwise, for S/O Invoice Entry printing, create a subreport for the so_invoicetracking file, and enable the 'Format with multiple columns' setting on the subreport Details section. Then create a 2nd subreport, for the ar_invoicehistorytracking file, enable 'Format with multiple columns', and stack this subreport on top of the other subreport.