BPM - Stop Receipt if PO is on hold

Yahoo Archive
1
Use not less than 1 AND use the following for your query



for each ttRcvHead no-lock:

each POHeader where POHeader.Company = ttRcvHead.Company and '%poNum%' =
POHeader.PONum and POHeader.OrderHeld = True



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@yahoogroups.com] On Behalf
Of Norman Hutchins
Sent: Wednesday, May 18, 2011 4:33 PM
To: Vantage Yahoo Group
Subject: [Vantage] BPM - Stop Receipt if PO is on hold





Hello fellow Epicor people,

I've been fighting with a BPM to stop someone from entering a receipt of
a
PO that is on hold, for a few days now and I'm not making any progress.

He's what I've tried;

I used a pre-process on *Receipt.GetPOInfo*, which is the 1st method
that
gets run when you put a PO number in and it brings up the Vendor Info
and
using a condition of "*a number of rows in the 'Check PO Hold' query is
not
more than 0*" the syntec for the query is;

*for each ttRcvHead no-lock , each POHeader no-lock where
(ttRcvHead.Company = POHeader.Company and ttRcvHead.PONum =
POHeader.PONum)
and POHeader.OrderHeld = TRUE*

I used a raise exception, saying that the PO in on Hold.

This doesn't work, if I set the condition to equal 0, instead of is not
more
then, I can get the exception to show, so I know it's the right method.
What I think is happening is that the ttRcvHead.PONum is not populated
with
the PO number so the query isn't running.

Anyone have any idea's? Or done this already that might be able to help
me
out?

Thanks,

Norman Hutchins
System Administrator
Howell Laboratories, Inc.

This email was sent by Howell Laboratories, Inc. or Shively Labs. It may
contain information that is confidential or privileged. If you suspect
you were not intended to receive it, please delete it without copying or
forwarding it, and notify the sender by reply email or by calling
207-647-3327.

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





[Non-text portions of this message have been removed]
2
Hello fellow Epicor people,

I've been fighting with a BPM to stop someone from entering a receipt of a
PO that is on hold, for a few days now and I'm not making any progress.

He's what I've tried;

I used a pre-process on *Receipt.GetPOInfo*, which is the 1st method that
gets run when you put a PO number in and it brings up the Vendor Info and
using a condition of "*a number of rows in the 'Check PO Hold' query is not
more than 0*" the syntec for the query is;

*for each ttRcvHead no-lock , each POHeader no-lock where
(ttRcvHead.Company = POHeader.Company and ttRcvHead.PONum = POHeader.PONum)
and POHeader.OrderHeld = TRUE*


I used a raise exception, saying that the PO in on Hold.

This doesn't work, if I set the condition to equal 0, instead of is not more
then, I can get the exception to show, so I know it's the right method.
What I think is happening is that the ttRcvHead.PONum is not populated with
the PO number so the query isn't running.

Anyone have any idea's? Or done this already that might be able to help me
out?

Thanks,

Norman Hutchins
System Administrator
Howell Laboratories, Inc.

This email was sent by Howell Laboratories, Inc. or Shively Labs. It may contain information that is confidential or privileged. If you suspect you were not intended to receive it, please delete it without copying or forwarding it, and notify the sender by reply email or by calling 207-647-3327.


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