Hello Kevin
I am not using E9, I am using Vantage 8.03.408B. I don't know what you suggested
could be possible in the version which we are using.
Sreejith
________________________________
From: Kevin Simon <simstrak@...>
To: vantage@yahoogroups.com
Sent: Mon, July 18, 2011 4:36:06 PM
Subject: RE: [Vantage] Re: How to get the data in the User Defined field in SO
Entry to be displayed in a User Defined Field in Job Entry?
Sreejith,
If you’re running E9, then put an “In Transaction†data directive on the JobHead
table, with a condition on “at least one added row…â€. You can then add some
code to read the order and set the data on the job header you need.
Kevin Simon
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of
Sreejith Jaganathan
Sent: Monday, July 18, 2011 5:52 AM
To: vantage@yahoogroups.com
Subject: Re: [Vantage] Re: How to get the data in the User Defined field in SO
Entry to be displayed in a User Defined Field in Job Entry?
Hi Friends
For the above said issue I did the following
Customized field in Sales Order Entry under the tab line Data Source - OrderDtl;
Data Field - Character01
Customised field in Job Entry under the tab MakeToOrder Data Source -
MakeToOrder Data Field - ShortChar01
I went to data tools and then selected the View MakeToOrder
Under Custom Column Like in Available Views I selected MakeToOrder and then
under the Available Columns I selected ShortChar01 then in LIKE COLOMUN VALUE I
gave OrderDtl.Character01
After doing the above I was not able to view the data which I was putting in my
customised field in the Sales Order Entry.
Any help is highly appreciable. Please do let me know if any process to be run
at the server end.
Regards
Sreejith J
________________________________
From: mmcwilliams22 <mmcwilliams22@... <mailto:mmcwilliams22%40yahoo.com>
Sent: Wed, June 29, 2011 4:49:54 PM
Subject: [Vantage] Re: How to get the data in the User Defined field in SO Entry
to be displayed in a User Defined Field in Job Entry?
Use the data tools and create a Foreign Key View to the OrderHed then
create a subtable view below that to OrderDetail.
--- In vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> , Sreejith
Jaganathan <sreesvantagedoubts@...>
wrote:
Kindly help me to know how to get the data in the User Defined field in SO Entry
to be displayed in a User Defined Field in Job Entry. I defined a user defined
field in the SO Entry under the tab LINES I want the same information to be
displayed in a user defined area in JOB ENTRY under the tab MAKE TO ORDER. I
see a table MAKE TO ORDER when I select the data source. But when I run the
query SELECT * from MAKETOORDER it displays an error and says such table does
not exist.
Kindly help me to sort out the issue.
Regards
Sreejith J
[Non-text portions of this message have been removed]
I am not using E9, I am using Vantage 8.03.408B. I don't know what you suggested
could be possible in the version which we are using.
Sreejith
________________________________
From: Kevin Simon <simstrak@...>
To: vantage@yahoogroups.com
Sent: Mon, July 18, 2011 4:36:06 PM
Subject: RE: [Vantage] Re: How to get the data in the User Defined field in SO
Entry to be displayed in a User Defined Field in Job Entry?
Sreejith,
If you’re running E9, then put an “In Transaction†data directive on the JobHead
table, with a condition on “at least one added row…â€. You can then add some
code to read the order and set the data on the job header you need.
Kevin Simon
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of
Sreejith Jaganathan
Sent: Monday, July 18, 2011 5:52 AM
To: vantage@yahoogroups.com
Subject: Re: [Vantage] Re: How to get the data in the User Defined field in SO
Entry to be displayed in a User Defined Field in Job Entry?
Hi Friends
For the above said issue I did the following
Customized field in Sales Order Entry under the tab line Data Source - OrderDtl;
Data Field - Character01
Customised field in Job Entry under the tab MakeToOrder Data Source -
MakeToOrder Data Field - ShortChar01
I went to data tools and then selected the View MakeToOrder
Under Custom Column Like in Available Views I selected MakeToOrder and then
under the Available Columns I selected ShortChar01 then in LIKE COLOMUN VALUE I
gave OrderDtl.Character01
After doing the above I was not able to view the data which I was putting in my
customised field in the Sales Order Entry.
Any help is highly appreciable. Please do let me know if any process to be run
at the server end.
Regards
Sreejith J
________________________________
From: mmcwilliams22 <mmcwilliams22@... <mailto:mmcwilliams22%40yahoo.com>
>To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
Sent: Wed, June 29, 2011 4:49:54 PM
Subject: [Vantage] Re: How to get the data in the User Defined field in SO Entry
to be displayed in a User Defined Field in Job Entry?
Use the data tools and create a Foreign Key View to the OrderHed then
create a subtable view below that to OrderDetail.
--- In vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> , Sreejith
Jaganathan <sreesvantagedoubts@...>
wrote:
>Dear Friends;
Kindly help me to know how to get the data in the User Defined field in SO Entry
to be displayed in a User Defined Field in Job Entry. I defined a user defined
field in the SO Entry under the tab LINES I want the same information to be
displayed in a user defined area in JOB ENTRY under the tab MAKE TO ORDER. I
see a table MAKE TO ORDER when I select the data source. But when I run the
query SELECT * from MAKETOORDER it displays an error and says such table does
not exist.
Kindly help me to sort out the issue.
Regards
Sreejith J
[Non-text portions of this message have been removed]