PO to Invoice? Blank Title 58627

Yep, that was the magic table. All of the information we need is
there.

Thanks Jim! You really helped us out.

Bruce

--- In vantage@yahoogroups.com, "Jim Frice" <Jim.Frice@...> wrote:
>
> Why not use the APInvcDtl it has probably all the information you
need.
> It is a pretty easy report to put together in Report Builder. What
two
> tables due you really want? If you have already gone from Po to
Receipts
> using the PO number that is also available on the APInvcDtl table.
Or
> use the PackSlip from the Receipt table to the APInvcDtl table.
>
> Jim
>
>
> ________________________________
>
> From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com]
> On Behalf Of brucewbrannan
> Sent: Monday, August 20, 2007 4:21 PM
> To: vantage@yahoogroups.com
> Subject: [Vantage] PO to Invoice?
>
>
>
> We have a project manager who needs to print POs to Invoices.
We
> can
> build the links from POs (stuff we're buying) to Receipts
(stuff
> we're
> receiving) and the Receipts does contain the Invoice numbers.
> But I
> can't seem to link the Invoice numbers from the Receipts
tables
> to the
> Invoice tables. Any suggestions or has anybody built this
report
>
> before? We are still on 6.1, Progress Db. If you go to the
> receipt
> tracker it clearly shows the PO, Receipt, and Invoice
> information all
> in one nice screen but we really need an export or report to
> compile
> this information together. Canned Vantage has no way of
> reporting this
> information.
>
> Thanks!
>
> Bruce Brannan
> Engineered Products Department
>
>
>
>
>
>
>
> [Non-text portions of this message have been removed]
>
We have a project manager who needs to print POs to Invoices. We can
build the links from POs (stuff we're buying) to Receipts (stuff we're
receiving) and the Receipts does contain the Invoice numbers. But I
can't seem to link the Invoice numbers from the Receipts tables to the
Invoice tables. Any suggestions or has anybody built this report
before? We are still on 6.1, Progress Db. If you go to the receipt
tracker it clearly shows the PO, Receipt, and Invoice information all
in one nice screen but we really need an export or report to compile
this information together. Canned Vantage has no way of reporting this
information.

Thanks!

Bruce Brannan
Engineered Products Department
Why not use the APInvcDtl it has probably all the information you need.
It is a pretty easy report to put together in Report Builder. What two
tables due you really want? If you have already gone from Po to Receipts
using the PO number that is also available on the APInvcDtl table. Or
use the PackSlip from the Receipt table to the APInvcDtl table.

Jim


________________________________

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com]
On Behalf Of brucewbrannan
Sent: Monday, August 20, 2007 4:21 PM
To: vantage@yahoogroups.com
Subject: [Vantage] PO to Invoice?



We have a project manager who needs to print POs to Invoices. We
can
build the links from POs (stuff we're buying) to Receipts (stuff
we're
receiving) and the Receipts does contain the Invoice numbers.
But I
can't seem to link the Invoice numbers from the Receipts tables
to the
Invoice tables. Any suggestions or has anybody built this report

before? We are still on 6.1, Progress Db. If you go to the
receipt
tracker it clearly shows the PO, Receipt, and Invoice
information all
in one nice screen but we really need an export or report to
compile
this information together. Canned Vantage has no way of
reporting this
information.

Thanks!

Bruce Brannan
Engineered Products Department







[Non-text portions of this message have been removed]