E9: Summarize JOb Material Req

I did this yesterday.

 

Part joined by PartMtl.

Then in PartMtl added a calculated field Total(req qty);

Part (Typecode=P);

PartMtl  ReqDate < 1/3/2015

PartMtl  ReqDate > 1/1/2015

 

But the query never finished.  It was over 20 minutes.

 

Miguel A. Santillan

Compass Manufacturing Systems

 

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com]
Sent: Friday, December 19, 2014 6:13 AM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] RE: E9: Summarize JOb Material Req.

 

 

What are your table joins?  To go it to summarize by part I think you would have to start with part as the main table and join to jobmtl and summarize jobmtl table.  Although I have never tried this…

How do I summarize the req qty of a part in jobs.

 

I want to look at jobs starting  1/1/2015 – 1/7/2015

From those jobs, I want to know the req qty of the job material.

 

So if PART 1 is in 10 jobs.

 

I want to see PART 1 : TOTAL (REQ QTY)

 

I keep on getting  the TOTAL REQ QTY of the JOB rather than the Material.

 

 

 

Miguel A. Santillan

ERP Analyst

Compass Manufacturing Systems

510-661-6666  Office

 

Are you doing this in Crystal Reports, BAQ, something else?

 

Manasa

 

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com]
Sent: Thursday, December 18, 2014 12:51 PM
To: vantage@yahoogroups.com
Subject: [Vantage] E9: Summarize JOb Material Req.

 

 

How do I summarize the req qty of a part in jobs.

 

I want to look at jobs starting  1/1/2015 – 1/7/2015

From those jobs, I want to know the req qty of the job material.

 

So if PART 1 is in 10 jobs.

 

I want to see PART 1 : TOTAL (REQ QTY)

 

I keep on getting  the TOTAL REQ QTY of the JOB rather than the Material.

 

 

 

Miguel A. Santillan

ERP Analyst

Compass Manufacturing Systems

510-661-6666  Office

 

BAQ.

 

For a CR, I know I can summarize by right clicking.  I want to send the export csv to our suppliers who are on my SMI program.

 

Miguel A. Santillan

Compass Manufacturing Systems

 

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com]
Sent: Thursday, December 18, 2014 11:29 AM
To: vantage@yahoogroups.com
Subject: [Vantage] RE: E9: Summarize JOb Material Req.

 

 

Are you doing this in Crystal Reports, BAQ, something else?

 

Manasa

 

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com]
Sent: Thursday, December 18, 2014 12:51 PM
To: vantage@yahoogroups.com
Subject: [Vantage] E9: Summarize JOb Material Req.

 

 

How do I summarize the req qty of a part in jobs.

 

I want to look at jobs starting  1/1/2015 – 1/7/2015

From those jobs, I want to know the req qty of the job material.

 

So if PART 1 is in 10 jobs.

 

I want to see PART 1 : TOTAL (REQ QTY)

 

I keep on getting  the TOTAL REQ QTY of the JOB rather than the Material.

 

 

 

Miguel A. Santillan

ERP Analyst

Compass Manufacturing Systems

510-661-6666  Office

 

What are your table joins?  To go it to summarize by part I think you would have to start with part as the main table and join to jobmtl and summarize jobmtl table.  Although I have never tried this…