We have a number of customers who require their item# to print on the invoice and packing slip and I'm running into performance issues when trying to get a customized SO Invoice Print form to work.  I've added those customer specific item #s to the IM_AliasItem table.

I saw that AliasItemNo is a field available in the SO_InvoiceWrk file to add to the Crystal Report, but I only want it to print if the Alias Item type = "C" (customer).  I added the IM_AliasItem table to the form and suppressed printing of the AliasItemNo if the Type was "G" or "V,"  which works great - BUT I had to add IM_AliasItem as a left outer join as items without any data in the IM_Alias table would not print at all.   I think the left outer join is really slowing down the processing as it will take 5 minutes to print a smaller (30 or so) batch of invoices, and I don't want to bog down our system during our busy season.

Does anyone have any suggestions on how to remedy this issue?   Could I add a UDF to SO_InvoiceWrk that sources from IM_AliasItemType?

We are on MAS 200 v 4.5 / Crystal Reports XI

Thanks,

Jessica