I thought I would post this for future reference, and in the event that it is helpful to the community. These two scripts can be modified to find records in any GP table, where the values of numeric fields extend beyond two decimal places.
I've found this useful when something goes wrong with multicurrency revaluation.
Here are two scripts; you'll get the same results either way –
select * from GL20000
where
floor(DEBITAMT*100)!=DEBITAMT*100
or
floor(CRDTAMNT*100)!=CRDTAMNT*100
select * from GL20000
where
cast(DEBITAMT as numeric(19,2))-DEBITAMT<>0
or
cast(CRDTAMNT as numeric(19,2))-CRDTAMNT<>0
*This post is locked for comments