Why the join to APInvHed? Isn't that going to create duplicates due to the join you already have with APInvDtl? How are you going to filter?
Jim
________________________________
From:
vantage@yahoogroups.com [mailto:
vantage@yahoogroups.com] On Behalf Of Brian W. Spolarich
Sent: Monday, December 29, 2008 2:32 PM
To:
vantage@yahoogroups.com
Subject: RE: [Vantage] Three-Way Match BAQ
Starting with Part doesn't help me much since a good portion of this AP activity isn't involved with purchased parts. Basically I want to see 1) all Purchase Orders with their related 2) Receipts and 3) APInvoices, whether the PO has been received or invoiced or not.
-bws
--
Brian W. Spolarich ~ Manager, Information Services ~ Advanced Photonix / Picometrix
bspolarich@... <mailto:bspolarich%40advancedphotonix.com> ~ 734-864-5618 ~ www.advancedphotonix.com
From:
vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> [mailto:
vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ] On Behalf Of Jim Frice
Sent: Monday, December 29, 2008 1:59 PM
To:
vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
Subject: RE: [Vantage] Three-Way Match BAQ
What rows are being duplicated? Do you need to see invoiced and uninvoiced lines? We have a dashboard that only shows uninvoiced lines. I don't have any link to the APInv. I used the PartTran, Part, Vendor and RcvDtl tables only. We are on 8.03.404b and I could send it to you if it would help.
Jim
________________________________
From:
vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> <mailto:vantage%40yahoogroups.com> [mailto:
vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> <mailto:vantage%40yahoogroups.com> ] On Behalf Of Brian W, Spolarich
Sent: Monday, December 29, 2008 11:21 AM
To:
vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> <mailto:vantage%40yahoogroups.com>
Subject: [Vantage] Three-Way Match BAQ
In 8.03.405 I want to provide a BAQ that gives my AP folks quick
visibility into all of the info they need for reconciling payables < POs
(with date, vendor info, etc.), Packing Slips, and Invoices.
My query looks like this right now:
for each POHeader no-lock , each Vendor where (POHeader.Company =
Vendor.Company and POHeader.VendorNum = Vendor.VendorNum) no-lock , each
RcvHead outer-join where (POHeader.Company = RcvHead.Company and
POHeader.PONum = RcvHead.PONum) no-lock , each APInvDtl outer-join where
(POHeader.Company = APInvDtl.Company and POHeader.PONum = APInvDtl.PONum)
no-lock , each APInvHed outer-join where (APInvDtl.Company =
APInvHed.Company and APInvDtl.VendorNum = APInvHed.VendorNum and
APInvDtl.InvoiceNum = APInvHed.InvoiceNum) no-lock .
It unfortunately returns duplicates rows.
I want to be sure to return all data < all Purchase Orders, all Invoices,
and all Packing Slips, regardless of whether there�s related data (i.e. I
want to be able to see what�s been received but not yet invoiced to us,
etc.)
Does someone have a similar query that they use for this purpose?
[Non-text portions of this message have been removed]
[Non-text portions of this message have been removed]
[Non-text portions of this message have been removed]
--------------------------------------------------------------------------
WFCo's SmartMarkT RFID Named to 2008 Top Ten Products List
[Non-text portions of this message have been removed]