Vantage - Link between Parent Job and Material Job (sub-assembl

system · February 28, 2011, 3:54pm

Good afternoon.

Chris, the table JobProd has all the information of the demand for jobs; it tells you if you are producing for Stock, Sales Order, Job.....

Regards.

Roel Martinez
ERP Analyst

SABRE TUBULAR STRUCTURES (tm)
www.sabretubularstructures.com<http://www.sabretubularstructures.com/>
8653 E. Hwy 67 | Alvarado, TX 76009
Phone: 817-852-1700 ext. 11858 | Direct Line: 817-852-1858 |Fax: 817-852-1705

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of cooner_55421
Sent: Monday, February 28, 2011 11:08 AM
To: vantage@yahoogroups.com
Subject: [Vantage] Re: Vantage - Link between Parent Job and Material Job (sub-assembly)

Check out the JobAsmbl table.
It has some good info, if your parts are nonstock.

If your parts are stock, then I don't think Vantage really keeps track of any links.

--- In vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com>, Chris Thompson <chriselectrix@...> wrote:
>
> I think im getting there - I have JobHead > JobDtl > JobMtl.
>
> Now I have JobMtl I need to find where the demands are coming from (i.e. which
> parent jobs are putting the demand on the child part / job).
>
> Any ideas?
>
> Basically the information that is shown in the left / 2nd row in Job Manager.
>
> Thanks.
>
>
>
>
> ________________________________
> From: cooner_55421 <cooner_55421@...>
> To: vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com>
> Sent: Mon, 28 February, 2011 16:05:59
> Subject: [Vantage] Re: Vantage - Link between Parent Job and Material Job
> (sub-assembly)
>
> Ã‚
> Hi,
>
> I did something similar to what you describe but I used ODBC.
> It may be possible with a BAQ, I just haven't had time to take a fresh look at
> it.
>
> Anyway, I pull from these tables: JobAsmbl, JobHead, JobMtl, JobbProd, PartBin
> and PlantWhse. Let me know if you'd like any details.
>
> --- In vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com>, Chris Thompson <chriselectrix@> wrote:
> >
> > Hi All
> >
> > Im trying to write a report to show the parent job.
> >
> > If the parent doesnt have enough child material (sub-assemblies or raw
> >material)
> >
> > I then want to see any jobs linked to that child (or orders in the case of raw
>
> > materials).
> >
> > So I need to see the job number for the parent and if the child sub assembly /
>
> > raw material doesnt have enough on hand I need to see the job for that too.
> >
> > Ideally it wants to eb in one BAQ.
> >
> >
> >
> >
> > [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]

system · February 25, 2011, 9:11am

Hi All

Im trying to write a report to show the parent job.

If the parent doesnt have enough child material (sub-assemblies or raw material)
I then want to see any jobs linked to that child (or orders in the case of raw
materials).

So I need to see the job number for the parent and if the child sub assembly /
raw material doesnt have enough on hand I need to see the job for that too.

Ideally it wants to eb in one BAQ.

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

system · February 26, 2011, 10:43am

What about using the Production Planner Workbench?
Just make sure that your jobs have a planner assigned and that you run the process to populate the tables to support the workbench.

Bruce Larson
Senior Solution Architect
alternative Technology Partners

Web Site: www.alttechpartners.com

Cell: (763) 486-0030 Conference: 805-309-0111 ID: 348030
Fax: (763) 447-3571
Email: bruce.larson@...

--- In vantage@yahoogroups.com, Chris Thompson <chriselectrix@...> wrote:
>
> Hi All
>
> Im trying to write a report to show the parent job.
>
> If the parent doesnt have enough child material (sub-assemblies or raw material)
> I then want to see any jobs linked to that child (or orders in the case of raw
> materials).
>
> So I need to see the job number for the parent and if the child sub assembly /
> raw material doesnt have enough on hand I need to see the job for that too.
>
> Ideally it wants to eb in one BAQ.
>
>
>
>
> [Non-text portions of this message have been removed]
>

system · February 28, 2011, 3:13am

Hi

Im trying to present all the data in a clear way on large screens throughout the
building.

I need to see things like which orders require certain parts etc.

I dont think Production Planner Workbench shows this info.

Also with me wanting to display it in several places throughout the building I
didnt really want to consume licences. With it exporting to xml I can display it
on an internal web page for free.

Any more thoughts would be appreciated.

Thanks,

CHRIS

________________________________
From: Bruce <epicor@...>
To: vantage@yahoogroups.com
Sent: Sat, 26 February, 2011 15:43:14
Subject: [Vantage] Re: Vantage - Link between Parent Job and Material Job
(sub-assembly)

Â
What about using the Production Planner Workbench?
Just make sure that your jobs have a planner assigned and that you run the
process to populate the tables to support the workbench.

Bruce Larson
Senior Solution Architect
alternative Technology Partners

Web Site: www.alttechpartners.com

Cell: (763) 486-0030 Conference: 805-309-0111 ID: 348030
Fax: (763) 447-3571
Email: bruce.larson@...

--- In vantage@yahoogroups.com, Chris Thompson <chriselectrix@...> wrote:
>
> Hi All
>
> Im trying to write a report to show the parent job.
>
> If the parent doesnt have enough child material (sub-assemblies or raw
>material)
>
> I then want to see any jobs linked to that child (or orders in the case of raw

> materials).
>
> So I need to see the job number for the parent and if the child sub assembly /

> raw material doesnt have enough on hand I need to see the job for that too.
>
> Ideally it wants to eb in one BAQ.
>
>
>
>
> [Non-text portions of this message have been removed]
>

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

system · February 28, 2011, 4:15am

Ive just checked our PPlanHed table and it's totally empty.

Is this right?

________________________________
From: Chris Thompson <chriselectrix@...>
To: vantage@yahoogroups.com
Sent: Mon, 28 February, 2011 8:13:09
Subject: Re: [Vantage] Re: Vantage - Link between Parent Job and Material Job
(sub-assembly)

Â
Hi

Im trying to present all the data in a clear way on large screens throughout the

building.

I need to see things like which orders require certain parts etc.

I dont think Production Planner Workbench shows this info.

Also with me wanting to display it in several places throughout the building I
didnt really want to consume licences. With it exporting to xml I can display it

on an internal web page for free.

Any more thoughts would be appreciated.

Thanks,

CHRIS

________________________________
From: Bruce <epicor@...>
To: vantage@yahoogroups.com
Sent: Sat, 26 February, 2011 15:43:14
Subject: [Vantage] Re: Vantage - Link between Parent Job and Material Job
(sub-assembly)

Â
What about using the Production Planner Workbench?
Just make sure that your jobs have a planner assigned and that you run the
process to populate the tables to support the workbench.

Bruce Larson
Senior Solution Architect
alternative Technology Partners

Web Site: www.alttechpartners.com

Cell: (763) 486-0030 Conference: 805-309-0111 ID: 348030
Fax: (763) 447-3571
Email: bruce.larson@...

--- In vantage@yahoogroups.com, Chris Thompson <chriselectrix@...> wrote:
>
> Hi All
>
> Im trying to write a report to show the parent job.
>
> If the parent doesnt have enough child material (sub-assemblies or raw
>material)
>
> I then want to see any jobs linked to that child (or orders in the case of raw

> materials).
>
> So I need to see the job number for the parent and if the child sub assembly /

> raw material doesnt have enough on hand I need to see the job for that too.
>
> Ideally it wants to eb in one BAQ.
>
>
>
>
> [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]

system · February 28, 2011, 11:23am

I think im getting there - I have JobHead > JobDtl > JobMtl.

Now I have JobMtl I need to find where the demands are coming from (i.e. which
parent jobs are putting the demand on the child part / job).

Any ideas?

Basically the information that is shown in the left / 2nd row in Job Manager.

Thanks.

________________________________
From: cooner_55421 <cooner_55421@...>
To: vantage@yahoogroups.com
Sent: Mon, 28 February, 2011 16:05:59
Subject: [Vantage] Re: Vantage - Link between Parent Job and Material Job
(sub-assembly)

Â
Hi,

I did something similar to what you describe but I used ODBC.
It may be possible with a BAQ, I just haven't had time to take a fresh look at
it.

Anyway, I pull from these tables: JobAsmbl, JobHead, JobMtl, JobbProd, PartBin
and PlantWhse. Let me know if you'd like any details.

--- In vantage@yahoogroups.com, Chris Thompson <chriselectrix@...> wrote:
>
> Hi All
>
> Im trying to write a report to show the parent job.
>
> If the parent doesnt have enough child material (sub-assemblies or raw
>material)
>
> I then want to see any jobs linked to that child (or orders in the case of raw

> materials).
>
> So I need to see the job number for the parent and if the child sub assembly /

> raw material doesnt have enough on hand I need to see the job for that too.
>
> Ideally it wants to eb in one BAQ.
>
>
>
>
> [Non-text portions of this message have been removed]
>

Â

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

system · February 28, 2011, 11:33am

To find the table & field linked to anything displayed on a screen,
click it then Help -> Field Help -> Technical Details. You might find
it easier to do that in Job Entry/Tracker instead of Job Manager. Doing
that should lead you to the JobProd table.

Then for more info, go to the Data Dictionary (under System Management),
look up JobProd and you'll see this: "Defines the Demand for
Production. Establishes a many to many link between jobs and the
related demand records. Demands can be orders, warehouses, or other
jobs." There's lots of other details available there.

I use those tools a lot.

Brian.

________________________________

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of Chris Thompson
Sent: Monday, February 28, 2011 11:23 AM
To: vantage@yahoogroups.com
Subject: Re: [Vantage] Re: Vantage - Link between Parent Job and
Material Job (sub-assembly)

I think im getting there - I have JobHead > JobDtl > JobMtl.

Now I have JobMtl I need to find where the demands are coming from (i.e.
which
parent jobs are putting the demand on the child part / job).

Any ideas?

Basically the information that is shown in the left / 2nd row in Job
Manager.

Thanks.

________________________________
From: cooner_55421 <cooner_55421@...
<mailto:cooner_55421%40yahoo.com> >
To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
Sent: Mon, 28 February, 2011 16:05:59
Subject: [Vantage] Re: Vantage - Link between Parent Job and Material
Job
(sub-assembly)

Hi,

I did something similar to what you describe but I used ODBC.
It may be possible with a BAQ, I just haven't had time to take a fresh
look at
it.

Anyway, I pull from these tables: JobAsmbl, JobHead, JobMtl, JobbProd,
PartBin
and PlantWhse. Let me know if you'd like any details.

--- In vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ,
Chris Thompson <chriselectrix@...> wrote:

>
> Hi All
>
> Im trying to write a report to show the parent job.
>
> If the parent doesnt have enough child material (sub-assemblies or raw

>material)
>
> I then want to see any jobs linked to that child (or orders in the

case of raw

> materials).
>
> So I need to see the job number for the parent and if the child sub

assembly /

> raw material doesnt have enough on hand I need to see the job for that

too.

>
> Ideally it wants to eb in one BAQ.
>
>
>
>
> [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]