pbare
Well Known Member
Hi All,
I am working on writing a SQL that will fix an incorrect Rate and Amount in F0618
I need to update WCMP (Number (9,2))
Current data in the field for an employee is 49516 - when we check the data we found that the data in this column was incorrect (our rate in RTWC was incorrect - it was 10 times to big)
When we view the data in Databrowser (using JDE 9.1) - we see 495.16 when it should actually be 49.516
I have written SQL to update the rate and the amount but when I run the sql - it is rounding the number off to 2 decimal places
Please see the attached pdf to see what I have been attempting to do...(it shows the data before and after as well as my SQL statement)
I am assuming that I am missing something since the first set of numbers is displaying the decimal place without it showing in the database
Any help would be greatly appreciated as I need to have this fixed by Monday at end of day
Thanks
Pam
I am working on writing a SQL that will fix an incorrect Rate and Amount in F0618
I need to update WCMP (Number (9,2))
Current data in the field for an employee is 49516 - when we check the data we found that the data in this column was incorrect (our rate in RTWC was incorrect - it was 10 times to big)
When we view the data in Databrowser (using JDE 9.1) - we see 495.16 when it should actually be 49.516
I have written SQL to update the rate and the amount but when I run the sql - it is rounding the number off to 2 decimal places
Please see the attached pdf to see what I have been attempting to do...(it shows the data before and after as well as my SQL statement)
I am assuming that I am missing something since the first set of numbers is displaying the decimal place without it showing in the database
Any help would be greatly appreciated as I need to have this fixed by Monday at end of day
Thanks
Pam