Need to know how much product is sitting at a Job Assembly/Opera

Yahoo Archive
1
The Work in Process Report is a summary report.



If you needed to see what was sitting on a Particular job in detail you can
use job tracker - Job Details - Material - list view. Move you columns
around they have the Req Qty - Issued Qty - Est Cost - Act Cost.



Job Status Dashboard can also be used to see materials.



Both dashboards are using the JobMtl table. You should be able to create a
report for WIP tags from this table.







From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of
Ed Garbowski
Sent: Wednesday, November 28, 2012 2:17 PM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Need to know how much product is sitting at a Job
Assembly/Operation (Vantage 8)





Mike,
The data you are looking for is in the JobMtl table if you need to develop
your own report.

Ed
From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
[mailto:vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ] On
Behalf Of Manasa Reddy
Sent: Wednesday, November 28, 2012 3:14 PM
To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
Subject: RE: [Vantage] Need to know how much product is sitting at a Job
Assembly/Operation (Vantage 8)

I thought you could filter it for sub-assemblies...

When you pick the job you want is there a Part tab? If so try picking the
sub-assembly part number there and see what it does.

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

From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com> [mailto:vantage@yahoogroups.com
<mailto:vantage%40yahoogroups.com> <mailto:vantage%40yahoogroups.com>] On
Behalf Of Mike Abell
Sent: Wednesday, November 28, 2012 3:09 PM
To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
Subject: RE: [Vantage] Need to know how much product is sitting at a Job
Assembly/Operation (Vantage 8)

Thanks Manasa, yes, I've ran that report but it only shows the "Top Level"
part number for a Job, I'm needing to know what all of the individual part
numbers underneath the main part number that make it up and their quantities
at each assembly/operation. Any idea?

Mike.

From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com><mailto:vantage%40yahoogroups.com>
[mailto:vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com><mailto:vantage%40yahoogroups.com>] On
Behalf Of
Manasa Reddy
Sent: Wednesday, November 28, 2012 2:59 PM
To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com><mailto:vantage%40yahoogroups.com>
Subject: RE: [Vantage] Need to know how much product is sitting at a Job
Assembly/Operation (Vantage 8)

Work In Process report....

It's under reports under Job management

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

From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com><mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
[mailto:vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com><mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com> ] On
Behalf Of flexial_ma
Sent: Wednesday, November 28, 2012 2:57 PM
To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com><mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
Subject: [Vantage] Need to know how much product is sitting at a Job
Assembly/Operation (Vantage 8)

Is there anyway in the Vantage system that I can look and see how much
product (part numbers) is currently "sitting" at a particular Job
Assembly/Operation? We are trying to figure out how to inventory our WIP and
I have no idea where to look in Vantage to find this information. Also, I'd
like to develop a report so if anyone has any idea in the database where
this info might exist, I'd love to know that as well. Thanks in advance...

Mike..

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

________________________________

The information contained in this message is intended solely for the
individual to whom it is specifically and originally addressed. This message
and its contents may contain confidential or privileged information. If you
are not the intended recipient, you are hereby notified that any disclosure
or distribution, or taking any action in reliance on the contents of this
information, is strictly prohibited.
We have taken precautions to minimize the risk of transmitting software
viruses, but we advise you to carry out your own virus checks on any
attachment to this message. We cannot accept liability for any loss or
damage caused by software viruses.

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





[Non-text portions of this message have been removed]
2
Is there anyway in the Vantage system that I can look and see how much product (part numbers) is currently "sitting" at a particular Job Assembly/Operation? We are trying to figure out how to inventory our WIP and I have no idea where to look in Vantage to find this information. Also, I'd like to develop a report so if anyone has any idea in the database where this info might exist, I'd love to know that as well. Thanks in advance...

Mike..
3
Work In Process report....

It's under reports under Job management



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

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of flexial_ma
Sent: Wednesday, November 28, 2012 2:57 PM
To: vantage@yahoogroups.com
Subject: [Vantage] Need to know how much product is sitting at a Job Assembly/Operation (Vantage 8)



Is there anyway in the Vantage system that I can look and see how much product (part numbers) is currently "sitting" at a particular Job Assembly/Operation? We are trying to figure out how to inventory our WIP and I have no idea where to look in Vantage to find this information. Also, I'd like to develop a report so if anyone has any idea in the database where this info might exist, I'd love to know that as well. Thanks in advance...

Mike..



[Non-text portions of this message have been removed]
4
Thanks Manasa, yes, I've ran that report but it only shows the "Top Level"
part number for a Job, I'm needing to know what all of the individual part
numbers underneath the main part number that make it up and their quantities
at each assembly/operation. Any idea?



Mike.



From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of
Manasa Reddy
Sent: Wednesday, November 28, 2012 2:59 PM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Need to know how much product is sitting at a Job
Assembly/Operation (Vantage 8)





Work In Process report....

It's under reports under Job management

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 flexial_ma
Sent: Wednesday, November 28, 2012 2:57 PM
To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
Subject: [Vantage] Need to know how much product is sitting at a Job
Assembly/Operation (Vantage 8)

Is there anyway in the Vantage system that I can look and see how much
product (part numbers) is currently "sitting" at a particular Job
Assembly/Operation? We are trying to figure out how to inventory our WIP and
I have no idea where to look in Vantage to find this information. Also, I'd
like to develop a report so if anyone has any idea in the database where
this info might exist, I'd love to know that as well. Thanks in advance...

Mike..

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





[Non-text portions of this message have been removed]
5
I thought you could filter it for sub-assemblies...

When you pick the job you want is there a Part tab? If so try picking the sub-assembly part number there and see what it does.



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

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of Mike Abell
Sent: Wednesday, November 28, 2012 3:09 PM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Need to know how much product is sitting at a Job Assembly/Operation (Vantage 8)



Thanks Manasa, yes, I've ran that report but it only shows the "Top Level"
part number for a Job, I'm needing to know what all of the individual part
numbers underneath the main part number that make it up and their quantities
at each assembly/operation. Any idea?

Mike.

From: vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com> [mailto:vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com>] On Behalf Of
Manasa Reddy
Sent: Wednesday, November 28, 2012 2:59 PM
To: vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com>
Subject: RE: [Vantage] Need to know how much product is sitting at a Job
Assembly/Operation (Vantage 8)

Work In Process report....

It's under reports under Job management

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

From: vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com> <mailto:vantage%40yahoogroups.com>
[mailto:vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com> <mailto:vantage%40yahoogroups.com> ] On
Behalf Of flexial_ma
Sent: Wednesday, November 28, 2012 2:57 PM
To: vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com> <mailto:vantage%40yahoogroups.com>
Subject: [Vantage] Need to know how much product is sitting at a Job
Assembly/Operation (Vantage 8)

Is there anyway in the Vantage system that I can look and see how much
product (part numbers) is currently "sitting" at a particular Job
Assembly/Operation? We are trying to figure out how to inventory our WIP and
I have no idea where to look in Vantage to find this information. Also, I'd
like to develop a report so if anyone has any idea in the database where
this info might exist, I'd love to know that as well. Thanks in advance...

Mike..

[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]
6
Mike,
The data you are looking for is in the JobMtl table if you need to develop your own report.

Ed
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of Manasa Reddy
Sent: Wednesday, November 28, 2012 3:14 PM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Need to know how much product is sitting at a Job Assembly/Operation (Vantage 8)



I thought you could filter it for sub-assemblies...

When you pick the job you want is there a Part tab? If so try picking the sub-assembly part number there and see what it does.

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 Mike Abell
Sent: Wednesday, November 28, 2012 3:09 PM
To: vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com>
Subject: RE: [Vantage] Need to know how much product is sitting at a Job Assembly/Operation (Vantage 8)

Thanks Manasa, yes, I've ran that report but it only shows the "Top Level"
part number for a Job, I'm needing to know what all of the individual part
numbers underneath the main part number that make it up and their quantities
at each assembly/operation. Any idea?

Mike.

From: vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com><mailto:vantage%40yahoogroups.com> [mailto:vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com><mailto:vantage%40yahoogroups.com>] On Behalf Of
Manasa Reddy
Sent: Wednesday, November 28, 2012 2:59 PM
To: vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com><mailto:vantage%40yahoogroups.com>
Subject: RE: [Vantage] Need to know how much product is sitting at a Job
Assembly/Operation (Vantage 8)

Work In Process report....

It's under reports under Job management

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

From: vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com><mailto:vantage%40yahoogroups.com> <mailto:vantage%40yahoogroups.com>
[mailto:vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com><mailto:vantage%40yahoogroups.com> <mailto:vantage%40yahoogroups.com> ] On
Behalf Of flexial_ma
Sent: Wednesday, November 28, 2012 2:57 PM
To: vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com><mailto:vantage%40yahoogroups.com> <mailto:vantage%40yahoogroups.com>
Subject: [Vantage] Need to know how much product is sitting at a Job
Assembly/Operation (Vantage 8)

Is there anyway in the Vantage system that I can look and see how much
product (part numbers) is currently "sitting" at a particular Job
Assembly/Operation? We are trying to figure out how to inventory our WIP and
I have no idea where to look in Vantage to find this information. Also, I'd
like to develop a report so if anyone has any idea in the database where
this info might exist, I'd love to know that as well. Thanks in advance...

Mike..

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


________________________________

The information contained in this message is intended solely for the individual to whom it is specifically and originally addressed. This message and its contents may contain confidential or privileged information. If you are not the intended recipient, you are hereby notified that any disclosure or distribution, or taking any action in reliance on the contents of this information, is strictly prohibited.
We have taken precautions to minimize the risk of transmitting software viruses, but we advise you to carry out your own virus checks on any attachment to this message. We cannot accept liability for any loss or damage caused by software viruses.


[Non-text portions of this message have been removed]
7
Or even just try it with the sub-assembly part number...no job and see what happens



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

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of Manasa Reddy
Sent: Wednesday, November 28, 2012 3:14 PM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Need to know how much product is sitting at a Job Assembly/Operation (Vantage 8)



I thought you could filter it for sub-assemblies...

When you pick the job you want is there a Part tab? If so try picking the sub-assembly part number there and see what it does.

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 Mike Abell
Sent: Wednesday, November 28, 2012 3:09 PM
To: vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com>
Subject: RE: [Vantage] Need to know how much product is sitting at a Job Assembly/Operation (Vantage 8)

Thanks Manasa, yes, I've ran that report but it only shows the "Top Level"
part number for a Job, I'm needing to know what all of the individual part
numbers underneath the main part number that make it up and their quantities
at each assembly/operation. Any idea?

Mike.

From: vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com><mailto:vantage%40yahoogroups.com> [mailto:vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com><mailto:vantage%40yahoogroups.com>] On Behalf Of
Manasa Reddy
Sent: Wednesday, November 28, 2012 2:59 PM
To: vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com><mailto:vantage%40yahoogroups.com>
Subject: RE: [Vantage] Need to know how much product is sitting at a Job
Assembly/Operation (Vantage 8)

Work In Process report....

It's under reports under Job management

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

From: vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com><mailto:vantage%40yahoogroups.com> <mailto:vantage%40yahoogroups.com>
[mailto:vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com><mailto:vantage%40yahoogroups.com> <mailto:vantage%40yahoogroups.com> ] On
Behalf Of flexial_ma
Sent: Wednesday, November 28, 2012 2:57 PM
To: vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com><mailto:vantage%40yahoogroups.com> <mailto:vantage%40yahoogroups.com>
Subject: [Vantage] Need to know how much product is sitting at a Job
Assembly/Operation (Vantage 8)

Is there anyway in the Vantage system that I can look and see how much
product (part numbers) is currently "sitting" at a particular Job
Assembly/Operation? We are trying to figure out how to inventory our WIP and
I have no idea where to look in Vantage to find this information. Also, I'd
like to develop a report so if anyone has any idea in the database where
this info might exist, I'd love to know that as well. Thanks in advance...

Mike..

[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]
8
Good Day:

Unless you are doing parallel processing, all the Issued mat'l
should be at wherever the JOB is.

If you are just after an Inventory of WIP:

1. Run a Issued list for each open JOB -- or do a BAQ report
sorted by JOB.
2. Sort sheets by which operation it is at.
3. Inventory by marking up the print-out to see if what is there
agrees with what is issued
You will have to account for 'Partial" complete JOBS
since count-qty should = ( [Issued-Qty] - [Qty completed])



Len
Leonard C. Hartka, IS Project Manager\ERP Specialist
Sun Automation Group
66 Loveton Circle
Sparks, Md. 21152
410-329-3560 ext. 120
410-329-3564 FAX
443-255-7192 Work Cell
len.hartka@...

www.Sunautomation.com <http://www.sunautomation.com/>


________________________________

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of Manasa Reddy
Sent: Wednesday, November 28, 2012 4:14 PM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Need to know how much product is sitting at a Job
Assembly/Operation (Vantage 8)




I thought you could filter it for sub-assemblies...

When you pick the job you want is there a Part tab? If so try picking
the sub-assembly part number there and see what it does.

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 Mike Abell
Sent: Wednesday, November 28, 2012 3:09 PM
To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
Subject: RE: [Vantage] Need to know how much product is sitting at a Job
Assembly/Operation (Vantage 8)

Thanks Manasa, yes, I've ran that report but it only shows the "Top
Level"
part number for a Job, I'm needing to know what all of the individual
part
numbers underneath the main part number that make it up and their
quantities
at each assembly/operation. Any idea?

Mike.

From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com> [mailto:vantage@yahoogroups.com
<mailto:vantage%40yahoogroups.com> <mailto:vantage%40yahoogroups.com>]
On Behalf Of
Manasa Reddy
Sent: Wednesday, November 28, 2012 2:59 PM
To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
Subject: RE: [Vantage] Need to know how much product is sitting at a Job
Assembly/Operation (Vantage 8)

Work In Process report....

It's under reports under Job management

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

From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com> <mailto:vantage%40yahoogroups.com>
[mailto:vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com> <mailto:vantage%40yahoogroups.com> ]
On
Behalf Of flexial_ma
Sent: Wednesday, November 28, 2012 2:57 PM
To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com> <mailto:vantage%40yahoogroups.com>
Subject: [Vantage] Need to know how much product is sitting at a Job
Assembly/Operation (Vantage 8)

Is there anyway in the Vantage system that I can look and see how much
product (part numbers) is currently "sitting" at a particular Job
Assembly/Operation? We are trying to figure out how to inventory our WIP
and
I have no idea where to look in Vantage to find this information. Also,
I'd
like to develop a report so if anyone has any idea in the database where
this info might exist, I'd love to know that as well. Thanks in
advance...

Mike..

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






This e-mail and any attachments may contain proprietary and/or confidential information. If you are not the intended recipient, please notify the sender immediately by reply e-mail or at 410-472-2900 and then delete the message without using, disseminating, or copying this message or any portion thereof. With e-mail communications you are urged to protect against viruses.


[Non-text portions of this message have been removed]
9
Is this a V9 thing? All I get in V8.03 is what you see below which is the option to sort by Job, Part, or Product Group. And as I said, it's only the "Top Level" job part number that it reports, not everything that makes it up which is what I'm looking for.

[cid:image001.png@01CDCD7C.E438F830]

Mike Abell
Systems Analyst / Network Administrator
Flexial - BOA Group - Cookeville, Tennessee
Office: 931.432.1853 ext 302
Mobile: 615.418.3055
email: MAbell@...


From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of Manasa Reddy
Sent: Wednesday, November 28, 2012 3:14 PM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Need to know how much product is sitting at a Job Assembly/Operation (Vantage 8)



I thought you could filter it for sub-assemblies...

When you pick the job you want is there a Part tab? If so try picking the sub-assembly part number there and see what it does.

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 Mike Abell
Sent: Wednesday, November 28, 2012 3:09 PM
To: vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com>
Subject: RE: [Vantage] Need to know how much product is sitting at a Job Assembly/Operation (Vantage 8)

Thanks Manasa, yes, I've ran that report but it only shows the "Top Level"
part number for a Job, I'm needing to know what all of the individual part
numbers underneath the main part number that make it up and their quantities
at each assembly/operation. Any idea?

Mike.

From: vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com><mailto:vantage%40yahoogroups.com> [mailto:vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com><mailto:vantage%40yahoogroups.com>] On Behalf Of
Manasa Reddy
Sent: Wednesday, November 28, 2012 2:59 PM
To: vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com><mailto:vantage%40yahoogroups.com>
Subject: RE: [Vantage] Need to know how much product is sitting at a Job
Assembly/Operation (Vantage 8)

Work In Process report....

It's under reports under Job management

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

From: vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com><mailto:vantage%40yahoogroups.com> <mailto:vantage%40yahoogroups.com>
[mailto:vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com><mailto:vantage%40yahoogroups.com> <mailto:vantage%40yahoogroups.com> ] On
Behalf Of flexial_ma
Sent: Wednesday, November 28, 2012 2:57 PM
To: vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com><mailto:vantage%40yahoogroups.com> <mailto:vantage%40yahoogroups.com>
Subject: [Vantage] Need to know how much product is sitting at a Job
Assembly/Operation (Vantage 8)

Is there anyway in the Vantage system that I can look and see how much
product (part numbers) is currently "sitting" at a particular Job
Assembly/Operation? We are trying to figure out how to inventory our WIP and
I have no idea where to look in Vantage to find this information. Also, I'd
like to develop a report so if anyone has any idea in the database where
this info might exist, I'd love to know that as well. Thanks in advance...

Mike..

[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]
10
Nope...I thought if you filter for the sub-assembly part it would tell you which jobs it were on.

It had been a while since I had to run this for sub-assemblies since my current company backflushes everything the report is useless to us.

Len has the right idea though....unless you are running these sub-assemblies on separate jobs this report won't work. However, the rest of Len's email make sense as to how you would proceed if you have everything on the same job.

Sorry for the confusion!



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

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of Mike Abell
Sent: Wednesday, November 28, 2012 3:28 PM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Need to know how much product is sitting at a Job Assembly/Operation (Vantage 8)



Is this a V9 thing? All I get in V8.03 is what you see below which is the option to sort by Job, Part, or Product Group. And as I said, it's only the "Top Level" job part number that it reports, not everything that makes it up which is what I'm looking for.

[cid:image001.png@01CDCD7C.E438F830<mailto:image001.png%4001CDCD7C.E438F830>]

Mike Abell
Systems Analyst / Network Administrator
Flexial - BOA Group - Cookeville, Tennessee
Office: 931.432.1853 ext 302
Mobile: 615.418.3055
email: MAbell@...<mailto:MAbell%40flexial.com>

From: vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com> [mailto:vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com>] On Behalf Of Manasa Reddy
Sent: Wednesday, November 28, 2012 3:14 PM
To: vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com>
Subject: RE: [Vantage] Need to know how much product is sitting at a Job Assembly/Operation (Vantage 8)

I thought you could filter it for sub-assemblies...

When you pick the job you want is there a Part tab? If so try picking the sub-assembly part number there and see what it does.

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

From: vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com><mailto:vantage%40yahoogroups.com> [mailto:vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com><mailto:vantage%40yahoogroups.com>] On Behalf Of Mike Abell
Sent: Wednesday, November 28, 2012 3:09 PM
To: vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com><mailto:vantage%40yahoogroups.com>
Subject: RE: [Vantage] Need to know how much product is sitting at a Job Assembly/Operation (Vantage 8)

Thanks Manasa, yes, I've ran that report but it only shows the "Top Level"
part number for a Job, I'm needing to know what all of the individual part
numbers underneath the main part number that make it up and their quantities
at each assembly/operation. Any idea?

Mike.

From: vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com><mailto:vantage%40yahoogroups.com><mailto:vantage%40yahoogroups.com> [mailto:vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com><mailto:vantage%40yahoogroups.com><mailto:vantage%40yahoogroups.com>] On Behalf Of
Manasa Reddy
Sent: Wednesday, November 28, 2012 2:59 PM
To: vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com><mailto:vantage%40yahoogroups.com><mailto:vantage%40yahoogroups.com>
Subject: RE: [Vantage] Need to know how much product is sitting at a Job
Assembly/Operation (Vantage 8)

Work In Process report....

It's under reports under Job management

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

From: vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com><mailto:vantage%40yahoogroups.com><mailto:vantage%40yahoogroups.com> <mailto:vantage%40yahoogroups.com>
[mailto:vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com><mailto:vantage%40yahoogroups.com><mailto:vantage%40yahoogroups.com> <mailto:vantage%40yahoogroups.com> ] On
Behalf Of flexial_ma
Sent: Wednesday, November 28, 2012 2:57 PM
To: vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com><mailto:vantage%40yahoogroups.com><mailto:vantage%40yahoogroups.com> <mailto:vantage%40yahoogroups.com>
Subject: [Vantage] Need to know how much product is sitting at a Job
Assembly/Operation (Vantage 8)

Is there anyway in the Vantage system that I can look and see how much
product (part numbers) is currently "sitting" at a particular Job
Assembly/Operation? We are trying to figure out how to inventory our WIP and
I have no idea where to look in Vantage to find this information. Also, I'd
like to develop a report so if anyone has any idea in the database where
this info might exist, I'd love to know that as well. Thanks in advance...

Mike..

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



[Non-text portions of this message have been removed]
11
Thanks Lee,



What I'm after is we are doing a full Physical Inventory at our facitlity
and I'm trying to figure out something I can use to compare what Vantage
says is actually still on a job/asmb/operation versus what we are actually
counting and filling out inventory tags for. We do not key our WIP
inventory tags into Vantage, instead we use a spreadsheet and I'm just
trying to figure out some way to pull the info out of vantage so I can
compare with the results on the spreadsheet using a Crystal Report.



From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of
Len Hartka
Sent: Wednesday, November 28, 2012 3:24 PM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Need to know how much product is sitting at a Job
Assembly/Operation (Vantage 8)





Good Day:

Unless you are doing parallel processing, all the Issued mat'l
should be at wherever the JOB is.

If you are just after an Inventory of WIP:

1. Run a Issued list for each open JOB -- or do a BAQ report
sorted by JOB.
2. Sort sheets by which operation it is at.
3. Inventory by marking up the print-out to see if what is there
agrees with what is issued
You will have to account for 'Partial" complete JOBS
since count-qty should = ( [Issued-Qty] - [Qty completed])



Len
Leonard C. Hartka, IS Project Manager\ERP Specialist
Sun Automation Group
66 Loveton Circle
Sparks, Md. 21152
410-329-3560 ext. 120
410-329-3564 FAX
443-255-7192 Work Cell
len.hartka@... <mailto:len.hartka%40sunautomation.com>

www.Sunautomation.com <http://www.sunautomation.com/>

________________________________

From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
[mailto:vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ] On
Behalf
Of Manasa Reddy
Sent: Wednesday, November 28, 2012 4:14 PM
To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
Subject: RE: [Vantage] Need to know how much product is sitting at a Job
Assembly/Operation (Vantage 8)

I thought you could filter it for sub-assemblies...

When you pick the job you want is there a Part tab? If so try picking
the sub-assembly part number there and see what it does.

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

From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
[mailto:vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com> ] On
Behalf Of Mike Abell
Sent: Wednesday, November 28, 2012 3:09 PM
To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
Subject: RE: [Vantage] Need to know how much product is sitting at a Job
Assembly/Operation (Vantage 8)

Thanks Manasa, yes, I've ran that report but it only shows the "Top
Level"
part number for a Job, I'm needing to know what all of the individual
part
numbers underneath the main part number that make it up and their
quantities
at each assembly/operation. Any idea?

Mike.

From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com> [mailto:vantage@yahoogroups.com
<mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com> <mailto:vantage%40yahoogroups.com>]
On Behalf Of
Manasa Reddy
Sent: Wednesday, November 28, 2012 2:59 PM
To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
Subject: RE: [Vantage] Need to know how much product is sitting at a Job
Assembly/Operation (Vantage 8)

Work In Process report....

It's under reports under Job management

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

From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com> <mailto:vantage%40yahoogroups.com>
[mailto:vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com> <mailto:vantage%40yahoogroups.com> ]
On
Behalf Of flexial_ma
Sent: Wednesday, November 28, 2012 2:57 PM
To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com> <mailto:vantage%40yahoogroups.com>
Subject: [Vantage] Need to know how much product is sitting at a Job
Assembly/Operation (Vantage 8)

Is there anyway in the Vantage system that I can look and see how much
product (part numbers) is currently "sitting" at a particular Job
Assembly/Operation? We are trying to figure out how to inventory our WIP
and
I have no idea where to look in Vantage to find this information. Also,
I'd
like to develop a report so if anyone has any idea in the database where
this info might exist, I'd love to know that as well. Thanks in
advance...

Mike..

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

This e-mail and any attachments may contain proprietary and/or confidential
information. If you are not the intended recipient, please notify the sender
immediately by reply e-mail or at 410-472-2900 and then delete the message
without using, disseminating, or copying this message or any portion
thereof. With e-mail communications you are urged to protect against
viruses.

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





[Non-text portions of this message have been removed]
12
Good Day Mike:

Do you issue material to JOB's?

If yes, are you saying that some material that has been "Issued" in
V8 is still on the shelf? That is, The On-Hand qty in V8 will NOT equal
what is on the shelf? I can't see operating that way, but you can do a
BAQ for all JOBs using JobMTL file, limit to qty of components 'Issued",
include the Bin# puled from, sort by Bin# ( or maybe just warehouse).
*****************

If you do issue matl and do pull it off the shelf, as is standard,
then :

I did not intend for you to combine WIP and Inventory-Tags.

The print out of each JOB material list is your WIP-Tag. Take it to
the machine that has the JOB and compare the Issued-Material qty on the
list to what is there. No need to combine since all you need to verify
is that the "Issued" matl is at the JOB and not still on the shelf.
Obviously if there are disagreements then you will need to pull more or
send some back, or account for them mathematically.



Len

________________________________

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of Mike Abell
Sent: Wednesday, November 28, 2012 4:36 PM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Need to know how much product is sitting at a Job
Assembly/Operation (Vantage 8)




Thanks Lee,

What I'm after is we are doing a full Physical Inventory at our
facitlity
and I'm trying to figure out something I can use to compare what Vantage
says is actually still on a job/asmb/operation versus what we are
actually
counting and filling out inventory tags for. We do not key our WIP
inventory tags into Vantage, instead we use a spreadsheet and I'm just
trying to figure out some way to pull the info out of vantage so I can
compare with the results on the spreadsheet using a Crystal Report.

From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
[mailto:vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ] On
Behalf Of
Len Hartka
Sent: Wednesday, November 28, 2012 3:24 PM
To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
Subject: RE: [Vantage] Need to know how much product is sitting at a Job
Assembly/Operation (Vantage 8)

Good Day:

Unless you are doing parallel processing, all the Issued mat'l
should be at wherever the JOB is.

If you are just after an Inventory of WIP:

1. Run a Issued list for each open JOB -- or do a BAQ report
sorted by JOB.
2. Sort sheets by which operation it is at.
3. Inventory by marking up the print-out to see if what is there
agrees with what is issued
You will have to account for 'Partial" complete JOBS
since count-qty should = ( [Issued-Qty] - [Qty completed])

Len
Leonard C. Hartka, IS Project Manager\ERP Specialist
Sun Automation Group
66 Loveton Circle
Sparks, Md. 21152
410-329-3560 ext. 120
410-329-3564 FAX
443-255-7192 Work Cell
len.hartka@... <mailto:len.hartka%40sunautomation.com>
<mailto:len.hartka%40sunautomation.com>

www.Sunautomation.com <http://www.sunautomation.com/>

________________________________

From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
[mailto:vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com> ] On
Behalf
Of Manasa Reddy
Sent: Wednesday, November 28, 2012 4:14 PM
To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
Subject: RE: [Vantage] Need to know how much product is sitting at a Job
Assembly/Operation (Vantage 8)

I thought you could filter it for sub-assemblies...

When you pick the job you want is there a Part tab? If so try picking
the sub-assembly part number there and see what it does.

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

From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
[mailto:vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com> ] On
Behalf Of Mike Abell
Sent: Wednesday, November 28, 2012 3:09 PM
To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
Subject: RE: [Vantage] Need to know how much product is sitting at a Job
Assembly/Operation (Vantage 8)

Thanks Manasa, yes, I've ran that report but it only shows the "Top
Level"
part number for a Job, I'm needing to know what all of the individual
part
numbers underneath the main part number that make it up and their
quantities
at each assembly/operation. Any idea?

Mike.

From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com> [mailto:vantage@yahoogroups.com
<mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com> <mailto:vantage%40yahoogroups.com>]
On Behalf Of
Manasa Reddy
Sent: Wednesday, November 28, 2012 2:59 PM
To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
Subject: RE: [Vantage] Need to know how much product is sitting at a Job
Assembly/Operation (Vantage 8)

Work In Process report....

It's under reports under Job management

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

From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com> <mailto:vantage%40yahoogroups.com>
[mailto:vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com> <mailto:vantage%40yahoogroups.com> ]
On
Behalf Of flexial_ma
Sent: Wednesday, November 28, 2012 2:57 PM
To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com> <mailto:vantage%40yahoogroups.com>
Subject: [Vantage] Need to know how much product is sitting at a Job
Assembly/Operation (Vantage 8)

Is there anyway in the Vantage system that I can look and see how much
product (part numbers) is currently "sitting" at a particular Job
Assembly/Operation? We are trying to figure out how to inventory our WIP
and
I have no idea where to look in Vantage to find this information. Also,
I'd
like to develop a report so if anyone has any idea in the database where
this info might exist, I'd love to know that as well. Thanks in
advance...

Mike..

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

This e-mail and any attachments may contain proprietary and/or
confidential
information. If you are not the intended recipient, please notify the
sender
immediately by reply e-mail or at 410-472-2900 and then delete the
message
without using, disseminating, or copying this message or any portion
thereof. With e-mail communications you are urged to protect against
viruses.

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

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






This e-mail and any attachments may contain proprietary and/or confidential information. If you are not the intended recipient, please notify the sender immediately by reply e-mail or at 410-472-2900 and then delete the message without using, disseminating, or copying this message or any portion thereof. With e-mail communications you are urged to protect against viruses.


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