Check for Duplicate customer PO on Sales Order

Yahoo Archive
1
Brian,

Talk about a DUH moment... never even thought to look there. As it turns out, though, that's a hard stop and there are times when we actually want to use a PO number on multiple orders.

Thanks!

Ernie

--- In vantage@yahoogroups.com, "Brian Roberts" <broberts@...> wrote:
>
> Have you looked at this instead? Customer Maintenance, Detail tab, the
> "Check Dup PO" field. Sounds like what you want.
>
> Brian.
>
>
>
> ________________________________
>
> From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
> Of Elizabeth
> Sent: Tuesday, April 12, 2011 10:20 AM
> To: vantage@yahoogroups.com
> Subject: [Vantage] Check for Duplicate customer PO on Sales Order
>
>
>
>
>
> I'm trying to add a warning message if a sales rep uses a customer PO
> Number on multiple sales orders. The query works when I run it outside
> the Data Directive, and it seems to kick off during sales order entry
> (at least the hourglass takes longer when the BPM is enabled), but I
> don't get the warning message.
>
> Data Directive, OrderHed table, In-Transaction
> Condition: Number of rows in query is more than 0
> Query:
> for each ttOrderHed no-lock , each OrderHed where ttOrderHed.Company =
> OrderHed.Company AND ttOrderHed.CustNum = OrderHed.CustNum AND
> ttOrderHed.PONum = OrderHed.PONum
> Action : raise exception (I'll change that to show a warning once it's
> working)
>
> What am I missing?
>
> Ernie Lowell
> Diba Industries
>
>
>
>
>
> [Non-text portions of this message have been removed]
>
2
I'm trying to add a warning message if a sales rep uses a customer PO Number on multiple sales orders. The query works when I run it outside the Data Directive, and it seems to kick off during sales order entry (at least the hourglass takes longer when the BPM is enabled), but I don't get the warning message.

Data Directive, OrderHed table, In-Transaction
Condition: Number of rows in query is more than 0
Query:
for each ttOrderHed no-lock , each OrderHed where ttOrderHed.Company = OrderHed.Company AND ttOrderHed.CustNum = OrderHed.CustNum AND ttOrderHed.PONum = OrderHed.PONum
Action : raise exception (I'll change that to show a warning once it's working)

What am I missing?

Ernie Lowell
Diba Industries
3
Have you looked at this instead? Customer Maintenance, Detail tab, the
"Check Dup PO" field. Sounds like what you want.

Brian.



________________________________

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of Elizabeth
Sent: Tuesday, April 12, 2011 10:20 AM
To: vantage@yahoogroups.com
Subject: [Vantage] Check for Duplicate customer PO on Sales Order





I'm trying to add a warning message if a sales rep uses a customer PO
Number on multiple sales orders. The query works when I run it outside
the Data Directive, and it seems to kick off during sales order entry
(at least the hourglass takes longer when the BPM is enabled), but I
don't get the warning message.

Data Directive, OrderHed table, In-Transaction
Condition: Number of rows in query is more than 0
Query:
for each ttOrderHed no-lock , each OrderHed where ttOrderHed.Company =
OrderHed.Company AND ttOrderHed.CustNum = OrderHed.CustNum AND
ttOrderHed.PONum = OrderHed.PONum
Action : raise exception (I'll change that to show a warning once it's
working)

What am I missing?

Ernie Lowell
Diba Industries





[Non-text portions of this message have been removed]
4
I am using a method directive, with the query in the condition: number of rows in the 'DupPoCheck' query is not less than 1,
And in the query, in addition to what you have listed: And ttOrderHed.OrderNum <> OrderHed.OrderNum

Kristi Stump
ITW Food Equipment Group

________________________________
Disclaimer - This email and any files transmitted with it are confidential and contain privileged or copyrighted information. You must not present this message to another party without first gaining permission from the sender. If you are not the intended recipient, you must not copy, print, distribute or use this email or the information contained in it for any purpose other than to notify us.

If you received this email in error, please notify the sender immediately and delete this email from your system. We do not guarantee that this email is free from viruses or any other defects although due care has been taken to minimize the risk.


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

That did it. Thanks!

Ernie

--- In vantage@yahoogroups.com, Kristi Stump <kristi.stump@...> wrote:
>
> I am using a method directive, with the query in the condition: number of rows in the 'DupPoCheck' query is not less than 1,
> And in the query, in addition to what you have listed: And ttOrderHed.OrderNum <> OrderHed.OrderNum
>
> Kristi Stump
> ITW Food Equipment Group
>
> ________________________________
> Disclaimer - This email and any files transmitted with it are confidential and contain privileged or copyrighted information. You must not present this message to another party without first gaining permission from the sender. If you are not the intended recipient, you must not copy, print, distribute or use this email or the information contained in it for any purpose other than to notify us.
>
> If you received this email in error, please notify the sender immediately and delete this email from your system. We do not guarantee that this email is free from viruses or any other defects although due care has been taken to minimize the risk.
>
>
> [Non-text portions of this message have been removed]
>