• Search Forums
    Advanced Search
Prev
Next
Forums Performance Management Lawson Business Intelligence/Reporting/Crystal

POAGMTPART

 1 Replies
 2 Subscribed to this topic
 24 Subscribed to this forum
Sort:
Author
Messages
NatalieD
Veteran Member
Posts: 53
Veteran Member
New Poster
New Poster
Congrats on posting!
11/3/2016 1:36 PM
Hello - I'm trying to build a crystal report that will show the contracted price for an item based on the IC12 location company. We have instances where we have more than one vendor agreement based on one for a specific participant company. When I pull the contract tables in (POVAGRMTHD, POVAGRMTLN and POAGMTPART) they report duplicates the item for every possible contract. I'm trying to narrow down to have it only show the vendor agreement based on the location company using the agreement participant and priorities. Does anyone had this issue with duplicate lines in a vendor agreement report?
Joan Herzfeldt
Veteran Member
Posts: 74
Veteran Member
11/3/2016 2:41 PM
Hi Natalie - I don't know about vendor agreement reports specifically, but usually when I get multiple records it has to do with the linking of the tables. How are you linking the tables? I reviewed the table definitions and I would link the header table to the line table and the line table to the Agmt part table. I'm guessing you are using the header table to link to agmt part table, but I didn't test my theory. I've attached a document that shows a little more detail then I wrote. Hope this helps.
Attachments