Sales Order Due Dates in TimePhase

Hi Joe,

Are you also changing the dates on the OrderDtl and OrderRel tables?

If that's not where it's coming from try PartDtl.DueDate.


Nigel.


--- In vantage@yahoogroups.com, "Rojas, Joe" <joe.rojas@...> wrote:
>
> When looking at Time Phase, where do the Due Dates come for Sales
> Orders?
>
> We are trying to update Sales Orders in a test environment using ODBC to
> set the Ship By date to equal the Need By date.
>
> When we do this, the Due Date in Time Phase, and Job Manager, still show
> the old date.
>
>
>
> Joe Rojas
>
> Information Technology Manager
>
> Symmetry Medical New Bedford
>
> P: 508.998.4575
>
> M:508.838.4717
>
> F:508.995.9597
>
> joe.rojas@... <mailto:joe.rojas@...>
>
>
>
>
>
> [Non-text portions of this message have been removed]
>
I need a little nudge in the right direction with a condition I am
working on. I have 2 nodes of data that I am working with(node1 and
node2). If node1 = '1', I want to pass the data in node2
CancelAfterDate. If node1='2', then I want to pass the data in node2
to RequestDate. Can that be done with a Functoid, or do I need to use
a choice or condition? It has got me stumped...



Matt Caldwell
Technical Support Analyst

KERUSSO
P.O. Box 32
Berryville, AR 72616
Phone: 800-424-0943 Ext. 231 or 870-480-4530
Fax: 870-423-3568
Web Site: http://www.kerusso.com
******************************************************************
CONFIDENTIALITY STATEMENT:
This message, from Kerusso Inc., contains information
which is privileged and confidential and is solely for the use of
the intended recipient. If you are not the intended recipient, be
aware that any review, disclosure, copying, distribution, or use
of the contents of this message is strictly prohibited. If you have
received this in error, please destroy it and notify us immediately
at: 800-424-0943
******************************************************************





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

This is very similar to a question I asked Epicor last week. In my version, I wanted to compare two values, and if the first was higher, put the absolute difference in the over node, and if the second was higher, put the absolute difference in the under node.

Their answer was to create multiple branches off the choice element, using a configuration for each potential outcome. I didn't quite grasp everything the first time through, and wound up using a second choice element but I'm sure it can be done, but it's done withing the choice element, not the XPATH.

Hope this helps.

Jim Pratt
Vantage 8.03.404B

--- In vantage@yahoogroups.com, "Matt Caldwell" <matt@...> wrote:
>
> I need a little nudge in the right direction with a condition I am
> working on. I have 2 nodes of data that I am working with(node1 and
> node2). If node1 = '1', I want to pass the data in node2
> CancelAfterDate. If node1='2', then I want to pass the data in node2
> to RequestDate. Can that be done with a Functoid, or do I need to use
> a choice or condition? It has got me stumped...
>
>
>
> Matt Caldwell
> Technical Support Analyst
>
> KERUSSO
> P.O. Box 32
> Berryville, AR 72616
> Phone: 800-424-0943 Ext. 231 or 870-480-4530
> Fax: 870-423-3568
> Web Site: http://www.kerusso.com
> ******************************************************************
> CONFIDENTIALITY STATEMENT:
> This message, from Kerusso Inc., contains information
> which is privileged and confidential and is solely for the use of
> the intended recipient. If you are not the intended recipient, be
> aware that any review, disclosure, copying, distribution, or use
> of the contents of this message is strictly prohibited. If you have
> received this in error, please destroy it and notify us immediately
> at: 800-424-0943
> ******************************************************************
>
>
>
>
>
> [Non-text portions of this message have been removed]
>
I thought the choice element was just a GUI that wrote an xpath
statement.



Rob Bucek

Manufacturing Engineer

PH: 715-284-5376 ext 311

FAX: 715-284-4084

<http://www.dsmfg.com/>

(Click the logo to view our site)



________________________________

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of jmpratt7
Sent: Monday, May 04, 2009 9:55 AM
To: vantage@yahoogroups.com
Subject: [Vantage] Re: Service Connect condition help





Matt,

This is very similar to a question I asked Epicor last week. In my
version, I wanted to compare two values, and if the first was higher,
put the absolute difference in the over node, and if the second was
higher, put the absolute difference in the under node.

Their answer was to create multiple branches off the choice element,
using a configuration for each potential outcome. I didn't quite grasp
everything the first time through, and wound up using a second choice
element but I'm sure it can be done, but it's done withing the choice
element, not the XPATH.

Hope this helps.

Jim Pratt
Vantage 8.03.404B

--- In vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ,
"Matt Caldwell" <matt@...> wrote:
>
> I need a little nudge in the right direction with a condition I am
> working on. I have 2 nodes of data that I am working with(node1 and
> node2). If node1 = '1', I want to pass the data in node2
> CancelAfterDate. If node1='2', then I want to pass the data in node2
> to RequestDate. Can that be done with a Functoid, or do I need to use
> a choice or condition? It has got me stumped...
>
>
>
> Matt Caldwell
> Technical Support Analyst
>
> KERUSSO
> P.O. Box 32
> Berryville, AR 72616
> Phone: 800-424-0943 Ext. 231 or 870-480-4530
> Fax: 870-423-3568
> Web Site: http://www.kerusso.com <http://www.kerusso.com>
> ******************************************************************
> CONFIDENTIALITY STATEMENT:
> This message, from Kerusso Inc., contains information
> which is privileged and confidential and is solely for the use of
> the intended recipient. If you are not the intended recipient, be
> aware that any review, disclosure, copying, distribution, or use
> of the contents of this message is strictly prohibited. If you have
> received this in error, please destroy it and notify us immediately
> at: 800-424-0943
> ******************************************************************
>
>
>
>
>
> [Non-text portions of this message have been removed]
>





[Non-text portions of this message have been removed]
I figured it out. I used a Link Condition. I was browsing aimlessly
through the service connect user guide and found my answer on page 69,
dude. I setup the condition, and it appears to work just fine.



From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of jmpratt7
Sent: Monday, May 04, 2009 9:55 AM
To: vantage@yahoogroups.com
Subject: [Vantage] Re: Service Connect condition help








Matt,

This is very similar to a question I asked Epicor last week. In my
version, I wanted to compare two values, and if the first was higher,
put the absolute difference in the over node, and if the second was
higher, put the absolute difference in the under node.

Their answer was to create multiple branches off the choice element,
using a configuration for each potential outcome. I didn't quite grasp
everything the first time through, and wound up using a second choice
element but I'm sure it can be done, but it's done withing the choice
element, not the XPATH.

Hope this helps.

Jim Pratt
Vantage 8.03.404B

--- In vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ,
"Matt Caldwell" <matt@...> wrote:
>
> I need a little nudge in the right direction with a condition I am
> working on. I have 2 nodes of data that I am working with(node1 and
> node2). If node1 = '1', I want to pass the data in node2
> CancelAfterDate. If node1='2', then I want to pass the data in node2
> to RequestDate. Can that be done with a Functoid, or do I need to use
> a choice or condition? It has got me stumped...
>
>
>
> Matt Caldwell
> Technical Support Analyst
>
> KERUSSO
> P.O. Box 32
> Berryville, AR 72616
> Phone: 800-424-0943 Ext. 231 or 870-480-4530
> Fax: 870-423-3568
> Web Site: http://www.kerusso.com
> ******************************************************************
> CONFIDENTIALITY STATEMENT:
> This message, from Kerusso Inc., contains information
> which is privileged and confidential and is solely for the use of
> the intended recipient. If you are not the intended recipient, be
> aware that any review, disclosure, copying, distribution, or use
> of the contents of this message is strictly prohibited. If you have
> received this in error, please destroy it and notify us immediately
> at: 800-424-0943
> ******************************************************************
>
>
>
>
>
> [Non-text portions of this message have been removed]
>





[Non-text portions of this message have been removed]
When looking at Time Phase, where do the Due Dates come for Sales
Orders?

We are trying to update Sales Orders in a test environment using ODBC to
set the Ship By date to equal the Need By date.

When we do this, the Due Date in Time Phase, and Job Manager, still show
the old date.



Joe Rojas

Information Technology Manager

Symmetry Medical New Bedford

P: 508.998.4575

M:508.838.4717

F:508.995.9597

joe.rojas@... <mailto:joe.rojas@...>





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