Thank you for visiting our Partner Zone. This area is an exclusive space for MYOB Partners. Find out how to Partner with MYOB.
Share your ideas for improving the new AccountRight. Vote on ideas and discuss them with the MYOB product development team.
What reports are most important for you to see foreign values ie. values in originating currency
Would love to hear from you in the comments
With the release of AccountRight 2020.3, the following reports have been updated to support foreign currency transactions. You can now select local or foreign currency, as well as filter by currency, on:
MYOB reports need to allow us to easily reconcile suppliers/customers accounts in originating currency. (like would could do in the old versions).
Types of reports required:
* Detail reports of Open Invoice lists in the originating currency. - MYOB 2019.2 only gives the option of the summary - NOT very helpful
* Detail reports of purchases during a given period of time in the originating currency. previously avail in the old version of myob under : Purchases Register Detail format
These need to be avail for both Excel or printing.
From what I can see the MYOB has gone backward with Multi Currency - very disappoint at this stage
If you're looking to run a quick report of open/closed sales or purchases in local/foreign currency, many users prefer to do this reporting directly in the purchase/sales registers, rather than running a report.
It is very quick to filter/search/group and sort in the register. If your first grouping in the register is by the Currency column, you'll also see sub-totals directly in the register, for example - grouping by Currency then Customer.
You can very quickly paste into Excel for further analysis/pivot tables by right clicking in the register and clicking Copy List To Clipboard.
You'll find more info about reporting here: http://help.myob.com/wiki/pages/viewpage.action?pageId=28477913#expand-Reportingonforeigncurrencytra...
Receivables Reconciliation Detail and Payables Rec Detail - a obsolutely required in originating currency
AR/AP detailed reports. Yes. Of course.
Paying one of our foreign suppliers (in Euro), we have many invoices and orders in Euro for this supplier, each invoice can have 100 or more items, I found the Payable Reconciliation Summary report, where I can select the supplier and the originating currency that gives us one line with the amount owing in Euro, then when I go to the detailed report I dont have the option of the originating currency, it is in AUD Dollars and I need it in Euros, so i can reconcile the suppliers invoices (in Euro) against our purchase orders also in Euro's and that seems not possible, its very dificult to see if the prices charged by the supplier match the euro prices entered on our order as we can only print the data in $$$
A solution would be appreciated
Please please please put back the Purchase order report with original currency
* Bank Reconcilations in originating currency
* Accounts Receivable reconciliation detail
* Accounts Payable reconciliaton detail
* Also, the ability to enter General Journals in a foreign currency
Hi @nicolea , did you have GL accounts in version 19 in foreign currencies, which have now been converted to your home currency? Would these be for such things as inter-company accounts, foreign loans? What else?
The GL is now 100% home currency, and therefore you cannot keep a foreign currency GL balance except if it is part of receivables or payables. This function appears to have been deprecated, as a by-product of the design change. Any users affected by this change should add their comments.
HI @Mike_James - perhaps i should have provided more information with my post. Regarding the GL entry, I used to be able to post income accruals for example
Dr A/R Accrual - JPY
by changing the currency on that entry. We would then enter the JPY to AUD exchange rate in 19.14 and it would autopost the FX entries to the A/R JPY Exchange account (and revenue) to bring the ledger entries back to "home" currency.
Unless I am mistaken I now need to do the conversion outside of MYOB for these accrual entries and post them in soley in AUD. Is this right?
Hi @nicolea , yes I believe that is correct, under the current design you cannot store the JPY value of the accruals in the GL now. Thanks for advising your business use.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.