PO Audit Report

Yahoo Archive
1
Ok Troy,
Thanks to you and all who responded on and offline. I have it working ok
now, I think.
Thanks Sarah for sending me a report that I have modified for our use.

Jim Moore
GD-OTS


-----Original Message-----
From: Troy Funte [mailto:tfunte@...]
Sent: Wednesday, June 12, 2002 7:48 AM
To: Vantage
Subject: Re: [Vantage] PO Audit Report


Jim,
A simple three-table-join will give you the basic information.
POHeader to PODetail (by Company, PONum)..
PODetail to PORel (by Company, PONUm, POLine).

Your dollar amounts will be in the PODetail (UnitCost).
Your quantities are in the PORel table (RelQty, RecQty for ReleaseQty and
ReceivedQty respectively).

You can get the Extended quantity by multiplying the UnitCost by the RelQty,
and totals for a PONum by grouping by PONum and aggregating the UnitCost.

You can optionally add the Vendor table by joining with the Company &
VendorNum in the PODetail table.

Have fun storming the castle.

Troy
----- Original Message -----
From: Moore, Jim (Anniston)
To: 'vantage@yahoogroups.com'
Sent: Tuesday, June 11, 2002 4:20 PM
Subject: [Vantage] PO Audit Report


Can someone get me started or have a simple RB report that shows all po's
for 2001 and their total amounts.
I will be sorting / filtering by various dollar amounts.

Thanks,

Jim Moore
GD-OTS

Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must
have already linked your email address to a yahoo id to enable access. )
(1) To access the Files Section of our Yahoo!Group for Report Builder and
Crystal Reports and other 'goodies', please goto:
http://groups.yahoo.com/group/vantage/files/.
(2) To search through old msg's goto:
http://groups.yahoo.com/group/vantage/messages
(3) To view links to Vendors that provide Vantage services goto:
http://groups.yahoo.com/group/vantage/links

Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.


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



Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must have
already linked your email address to a yahoo id to enable access. )
(1) To access the Files Section of our Yahoo!Group for Report Builder and
Crystal Reports and other 'goodies', please goto:
http://groups.yahoo.com/group/vantage/files/.
(2) To search through old msg's goto:
http://groups.yahoo.com/group/vantage/messages
(3) To view links to Vendors that provide Vantage services goto:
http://groups.yahoo.com/group/vantage/links

Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/
2
Can someone get me started or have a simple RB report that shows all po's
for 2001 and their total amounts.
I will be sorting / filtering by various dollar amounts.

Thanks,

Jim Moore
GD-OTS
3
Jim,
A simple three-table-join will give you the basic information.
POHeader to PODetail (by Company, PONum)..
PODetail to PORel (by Company, PONUm, POLine).

Your dollar amounts will be in the PODetail (UnitCost).
Your quantities are in the PORel table (RelQty, RecQty for ReleaseQty and ReceivedQty respectively).

You can get the Extended quantity by multiplying the UnitCost by the RelQty, and totals for a PONum by grouping by PONum and aggregating the UnitCost.

You can optionally add the Vendor table by joining with the Company & VendorNum in the PODetail table.

Have fun storming the castle.

Troy
----- Original Message -----
From: Moore, Jim (Anniston)
To: 'vantage@yahoogroups.com'
Sent: Tuesday, June 11, 2002 4:20 PM
Subject: [Vantage] PO Audit Report


Can someone get me started or have a simple RB report that shows all po's
for 2001 and their total amounts.
I will be sorting / filtering by various dollar amounts.

Thanks,

Jim Moore
GD-OTS

Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must have already linked your email address to a yahoo id to enable access. )
(1) To access the Files Section of our Yahoo!Group for Report Builder and Crystal Reports and other 'goodies', please goto: http://groups.yahoo.com/group/vantage/files/.
(2) To search through old msg's goto: http://groups.yahoo.com/group/vantage/messages
(3) To view links to Vendors that provide Vantage services goto: http://groups.yahoo.com/group/vantage/links

Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.


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