Chris,
So you were able to get this working then? Do you mind sharing what your final BPM looks like?
I'm looking to prevent someone from clocking into a job if a part exists, but I'm having trouble with the disconnect between a job and a part...
What you're doing sounds awfully similar to what I'm trying to do.
Thanks,
-Jason
So you were able to get this working then? Do you mind sharing what your final BPM looks like?
I'm looking to prevent someone from clocking into a job if a part exists, but I'm having trouble with the disconnect between a job and a part...
What you're doing sounds awfully similar to what I'm trying to do.
Thanks,
-Jason
--- In vantage@yahoogroups.com, "Chris Henzel" <chrish@...> wrote:
>
> Thanks Rob, works perfectly.
>
>
>
>
>
>
>
> From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
> Of Rob Bucek
> Sent: 03 February 2011 15:58
> To: vantage@yahoogroups.com
> Subject: RE: [Vantage] BPM to check if part on hold exists as job
> assembly
>
>
>
>
>
> For the life of me I cant remember what form an user places a part on
> hold in.. but.. whatever form that is, typically my approach is to
> start with the tt - table in that form that holds the part number in
> question, from there, link that table to your JobAsmbl table so.. (in
> this example ill assume the part table)
>
> Try,
>
> For each ttPart where ttPart.RowMod = 'U' and ttPart.(holdfield) = True
> no-lock,
>
> each JobAsmbl where JobAsmbl.Company = ttPart.Company and
> JobAsmbl.PartNum = ttpart.PartNum ,
>
> each JobHead where JobAsmbl.Company = JobHead.Company and
> JobAsmbl.JobNum = JobHead.JobNum ) and JobHead.JobClosed = FALSE.
>
> I didn't have any time to do more investigation than off the top of my
> head.. but may get you closer..
>
> Rob Bucek
>
> Production Control Manager
>
> PH: (715) 284-5376 ext 311
>
> Mobile: (715)896-0590
>
> FAX: (715)284-4084
>
> <http://www.dsmfg.com/>
>
> (Click the logo to view our site) <http://www.dsmfg.com/>
>
> From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
> [mailto:vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ] On
> Behalf
> Of Chris Henzel
> Sent: Wednesday, February 02, 2011 1:34 PM
> To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
> Subject: RE: [Vantage] BPM to check if part on hold exists as job
> assembly
>
> The query I have is:
>
> for each JobAsmbl no-lock where (JobAsmbl.Company = ttPart.Company and
> JobAsmbl.PartNum = ttpart.PartNum) ,
>
> each JobHead no-lock where (JobAsmbl.Company = JobHead.Company and
> JobAsmbl.JobNum = JobHead.JobNum ) and JobHead.JobClosed = FALSE
>
> I've also added the ttPart table through the BAQ editor but this gave me
> a BPM execution error. I'm not sure which attempt was closer to what's
> required.
>
> Thanks
>
> 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 Rob Bucek
> Sent: 02 February 2011 15:25
> To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
> <mailto:vantage%40yahoogroups.com>
> Subject: RE: [Vantage] BPM to check if part on hold exists as job
> assembly
>
> What is your query so far?
>
> Rob Bucek
>
> Production Control Manager
>
> PH: (715) 284-5376 ext 311
>
> Mobile: (715)896-0590
>
> FAX: (715)284-4084
>
> <http://www.dsmfg.com/>
>
> (Click the logo to view our site) <http://www.dsmfg.com/>
>
> 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 Chris Henzel
> Sent: Wednesday, February 02, 2011 8:15 AM
> To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
> <mailto:vantage%40yahoogroups.com>
> <mailto:vantage%40yahoogroups.com>
> Subject: [Vantage] BPM to check if part on hold exists as job assembly
>
> I'm trying to write a BPM that will notify our production dept if a part
> is placed from hold and we currently have the part in manufacture.
>
> So far I have a BPM that fires if a manufactured part is placed on hold
> and this sends an email. I'd like to add a condition so that it only
> fires if the part in question exists in a job assembly record related to
> an open job.
>
> This is where I've got stuck. I don't seem to be able to use
> ttpart.partnum within the query as it wants a constant rather than a
> field name.
>
> [Non-text portions of this message have been removed]
>
> Chris Henzel
> Epicor 9 Project Manager
> Tel: +44 (0)1582 436150
> Mob: 07836 314164
>
> This message contains confidential information and is intended only for
> the intended recipients. If you are not an intended recipient you should
> not disseminate, distribute or copy this email. Please notify the sender
> if you have received this email by mistake and delete it from your
> system.Email transmission cannot be guaranteed to be secure or
> error-free as information could be intercepted, corrupted, lost,
> destroyed, arrive late or incomplete, or contain viruses. The sender
> does not accept liability for any errors or omissions in the contents of
> this message, which arise as a result of email transmission. Registered
> Office: Hayward Tyler Ltd, 1 Kimpton Road, Luton, LU1 3LD, England. Tel:
> +44 (0)1582 731144. Company No. 3450138.
>
> [Non-text portions of this message have been removed]
>
> [Non-text portions of this message have been removed]
>
>
>
>
> Chris Henzel Epicor 9 Project Manager Tel: +44 (0)1582 436150 Mob: 07836 314164
>
>
>
> [Non-text portions of this message have been removed]
>