Sage 100

v2017 Several item codes have a type general alias item code. How do you get the general type alias item code to print on a purchase order form? There is always only one alias item code per item.

Seems like you could use a formula if the Alias type = ""G"" then pull the value. At minimum you could use a sub-report to pull in the value. Your sub-report would filter for alias type G.

Formula alias type = ""G"" I'm pretty sure

I have tried the formula and I get duplicate lines. I believe it is because there isn't a good way, or I don't know the correct way to link the tables. I'm thinking the sub-report may be the easiest. This would seem like a reasonably common request from users. I thought maybe one of the 90 Minder's had a clever solution in production. It would be an easy link if every alias was linked to a vendor or a customer, but that would require an immense amount of work populating the aliases.

Isn't the alias field available in the file you are using?If so just do a suppress on alias type not equal to G.

Also, make sure the item only has ONE General alias. Back in the day, a client complained that the wrong alias was printing. Turned out they had multiple ones.

Alias field is not in the PurchaseOrderWrk file used to print Purchase Orders. Link to the IM_AliasItem file to get the Alias and type.

Just got to look at that file and saw that it wasn't in that file sorry ! I must have done it by linking or sub report.

Create a UDF and add it to the PO WRK file....

@JeffSchwenk I like that idea.