purchase orders
593042Aug 29 2007 — edited Sep 17 2007I am having problems writing a disco report (table) to show all invoices received from a particular supplier together with all purchase orders matched to that invoice.
When I run the report it lists each invoice received between date parameters but lists every purchase order ever received for that supplier (INCLUDING THE ACTUAL PURCHASE ORDER).
e.g. one supplier had one invoice dated 01-APR-2007 which was matched to one purchase order but my report lists all 40 purchase orders which have ever been raised for that supplier.
The tables I am using are:
1. PO VENDORS. SUPPLIER ID (SUPPLIERNAME; SUPPLIER NO.)
2. AP INVOICES. VENDOR ID ( INVOICE NO.; INVOICE DATE; INVOICE AMOUNT£)
3. PO HEADERS. VENDOR ID (PURCHASE ORDER NO.)
THE PO HEADERS TABLE IS LINKED TO THE PO VENDORS TABLE BY SUPPLIER ID.
Can anyone help?
Thanks in advance,
FIN (29AUG2007)