Sage 100

v2017 STD - Client uses the general IM Alias to store their UPC #. They also use the customer specific alias to store their customer item code. Customer wants both fields to print on the picking sheet. In looking at the order entry grid, there is only one alias field available and it appears to display the general alias unless there is a customer specific one for that item, then the customer alias appears. Looking behind the CO panel for so detail, there does not appear to be a link to the IM alias table nor do I see one in UDF maintenance for SO detail. So the question is how can I get both aliases to appear so I print them on the picking sheet? Just add the IM_alias table to the picking sheet form and be done with it? I would like to explore adding the field to SO detail table, but not getting good vibes about the possibility. TIA

Do you mean you hope to be able to map the alias field from the im_aliasitem table to SO_salesorderdetail / so_pickingsheetwrk? That is not going to happen. Even if you could I believe CO only allows for one record type to be passed. I would join IM_aliasitem to so_pickingsheetwrk.

You could pull the general alias item in via linking as @DougHiggs suggests, then create a subreport for the customer alias item linking the item and customer number... I think.

Yes, @DougHiggs mapping was on my mind. Looks like I will have to change course as you and @MichelleForsey suggest and just add the alias table to the picking sheet RPT. Not sure how I would specify the G record only though.

Have you considered creating a sub-report passing in the pertinent data and reporting on the Alias table? I have had pretty good luck with this technique

@JeffSchwenk If you add the Alias in a separate detail section, you should be able to suppress based on the type. Then, if need be, you can overlay the two sections so they appear as one line.

I would do as @MichelleForsey and @DougHiggs suggest - add the the IM_Alias table to the wrk table, linking item and customer number then add a subreport pulling only the general alias. (Don't use the alias in the wrk table at all.)