Purchase Order Form Prints Duplicate Lines

SUGGESTED

We have products that we purchase from multiple vendors. We have the Vendor codes and descriptions set up as Vendor Alias' in Item maintenance. When we make a PO for a vendor and enter an item that has multiple Alias codes, it will actually print out a duplicate line item with the other vendor code(s). Our sage partner who recently set-up this form told us that we can't have multiple vendor Aliases for a single product. They said they couldn't do anything to print the form. Is this really true? I can't see this as being a possibility. It's completely nonsensical for it to output these duplicate lines with the incorrect vendor codes. 

PO for Vendor A

[Alias Code for Vendor A] [Our Item Code] [Descpriton] [Etc] ........... 3

[Alias  Code for Vendor B] [Our Item Code] [Description] [Etc] .......... 3 

I read some of the other questions here and some people suggested that it had to do with Item Code Wrk and ItemAlias Fields, it seems that the only thing being linked form the ItemAlias field is "Alias Item Description," is this our problem? I'm not good at Crystal, so if anyone can give me watered down instructions that would be very helpful. It's a shame that our Sage partner couldn't seem to figure something so simple out. 

Parents Reply
  • 0 in reply to Kevin M

    Ok I understand subreport now. So should I be using the subreport ONLY to link the "Alias Description," which is being linked from the "Alias Table" or should I use the subreport for both the Alias Description and the Alias Vendor code (which I also assume has multiple matches) and is currently being linked from the Wrk Table. Thanks 

Children