on 04-28-2009 12:44 PM
Good Morning,
I have some udfs with formated search in the sales invoice lines. When I change a value in that fields and save like draft,when I re-open it the systems do not save the change I have made.
SELECT u_PComissao from (@vendedores) where code=$($38.U_vendedor2.1)
Do you have any idea how to solve this?
Thank you,
Susana Cunha.
Edited by: Susana Cunha on Apr 28, 2009 1:45 PM
Have you selected Display Saved Value? If you need the ability to manually input the value, no auto refresh should be set.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Suda and Gordon,
Yes, I have selected Display Saved Value. I just need to manually input the value in some especific cases. For other cases I need that the value get populated automatically.
If I Uncheck Auto Refresh on the FMS and manually enter the value in the UDF
Save as Draft and re-open it, the system saves the correct value. But with this process I need to fill the field always manually. Do you know other process to have the both things?
Thank you.
Susana
This is what is actually happening,
Even the first time your FMS populates the value in the UDF, the value still exists in the UDF and probably there in your database table.
The next time when you open draft, the refresh probably clears the value in the UDF by fetching a blank record, This probably is what is happening.
Please check by using Display Saved Values instead of Refresh Regularly.
If this does not work then manual is your option
Suda
Unfortunately, there is no options that you could both auto refresh and manually input UDF value. Display saved value has limitation on the UDF, you have to understand the concept behind this function. All manually input values might be subject to override by system.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Does the UDF get populated by the formatted search when you save it as draft?
Have you used refresh regularly
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
I believe the Auto Refresh is causing the issue. Also, your formatted search does not see to fetch the value and is returning a blank which change the already existing value on the screen.
Couple of things you can do to check where the problem lies.
Uncheck Auto Refresh on the FMS and manually enter the value in the UDF
Save as Draft and re-open it and check if the value exists.
Suda
Hi Suda and Gordon,
Yes, I have selected Display Saved Value. I just need to manually input the value in some especific cases. For other cases I need that the value get populated automatically.
If I Uncheck Auto Refresh on the FMS and manually enter the value in the UDF
Save as Draft and re-open it, the system saves the correct value. But with this process I need to fill the field always manually. Do you know other process to have the both things?
Thank you.
Susana
Hi Susana ,
Which refresh functions have you selected?
Thanks,
Gordon
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
94 | |
11 | |
10 | |
6 | |
5 | |
5 | |
4 | |
3 | |
3 | |
3 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.