#### 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