Populate URAT

Kenneth_Elder

Member
Is there a file I can populate the URAT (User Defined Field) that will move
to the SDURAT field in the F4211 so I can use at order entry time? We have
a situation where we need to calculate our adjustment amount from the
combination of percent off Suggested and Wholesale amount. I could do this
using the formula in Advanced pricing if Advanced pricing can gain access
to Suggested Retail price. Any help with this would be appreciated.
Thanks.
 
--------------0E7AD1A246617F8AFBEFFB13
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit

Hi,

I had the same kind of chalange recently.

First some background info: JDE creates an order by calling several Master Business
Functions: Begin Doc (B4200310.C) , Edit Line (B4200311.C) and End Doc (B4200310.C).
Begin Doc 'creates' the Order Header, Edit Line 'creates' the Order Line. This is done
in workfiles (F42UI01, F42UI02, F42UI11, F42UI12) that can be physical files or Cache
files. The End Doc functions creates or changes the actual F4201 and F4211 records
from the records in these workfiles.

Now to the chalange part. If a order is created or changed, the UserReserved Fields
are passed as parameters to these functions, but are NOT stored in the workfiles. When
the grid of the Sales Order Detail Revisions Form is filled, the UserReserved fields
(which are hidden fields in the grid) are also NOT filled.

So if you want to use these fields you have to do several things:
1. In Write Grid Line Before or Grid Record is fetched event of the Sales Order Detail
Revisions Form you have to get the UserReserved fields from F4211 and store these in
the grid.
2. Change the values you want in the User Reserved fields in the grid.
3. Store the value of the UserReserved fields of the grid in the Work File or Cache.

Point 3 is the difficult one. JDE calls the Edit Line and End Doc functions
Asynchrone. This means that you don't know when the records are actually in the
workfiles/cache and you can not use the events that call these MBF's to manipulate
anything. To achieve what you want I think you can do 2 things: change the MBF's so
they will also store the UserReserved Parameters (I was told not to do this) or in the
OK Button Clicked event (OK processing is started when alle the running asynchrone
functions are finished) get all the grid records and store the User Reserved fields in
the WorkFile or Cache. If the UserReserved Fields in the workfiles/cache are filled,
they will be stored in F4201 and F4211.

If anyone has a better solution, please let us know.

Hope this makes any sence.

Marcel Tuik.


Kenneth_Elder wrote:

> Is there a file I can populate the URAT (User Defined Field) that will move
> to the SDURAT field in the F4211 so I can use at order entry time? We have
> a situation where we need to calculate our adjustment amount from the
> combination of percent off Suggested and Wholesale amount. I could do this
> using the formula in Advanced pricing if Advanced pricing can gain access
> to Suggested Retail price. Any help with this would be appreciated.
> Thanks.
>
> --------------------------
> To view this thread, visit the JDEList forum at:
> http://198.144.193.139/cgi-bin/wwwthreads/showflat.pl?Cat=0&Board=OWDEV&Number=149
> *************************************************************
> This is the JDEList One World Developers Mailing List.
> Archives and information on how to SUBSCRIBE, and
> UNSUBSCRIBE can be found at http://www.JDELIST.com
> *************************************************************

--------------0E7AD1A246617F8AFBEFFB13
Content-Type: text/html; charset=us-ascii
Content-Transfer-Encoding: 7bit

<!doctype html public "-//w3c//dtd html 4.0 transitional//en">
<html>
Hi,


I had the same kind of chalange recently.


First some background info: JDE creates an order by calling several
Master Business Functions: Begin Doc (B4200310.C) , Edit Line (B4200311.C)
and End Doc (B4200310.C). Begin Doc 'creates' the Order Header, Edit Line
'creates' the Order Line. This is done in workfiles (F42UI01, F42UI02,
F42UI11, F42UI12) that can be physical files or Cache files. The End Doc
functions creates or changes the actual F4201 and F4211 records from the
records in these workfiles.


Now to the chalange part. If a order is created or changed, the UserReserved
Fields are passed as parameters to these functions, but are NOT stored
in the workfiles. When the grid of the Sales Order Detail Revisions Form
is filled, the UserReserved fields (which are hidden fields in the grid)
are also NOT filled.


So if you want to use these fields you have to do several things:

1. In Write Grid Line Before or Grid Record is fetched event of the
Sales Order Detail Revisions Form you have to get the UserReserved fields
from F4211 and store these in the grid.

2. Change the values you want in the User Reserved fields in the grid.

3. Store the value of the UserReserved fields of the grid in the Work
File or Cache.


Point 3 is the difficult one. JDE calls the Edit Line and End Doc functions
Asynchrone. This means that you don't know when the records are actually
in the workfiles/cache and you can not use the events that call these MBF's
to manipulate anything. To achieve what you want I think you can do 2 things:
change the MBF's so they will also store the UserReserved Parameters (I
was told not to do this) or in the OK Button Clicked event (OK processing
is started when alle the running asynchrone functions are finished) get
all the grid records and store the User Reserved fields in the WorkFile
or Cache. If the UserReserved Fields in the workfiles/cache are filled,
they will be stored in F4201 and F4211.


If anyone has a better solution, please let us know.


Hope this makes any sence.


Marcel Tuik.




Kenneth_Elder wrote:
<blockquote TYPE=CITE>Is there a file I can populate the URAT (User Defined
Field) that will move

to the SDURAT field in the F4211 so I can use at order entry time?
We have

a situation where we need to calculate our adjustment amount from the

combination of percent off Suggested and Wholesale amount. I
could do this

using the formula in Advanced pricing if Advanced pricing can gain
access

to Suggested Retail price. Any help with this would be appreciated.

Thanks.


--------------------------

To view this thread, visit the JDEList forum at:

http://198.144.193.139/cgi-bin/wwwthreads/showflat.pl?Cat=0&Board=OWDEV&Number=149

*************************************************************

This is the JDEList One World Developers Mailing List.

Archives and information on how to SUBSCRIBE, and

UNSUBSCRIBE can be found at http://www.JDELIST.com

*************************************************************</blockquote>
</html>

--------------0E7AD1A246617F8AFBEFFB13--
 
Hi,

There is an asynchrone BSFN call in the Post Button Clicked event of OK
button on the Sales Order Detail Revision Form, named: F4211 End Document.
I suppose, this BSFN will write the data into the database.
If so, you have to update the URAT fields in the corresponding records after
this BSFN call.
Making sure that all record have been written into the database, you have to
clear the Run Asynch check-box on the parameter window of F4211 End Document
call.

Maybe, you should have to handle the error status too.

Hope, it could help.

Zoltán Gyimesi
Synergon Ltd.
Hungary

>
 
Change the call to the MBF not to call asynchronousely - unclick the
checkbox. This is how we corrected this problem. Does anybody know if
this has CAUSED any problems?

marcel tuik wrote:

> --------------0E7AD1A246617F8AFBEFFB13
> Content-Type: text/plain; charset=us-ascii
> Content-Transfer-Encoding: 7bit
>
> Hi,
>
> I had the same kind of chalange recently.
>
> First some background info: JDE creates an order by calling several Master Business
> Functions: Begin Doc (B4200310.C) , Edit Line (B4200311.C) and End Doc (B4200310.C).
> Begin Doc 'creates' the Order Header, Edit Line 'creates' the Order Line. This is done
> in workfiles (F42UI01, F42UI02, F42UI11, F42UI12) that can be physical files or Cache
> files. The End Doc functions creates or changes the actual F4201 and F4211 records
> from the records in these workfiles.
>
> Now to the chalange part. If a order is created or changed, the UserReserved Fields
> are passed as parameters to these functions, but are NOT stored in the workfiles. When
> the grid of the Sales Order Detail Revisions Form is filled, the UserReserved fields
> (which are hidden fields in the grid) are also NOT filled.
>
> So if you want to use these fields you have to do several things:
> 1. In Write Grid Line Before or Grid Record is fetched event of the Sales Order Detail
> Revisions Form you have to get the UserReserved fields from F4211 and store these in
> the grid.
> 2. Change the values you want in the User Reserved fields in the grid.
> 3. Store the value of the UserReserved fields of the grid in the Work File or Cache.
>
> Point 3 is the difficult one. JDE calls the Edit Line and End Doc functions
> Asynchrone. This means that you don't know when the records are actually in the
> workfiles/cache and you can not use the events that call these MBF's to manipulate
> anything. To achieve what you want I think you can do 2 things: change the MBF's so
> they will also store the UserReserved Parameters (I was told not to do this) or in the
> OK Button Clicked event (OK processing is started when alle the running asynchrone
> functions are finished) get all the grid records and store the User Reserved fields in
> the WorkFile or Cache. If the UserReserved Fields in the workfiles/cache are filled,
> they will be stored in F4201 and F4211.
>
> If anyone has a better solution, please let us know.
>
> Hope this makes any sence.
>
> Marcel Tuik.
>
>
> Kenneth_Elder wrote:
>
>
>> Is there a file I can populate the URAT (User Defined Field) that will move
>> to the SDURAT field in the F4211 so I can use at order entry time? We have
>> a situation where we need to calculate our adjustment amount from the
>> combination of percent off Suggested and Wholesale amount. I could do this
>> using the formula in Advanced pricing if Advanced pricing can gain access
>> to Suggested Retail price. Any help with this would be appreciated.
>> Thanks.
>>
>> --------------------------
>> To view this thread, visit the JDEList forum at:
>> http://198.144.193.139/cgi-bin/wwwthreads/showflat.pl?Cat=0&Board=OWDEV&Number=149
>> *************************************************************
>> This is the JDEList One World Developers Mailing List.
>> Archives and information on how to SUBSCRIBE, and
>> UNSUBSCRIBE can be found at http://www.JDELIST.com
>> *************************************************************
>
> --------------0E7AD1A246617F8AFBEFFB13
> Content-Type: text/html; charset=us-ascii
> Content-Transfer-Encoding: 7bit
>
> <!doctype html public "-//w3c//dtd html 4.0 transitional//en">
> <html>
> Hi,
>

I had the same kind of chalange recently.
>

First some background info: JDE creates an order by calling several
> Master Business Functions: Begin Doc (B4200310.C) , Edit Line (B4200311.C)
> and End Doc (B4200310.C). Begin Doc 'creates' the Order Header, Edit Line
> 'creates' the Order Line. This is done in workfiles (F42UI01, F42UI02,
> F42UI11, F42UI12) that can be physical files or Cache files. The End Doc
> functions creates or changes the actual F4201 and F4211 records from the
> records in these workfiles.
>

Now to the chalange part. If a order is created or changed, the UserReserved
> Fields are passed as parameters to these functions, but are NOT stored
> in the workfiles. When the grid of the Sales Order Detail Revisions Form
> is filled, the UserReserved fields (which are hidden fields in the grid)
> are also NOT filled.
>

So if you want to use these fields you have to do several things:
>
> 1. In Write Grid Line Before or Grid Record is fetched event of the
> Sales Order Detail Revisions Form you have to get the UserReserved fields
> from F4211 and store these in the grid.
>
> 2. Change the values you want in the User Reserved fields in the grid.
>
> 3. Store the value of the UserReserved fields of the grid in the Work
> File or Cache.
>

Point 3 is the difficult one. JDE calls the Edit Line and End Doc functions
> Asynchrone. This means that you don't know when the records are actually
> in the workfiles/cache and you can not use the events that call these MBF's
> to manipulate anything. To achieve what you want I think you can do 2 things:
> change the MBF's so they will also store the UserReserved Parameters (I
> was told not to do this) or in the OK Button Clicked event (OK processing
> is started when alle the running asynchrone functions are finished) get
> all the grid records and store the User Reserved fields in the WorkFile
> or Cache. If the UserReserved Fields in the workfiles/cache are filled,
> they will be stored in F4201 and F4211.
>

If anyone has a better solution, please let us know.
>

Hope this makes any sence.
>

Marcel Tuik.
>
>
>

Kenneth_Elder wrote:
> <blockquote TYPE=CITE>Is there a file I can populate the URAT (User Defined
> Field) that will move
>
> to the SDURAT field in the F4211 so I can use at order entry time?
> We have
>
> a situation where we need to calculate our adjustment amount from the
>
> combination of percent off Suggested and Wholesale amount. I
> could do this
>
> using the formula in Advanced pricing if Advanced pricing can gain
> access
>
> to Suggested Retail price. Any help with this would be appreciated.
>
> Thanks.
>

--------------------------
>
> To view this thread, visit the JDEList forum at:
>
> http://198.144.193.139/cgi-bin/wwwthreads/showflat.pl?Cat=0&Board=OWDEV&Number=149
>
> *************************************************************
>
> This is the JDEList One World Developers Mailing List.
>
> Archives and information on how to SUBSCRIBE, and
>
> UNSUBSCRIBE can be found at http://www.JDELIST.com
>
> *************************************************************</blockquote>
> </html>
>
> --------------0E7AD1A246617F8AFBEFFB13--
>
>
>
>
> --------------------------
> To view this thread, visit the JDEList forum at:
> http://198.144.193.139/cgi-bin/wwwthreads/showflat.pl?Cat=0&Board=OWDEV&Number=193
> *************************************************************
> This is the JDEList One World Developers Mailing List.
> Archives and information on how to SUBSCRIBE, and
> UNSUBSCRIBE can be found at http://www.JDELIST.com
> *************************************************************
>
>
>
 
By our experiences, removing the "Run Asynchronously" flag in an MBF call doesn't cause any problem.
The only side-effect could be that the user will get back the control a bit later.
On the other hand, sometimes just the asynch call caused some problem in certain application when the user was too fast.
We have identified this problem under B7321.
I trust, asynch calls doesn't cause such kind of problems under Xe.

Zoltán
 
Back
Top