Thanks @Tut for bringing my attention to this. @JEN, I will share what I do, but since I believe Manager is not fully equipped to handle our reporting requirements, it is quite likely that your boss has set your business up differently and my method either won’t work for you or will require a great deal of reconfiguration to get it to work.
The fundamental issue we have is the requirement to report all transactions in the currency of the transaction. Manager is set up to report everything in the base currency, and from my time on the forum it seems that our situation is unique, which is why it remains unsupported. See this topic for some more discussion around this, with acknowledgement by the developer that it is unsupported.
I outlined my method in this post, but I’ll run through it again here:
Firstly, I have set up my customers and suppliers so that all of those with their currency set to USD have “ (USD)” at the end of their names. Those set to ZWL (our base currency) have nothing added to their names, but of course you could use “ (ZWL)” or something similar to help you. I start by creating a Tax Transactions report for the period in question. This lists all transactions, grouped by tax code.
From here I click on Copy to clipboard in the top menu bar, and I paste the data into a spreadsheet. There I go through and separate inputs from outputs and ZWL from USD. I haven’t automated this yet, and so it takes some time. Depending on how many transactions you’re dealing with it may be easy, or completely impractical.
Once I have the USD transactions grouped together I make sure they are sorted by date, and I retrieve the exchange rates for the date range and add those into an adjacent column to perform the calculations back to ZWL for the report. I do the rest of the calculations and report preparation in the spreadsheet application, and only refer back to Manager to check the totals to make sure my calculations are correct.
I hope this makes sense and is of some help. Whether this approach will work for you might depend on how your customers and suppliers are set up (and how easy it is to separate them by currency in the tax transactions report), the volume and nature of transactions that you’re dealing with, and your skills in Excel. Somebody more skilled than me could automate it to a much larger degree, and others might struggle to do what I did. If you have any suggestions or ideas for alternative methods please do share. I would be curious to hear how your boss does it when he gets back from leave.
Note that if you do find yourself wanting to update thousands of customers to append “ (USD)” or “ (ZWL)” to their names, Manager has batch update functions that could help with this.