Multi-Currency

///Multi-Currency
Multi-Currency 2017-09-11T03:59:27+00:00

Info and Concepts

Many organisations purchase stock from suppliers that do not bill in Australian dollars, some also sell to foreign companies and may wish to invoice in a foreign currency as well. Aerotrack has the functionality to both buy and sell in currencies other than Australia dollars.

The default rates for each currency can be set in the System Administration section and they will be used as defaults for each purchase/sale. You must select one of the currencies as your ‘base currency’ (AUD). The rates can be changed for each sale/purchase individually to match the rate of the day used in the transaction.

There are a number of “safeguards” for dealing with multiple currencies, these are:

  • THE RATE FOR THE BASE CURRENCY (AUD) IS 1.00 AND CAN NEVER BE CHANGED.
  • After a customer/supplier has been created and there are purchases/sales for this customer/supplier, the currency type cannot be changed.
  • You cannot have a customer/supplier with more than 1 type of currency. If this is required create the customer/supplier multiple times each with its own currency type.

All costing of inventory is converted to the ‘base currency’ (AUD) and is based on the rate in the sale or purchase, including average cost and stock valuations.

Where

Available in all purchases and sales.

Walkthrough

  1. The rate for each currency is set in ‘System Administration > Accounting’ tab panel.
  2. Standard currencies have been pre-set. You can add to these as required.Screen Shot 2016-02-22 at 12.25.23 PMScreen Shot 2016-09-06 at 8.57.54 AMScreen Shot 2016-02-22 at 12.25.23 PM
  3. When you create a new customer/supplier the currency will always default to the ‘base currency’, this can be changed on the supplier/customer record.Screen Shot 2016-02-22 at 12.25.23 PMScreen Shot 2016-09-06 at 11.52.23 AMScreen Shot 2016-02-22 at 12.25.23 PM
  4. Change the currency as required; you cannot change this after you have created purchases/sales for this customer/supplier.
  5. Create the purchase or sale as usual, you will see when you add the supplier/customer name, the currency will look up to the currency set in their customer/supplier setup and the rate will look up to the default rate set in the “System Administration > Accounting” tab.
  6. You can change the default rate to match the current currency rate by clicking the ‘Currency Rate’ button. THIS WILL AFFECT COSTS OF THAT ITEM WHICH ARE ALWAYS CONVERTED TO THE ‘BASE CURRENCY’ (AUD) RATE.
  7. Complete the purchase/sale as usual. The printout of the purchase/sale will include the currency in the column headings and Totals

Tips

You should use the currency in the customer/supplier name to help identify it.

You can see the ‘base currency’ (AUD) converted value of foreign currency transactions by looking at the “transactions” for that item in the inventory. The price fields are all 4 decimal converted ‘base currency’ (AUD) Values. They also show the currency and the rate used in the purchase/sale