The 'X' Factor

'X' Concept - One of my clients wanted to get a Trial Balance in the US Sets of Books which will only have Transactions which are entered in US dollars. As per the standard Oracle functionality, if the transaction currency is the same as the SOB functional currency, the Entered Dr and Entered Cr columns are not populated. Only the Accounted Dr and Accounted Cr columns are populated. This creates an issue as the client wants to run a trial balance on transactions entered only in SOB functional currency.










High Level Solution - 'X' currency, to overcome this, a solution was developed to use a currency called ‘X’ as the USD books reporting currency. If we take USD (Primary SOB) and USX (Reporting SOB), all transactions in USD in USD SOB will appear as a transaction currency in the USX SOB (foreign currency transaction). This will enable the user to run foreign currency Trial Balance in the USX books on transactions entered in USD.