Parts NOT on Part Master

Yahoo Archive
1
Glad it worked.



To “limit printing”, in your BAQ, the phrase builder tab, click on the Part table, and as a new criteria (bottom of the screen) for a blank PartNum. You can filter in Crystal too, but doing it in a BAQ will give you better performance.



Thanks,

Brian.



From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of Karl Dash
Sent: Tuesday, October 30, 2012 1:08 PM
To: vantage@yahoogroups.com
Subject: Re: [Vantage] Parts NOT on Part Master





Brian, et al,
This is what worked. The Crystal report lists all parts on the JobProd but where there is no match to Part, the part number is blank. In order to reduce the number of pages, I may want to limit printing to only those parts that have a blank Part.partnum.

Thanks again -Karl

________________________________
From: Brian Roberts <broberts@... <mailto:broberts%40gfxltd.com> >
To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
Sent: Monday, October 29, 2012 1:46 PM
Subject: RE: [Vantage] Parts NOT on Part Master


Assuming you've made a BAQ report, and you clicked "outer join" in the
BAQ, then you want the following in Crystal: left outer join, not
enforced. Make sure the arrows are going the right way, in Crystal
*from* the parent table (JobProd) down to child (Part) - this is the
visual reverse of the arrows in the BAQ phrase builder.

Brian.

From: mailto:vantage%40yahoogroups.com [mailto:mailto:vantage%40yahoogroups.com] On Behalf
Of Karl Dash
Sent: Monday, October 29, 2012 4:27 PM
To: Vantage Group
Subject: [Vantage] Parts NOT on Part Master

All,
We build either turnkey or consignment assemblies. Historically we
have not put the customer's part number on the Part master for
consignment assemblies. We want to do that now. So, I am looking for all
parts that are on the JobProd table but which are NOT on the Part
Master. I have created a Crystal report that has those two tables
attached to each other but am uncertain on what the join, enforce and
link types need to be to accomplish this.

Thanks,
-Karl

[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]





[Non-text portions of this message have been removed]
2
All,
  We build either turnkey or consignment assemblies. Historically we have not put the customer's part number on the Part master for consignment assemblies. We want to do that now. So, I am looking for all parts that are on the JobProd table but which are NOT on the Part Master. I have created a Crystal report that has those two tables attached to each other but am uncertain on what the join, enforce and link types need to be to accomplish this.
Â
Thanks,
-Karl

[Non-text portions of this message have been removed]
3
Off the top of my head...dump your part table in an excel file...dump your job parts in another excel file then see where they don't match....





M. Manasa Reddy
manasa@...<mailto:manasa@...>
630.806.2000 x1515

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of Karl Dash
Sent: Monday, October 29, 2012 3:27 PM
To: Vantage Group
Subject: [Vantage] Parts NOT on Part Master



All,
We build either turnkey or consignment assemblies. Historically we have not put the customer's part number on the Part master for consignment assemblies. We want to do that now. So, I am looking for all parts that are on the JobProd table but which are NOT on the Part Master. I have created a Crystal report that has those two tables attached to each other but am uncertain on what the join, enforce and link types need to be to accomplish this.

Thanks,
-Karl

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



[Non-text portions of this message have been removed]
4
You could also dump both to Crystal and do a formula to suppress where they match. Otherwise a vlookup between two Excel files, again filtering out the ones that don't have a valid lookup would work.

Ken

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of Manasa Reddy
Sent: Monday, October 29, 2012 2:33 PM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Parts NOT on Part Master



Off the top of my head...dump your part table in an excel file...dump your job parts in another excel file then see where they don't match....

M. Manasa Reddy
manasa@...<mailto:manasa%40weldcoa.com><mailto:manasa@...<mailto:manasa%40weldcoa.com>>
630.806.2000 x1515

From: vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com> [mailto:vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com>] On Behalf Of Karl Dash
Sent: Monday, October 29, 2012 3:27 PM
To: Vantage Group
Subject: [Vantage] Parts NOT on Part Master

All,
We build either turnkey or consignment assemblies. Historically we have not put the customer's part number on the Part master for consignment assemblies. We want to do that now. So, I am looking for all parts that are on the JobProd table but which are NOT on the Part Master. I have created a Crystal report that has those two tables attached to each other but am uncertain on what the join, enforce and link types need to be to accomplish this.

Thanks,
-Karl

[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]
5
Assuming you've made a BAQ report, and you clicked "outer join" in the
BAQ, then you want the following in Crystal: left outer join, not
enforced. Make sure the arrows are going the right way, in Crystal
*from* the parent table (JobProd) down to child (Part) - this is the
visual reverse of the arrows in the BAQ phrase builder.



Brian.



From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of Karl Dash
Sent: Monday, October 29, 2012 4:27 PM
To: Vantage Group
Subject: [Vantage] Parts NOT on Part Master





All,
We build either turnkey or consignment assemblies. Historically we
have not put the customer's part number on the Part master for
consignment assemblies. We want to do that now. So, I am looking for all
parts that are on the JobProd table but which are NOT on the Part
Master. I have created a Crystal report that has those two tables
attached to each other but am uncertain on what the join, enforce and
link types need to be to accomplish this.

Thanks,
-Karl

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





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

for each JobProd no-lock , each Part no-lock outer-join where (JobProd.Company = Part.Company and JobProd.PartNum = Part.PartNum ).

I displayed JobProd.PartNum and Part.PartNum, then the blanks in the Part.PartNum are those you are looking for.

Miguel A. Santillan
Compass Components, Inc.


From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of Brian Roberts
Sent: Monday, October 29, 2012 1:47 PM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Parts NOT on Part Master



Assuming you've made a BAQ report, and you clicked "outer join" in the
BAQ, then you want the following in Crystal: left outer join, not
enforced. Make sure the arrows are going the right way, in Crystal
*from* the parent table (JobProd) down to child (Part) - this is the
visual reverse of the arrows in the BAQ phrase builder.

Brian.

From: vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com> [mailto:vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com>] On Behalf
Of Karl Dash
Sent: Monday, October 29, 2012 4:27 PM
To: Vantage Group
Subject: [Vantage] Parts NOT on Part Master

All,
We build either turnkey or consignment assemblies. Historically we
have not put the customer's part number on the Part master for
consignment assemblies. We want to do that now. So, I am looking for all
parts that are on the JobProd table but which are NOT on the Part
Master. I have created a Crystal report that has those two tables
attached to each other but am uncertain on what the join, enforce and
link types need to be to accomplish this.

Thanks,
-Karl

[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]
7
For something like this I usually use a product called Navicat. I just manually build the SQL queries and export the result. Like SQL management studio, but much faster and easier to use.

--- In vantage@yahoogroups.com, Miguel Santillan <msantillan@...> wrote:
>
> Correct.
>
> for each JobProd no-lock , each Part no-lock outer-join where (JobProd.Company = Part.Company and JobProd.PartNum = Part.PartNum ).
>
> I displayed JobProd.PartNum and Part.PartNum, then the blanks in the Part.PartNum are those you are looking for.
>
> Miguel A. Santillan
> Compass Components, Inc.
>
>
> From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of Brian Roberts
> Sent: Monday, October 29, 2012 1:47 PM
> To: vantage@yahoogroups.com
> Subject: RE: [Vantage] Parts NOT on Part Master
>
>
>
> Assuming you've made a BAQ report, and you clicked "outer join" in the
> BAQ, then you want the following in Crystal: left outer join, not
> enforced. Make sure the arrows are going the right way, in Crystal
> *from* the parent table (JobProd) down to child (Part) - this is the
> visual reverse of the arrows in the BAQ phrase builder.
>
> Brian.
>
> From: vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com> [mailto:vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com>] On Behalf
> Of Karl Dash
> Sent: Monday, October 29, 2012 4:27 PM
> To: Vantage Group
> Subject: [Vantage] Parts NOT on Part Master
>
> All,
> We build either turnkey or consignment assemblies. Historically we
> have not put the customer's part number on the Part master for
> consignment assemblies. We want to do that now. So, I am looking for all
> parts that are on the JobProd table but which are NOT on the Part
> Master. I have created a Crystal report that has those two tables
> attached to each other but am uncertain on what the join, enforce and
> link types need to be to accomplish this.
>
> Thanks,
> -Karl
>
> [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]
>
8
Brian, et al,
 This is what worked. The Crystal report lists all parts on the JobProd but where there is no match to Part, the part number is blank. In order to reduce the number of pages, I may want to limit printing to only those parts that have a blank Part.partnum.
Â
Thanks again -Karl



________________________________
From: Brian Roberts <broberts@...>
To: vantage@yahoogroups.com
Sent: Monday, October 29, 2012 1:46 PM
Subject: RE: [Vantage] Parts NOT on Part Master

Â
Assuming you've made a BAQ report, and you clicked "outer join" in the
BAQ, then you want the following in Crystal: left outer join, not
enforced. Make sure the arrows are going the right way, in Crystal
*from* the parent table (JobProd) down to child (Part) - this is the
visual reverse of the arrows in the BAQ phrase builder.

Brian.

From: mailto:vantage%40yahoogroups.com [mailto:mailto:vantage%40yahoogroups.com] On Behalf
Of Karl Dash
Sent: Monday, October 29, 2012 4:27 PM
To: Vantage Group
Subject: [Vantage] Parts NOT on Part Master

All,
We build either turnkey or consignment assemblies. Historically we
have not put the customer's part number on the Part master for
consignment assemblies. We want to do that now. So, I am looking for all
parts that are on the JobProd table but which are NOT on the Part
Master. I have created a Crystal report that has those two tables
attached to each other but am uncertain on what the join, enforce and
link types need to be to accomplish this.

Thanks,
-Karl

[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]