I'm wondering if there's a Gridview file that I can use to look-up a vendor invoice that we have entered into AP that will show the vendor number, the total dollar amount due of the invoice, the date, AND the job we applied that invoice to. I'm asking because we have entered incorrect vendor numbers on various invoices and can't quickly find the actual hard copy of the invoice since it's been filed in the correct vendor file, not the vendor file that we mistakenly entered into Adagio. Locating the correct vendor would be easier if we could use the job cost it was applied to - would narrow our choices down quite a bit. I have been trying but I can't find a composite that works, or even a way to use 2 reports and link them together. I'm stumped.

Hi Karen,

In Adagio Payables, you assign the job/phase/category codes on the detail of the vendor invoice. Thus after the invoice is posted, the AP current transaction file does not maintain the detailed information (including the job number). So no reporting tool would be able to use the AP Transaction file to get the job number.

You could use the AP invoice posting journal as long as it hasn't been purged. This is about the only place to get the relevant data.

When the invoice is retrieved into JobCost from Payables, neither the vendor code nor the invoice number go with it. Thus the report could not be based on a JobCost data file.

Would it be possible to include the vendor code and invoice number in job cost when the invoice is retrieved? Perhaps part of your next service pack...which I am hoping will be soon in order to address other issues we have?