Can someone please tell me how to easily find a vendor invoice detail lines from a PO number?
The reason why i ask is that both the window through the "Receipts" button in Purchase Order History Inquiry and Receipt History Inquiry doesn't seem to capture any PO detail lines when the invoices are received through PO Receipt of invoice. So when an invoice is entered through Receipt of Invoice, ANY inquiry from PO module only shows the invoice number for a given PO without any details. So if I need to find a particular item's invoiced value, we have to first use PO History Inquiry to find the invoice numbers, and then use AP Invoice History Inquiry to check ALL invoice numbers to until we find the right invoice that contains the item we are after. This is very inefficient.
On the other hand, when the invoice number is entered during Receipt of Goods entry, then both the invoice number and the line item show up. We have to use PO Receipt of Invoice since some shipments will take months to arrive and a prepayment must be made. So recording the invoice numbers in Receipt of Goods entry isn't realistic.
What are my options?? Or am I missing something?
Ken
