Thank you.
________________________________
From: Rob Bucek <rbucek@...>
To: vantage@yahoogroups.com
Sent: Wednesday, June 24, 2009 8:12:18 AM
Subject: RE: [Vantage] Check Order Lines
I haven't had a need for any BPM's at the sales order level yet so I
can't tell you the business object, the method may be Update. You'd
have to investigate that through tracing.. Probably using a number of
rows in the designed query is not < 1, I think I'd take a stab at the
following;
For each ttOrderDtl where RowMod = 'A' no-lock,
Each OrderDtl where ttOrderDtl.Company = OrderDtl.Company and
ttOrderDtl.OrderNum = OrderDtl.OrderNum and ttOrderDtl.OrderLin e =
OrderDtl.OrderLine and (ttOrderDtl. PartNum = OrderDtl.PartNum and
ttOrderDtl.SellingQ uantity = OrderDtl.SellingQua ntity and
ttOrderDtl.NeedByDa te = OrderDtl.NeedByDate )
I haven't tested any of this out, but that would be my first attempt...
what you're asking to do shouldn't be too difficult, unless some of the
Order detail is calling some sub process I'm not aware of and proves
difficult to trap. Email me offline if you're struggling with finding
the BO/Method, I might have time later this week to do more detailed
investigation.
Hope this helps get you started..
From: vantage@yahoogroups .com [mailto:vantage@yahoogroups .com] On Behalf
Of Bartosz Niemczewski
Sent: Wednesday, June 24, 2009 7:30 AM
To: vantage@yahoogroups .com
Subject: Re: [Vantage] Check Order Lines
Rob,
Yes, this is what I am looking
____________ _________ _________ __
From: Rob Bucek <rbucek@dsmfg. com <mailto:rbucek% 40dsmfg.com> >
To: vantage@yahoogroups .com <mailto:vantage% 40yahoogroups. com>
Sent: Tuesday, June 23, 2009 6:50:01 PM
Subject: RE: [Vantage] Check Order Lines
Ok, to restate what you are after, you're looking to try and avoid
duplicate releases..match part, need by date, and quantity on previous
release lines matched to the newly created release.
From: vantage@yahoogroups .com [mailto:vantage@ yahoogroups .com] On
Behalf
Of Bartosz Niemczewski
Sent: Tuesday, June 23, 2009 5:12 PM
To: vantage@yahoogroups .com
Subject: Re: [Vantage] Check Order Lines
Sorry, I didn't write clearly. What I am looking for is to find the same
release line after click save button. For us the same release line is
release line which has the same Need By Date and Quantity. We'd like to
show warning message after click save button.
Thank you.
____________ _________ _________ __
From: Rob Bucek <rbucek@dsmfg. com <mailto:rbucek% 40dsmfg.com> >
To: vantage@yahoogroups .com <mailto:vantage% 40yahoogroups. com>
Sent: Tuesday, June 23, 2009 4:19:05 PM
Subject: RE: [Vantage] Check Order Lines
Doesn't sound too tough...just curious, what is your business case?
Using your Job header info you would cycle thru each orderdtl (not
ttorderdtl) and using a couple defined variables based on your
information from your newly created line (ttorderdtl) check that
condition.
From: vantage@yahoogroups .com [mailto:vantage@ yahoogroups .com] On
Behalf
Of Bartosz Niemczewski
Sent: Tuesday, June 23, 2009 1:58 PM
To: Vantage Group
Subject: [Vantage] Check Order Lines
Hello,
When I create new order line (e.g. Line number 10) , I'd like to check
if the other 9 lines are different than the 10th line. I chose Part
Number and Need By Date fields as a fields to compare. Does anyone have
any idea how to do it? I was starting with BPM.
Thank you.
Bart.
[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]
[Non-text portions of this message have been removed]
[Non-text portions of this message have been removed]
________________________________
From: Rob Bucek <rbucek@...>
To: vantage@yahoogroups.com
Sent: Wednesday, June 24, 2009 8:12:18 AM
Subject: RE: [Vantage] Check Order Lines
I haven't had a need for any BPM's at the sales order level yet so I
can't tell you the business object, the method may be Update. You'd
have to investigate that through tracing.. Probably using a number of
rows in the designed query is not < 1, I think I'd take a stab at the
following;
For each ttOrderDtl where RowMod = 'A' no-lock,
Each OrderDtl where ttOrderDtl.Company = OrderDtl.Company and
ttOrderDtl.OrderNum = OrderDtl.OrderNum and ttOrderDtl.OrderLin e =
OrderDtl.OrderLine and (ttOrderDtl. PartNum = OrderDtl.PartNum and
ttOrderDtl.SellingQ uantity = OrderDtl.SellingQua ntity and
ttOrderDtl.NeedByDa te = OrderDtl.NeedByDate )
I haven't tested any of this out, but that would be my first attempt...
what you're asking to do shouldn't be too difficult, unless some of the
Order detail is calling some sub process I'm not aware of and proves
difficult to trap. Email me offline if you're struggling with finding
the BO/Method, I might have time later this week to do more detailed
investigation.
Hope this helps get you started..
From: vantage@yahoogroups .com [mailto:vantage@yahoogroups .com] On Behalf
Of Bartosz Niemczewski
Sent: Wednesday, June 24, 2009 7:30 AM
To: vantage@yahoogroups .com
Subject: Re: [Vantage] Check Order Lines
Rob,
Yes, this is what I am looking
____________ _________ _________ __
From: Rob Bucek <rbucek@dsmfg. com <mailto:rbucek% 40dsmfg.com> >
To: vantage@yahoogroups .com <mailto:vantage% 40yahoogroups. com>
Sent: Tuesday, June 23, 2009 6:50:01 PM
Subject: RE: [Vantage] Check Order Lines
Ok, to restate what you are after, you're looking to try and avoid
duplicate releases..match part, need by date, and quantity on previous
release lines matched to the newly created release.
From: vantage@yahoogroups .com [mailto:vantage@ yahoogroups .com] On
Behalf
Of Bartosz Niemczewski
Sent: Tuesday, June 23, 2009 5:12 PM
To: vantage@yahoogroups .com
Subject: Re: [Vantage] Check Order Lines
Sorry, I didn't write clearly. What I am looking for is to find the same
release line after click save button. For us the same release line is
release line which has the same Need By Date and Quantity. We'd like to
show warning message after click save button.
Thank you.
____________ _________ _________ __
From: Rob Bucek <rbucek@dsmfg. com <mailto:rbucek% 40dsmfg.com> >
To: vantage@yahoogroups .com <mailto:vantage% 40yahoogroups. com>
Sent: Tuesday, June 23, 2009 4:19:05 PM
Subject: RE: [Vantage] Check Order Lines
Doesn't sound too tough...just curious, what is your business case?
Using your Job header info you would cycle thru each orderdtl (not
ttorderdtl) and using a couple defined variables based on your
information from your newly created line (ttorderdtl) check that
condition.
From: vantage@yahoogroups .com [mailto:vantage@ yahoogroups .com] On
Behalf
Of Bartosz Niemczewski
Sent: Tuesday, June 23, 2009 1:58 PM
To: Vantage Group
Subject: [Vantage] Check Order Lines
Hello,
When I create new order line (e.g. Line number 10) , I'd like to check
if the other 9 lines are different than the 10th line. I chose Part
Number and Need By Date fields as a fields to compare. Does anyone have
any idea how to do it? I was starting with BPM.
Thank you.
Bart.
[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]
[Non-text portions of this message have been removed]
[Non-text portions of this message have been removed]