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