Accessing FX Values
Hi, I am accessing our MYOB data from the cloud. I can find the transactions I want in either JournalsTransactions table, SpendMoney or ReceiveMoney tables. The issue I have is that I can only fi...
Forum Discussion
Hi Mike, I'm using Excel via Odatafeed to access the data. I have expanded every column in the spendMoneyTransactions table and can't find the FX Value?
In the attached example the value is given in column S and column Z. Both these values (80411.70) are the NZD amounts. USD amount is 50000. I just want to find the exchange rate associated with this transaction and then can calculate the USD amount which is what I want.
Hi GordyM1 , as I thought, that's a 3rd party program that presents the data as tables, and probably hasn't been updated to include the FX values.
Mike,
Thanks for your help, is there another way I can access the tables that would show it?
Hi GordyM1 , there is, or was, a free add-on called MYOB for Excel, but I haven't used it, as it usually doesn't install or work for me. We promote our own report writer, which handles the extraction of all data, but into a database of our own design, from which we extract data for reports with SQL queries. If you want to know more have a look at our website.
Thanks Mike, I'll download a trial of your software.