I have a Crystal Report in which I am displaying a list of Items from the ITEMMAST table. I need to display the active Vendor (Name and Number) for each Item. I know that the vendors are listed in the APVENMAST table; however, my report is retrieving the wrong Vendor.
The cause of the problem could be the fact that there are multiple contracts for the Item. If this is the case, could I retrieve the correct Vendor by looking at the POVAGRMTLN table and retrieving the contract for the Item that has not expired (EXPIRE-DT of ’01-JAN-00’)?
Or, the cause could be the POITEMVEN table that I am currently using to retrieve the Vendor info. If this is the case, could I look at the R-STATUS in order to determine which Vendor to retrieve? If so, which status should I use?
Thanks