Here is a thought off of the top of my head, make OrderRel your master
table, then link to OrderDtl using Company, OrderNum and OrderLine. Now,
from OrderDtl you can link to RMADtl. You have two options here. If you
use an Inner Join then only records that have RMA detail will show. You
would then assume that if it isn't on the report then is hasn't had any
returns. Your second option is to use a Left Outer Join to RMADtl. This
will show all parts that have had shipments against them and then any that
have had RMA's issued.
OrderRel will be updated with shipped quantities in the JobShippedQty and
StockShippedQty fields. This will put all of your shipments on the report.
You can use OpenRelease to filter between open and closed (i.e. completely
shipped) order releases. Group by part.
Stay away from ShipDtl. You will need more joins to get the same
information.
Let me know if you have any more questions,
Ted Kitch
tedkitch@...
table, then link to OrderDtl using Company, OrderNum and OrderLine. Now,
from OrderDtl you can link to RMADtl. You have two options here. If you
use an Inner Join then only records that have RMA detail will show. You
would then assume that if it isn't on the report then is hasn't had any
returns. Your second option is to use a Left Outer Join to RMADtl. This
will show all parts that have had shipments against them and then any that
have had RMA's issued.
OrderRel will be updated with shipped quantities in the JobShippedQty and
StockShippedQty fields. This will put all of your shipments on the report.
You can use OpenRelease to filter between open and closed (i.e. completely
shipped) order releases. Group by part.
Stay away from ShipDtl. You will need more joins to get the same
information.
Let me know if you have any more questions,
Ted Kitch
tedkitch@...
On Wed, 18 Oct 2000 15:48:44 -0500, vantage@egroups.com wrote:
> Hello, all I have a quick question. Im trying to create a report that is
> based on a part # total qty shipped for a given time period plus the
amount
> of parts that have come back through rma dispositions. I',m basically
> looking to create a report that shows PPM per a part #. I'm close but i'm
> having a problem joining the shipdtl table to rma tables. When i run the
> report im getting duplicate entries for example i know that i ship part
xyz
> 3 times this month i also know that out of those three parts 2 came back
on
> the report it it showing six shipments?.
>
> Any help is appreciated.
>
>
>
> [Non-text portions of this message have been removed]
>
Ted Kitch
tedkitch@...
_______________________________________________________
Say Bye to Slow Internet!
http://www.home.com/xinbox/signup.html