Skip to Content
0
Feb 24, 2009 at 03:26 PM

LC and CS amount are different

196 Views

Hi ,

in a customer database , i have different figures in LC and SC columns . Both LC and CS currencies are EURO .

I ran this select to verify the problem :

select

DueDate,TransID,Debit,Credit,SYSDeb,SYSCred,FCDebit,FCCredit,FCCurrency

from jdt1

where (SYSCred<>Credit or SYSDeb<>Debit) ;

==> about 50 lines have this problem .

In my opinion , no jdt1 line should have SYSCred<>Credit or did i miss something ? In what cases SYSCred could be different than Credit ? ( when LC=CS=Euro ) ?

Thanks for your help