GP Dynamics Supplier Movements through the GL (Local Currency ?)

(0) Share

Report

Posted on by PAULIANDAVIES

Hi,

I have built a SQL view that lists out the Suppliers and the amounts that have gone through all of the Ledgers (and their codes) in GBP using the GL20000 tables, etc... - is it possible to get the same information in the Local Currency ? I tried translating using the Exchange Rates also in the table but this gave me some rounding differences so i wondered if the original source currency amount was stored some where ?

Is there a SQL view i can put together to show these amounts ?

Thanks

Paul

*This post is locked for comments