26.11. Using foreign currencies in transactions

The foreign currency feature enables you to receive stock from suppliers in the suppliers own foreign currency and also distribute goods to customers in their own currency.

You must have Foreign Currencies configured in mSupply if you are using this feature. You set them up using Currencies. Once this is done, follow the steps below.

- From the Navigator click drop down menu Special> Show Stores… double click to select the store in which you want foreign currencies to be used and in the window that appears hit tab Preferences. - Check Store mode: Able to issue in foreign currency. - Click OK and return to the mSupply Navigator.

- From the Navigator choose Customers > Show Customers. - Locate the Customer and double-click it. In the window that appears click the General tab and in Currency drop-down list (top-right) select the appropriate currency for that Customer. - Click OK to return to the Navigator and do the same for the Supplier if required.

Instructions in these section to be update

In this example, our store operates with Australian dollars (AUD) as the local currency, and is making a purchase from a European supplier which uses the Euro (EUR)

  1. From the Navigator choose Suppliers > New Supplier Invoice
  2. In the Supplier Invoice window that appears select your supplier and view its details by double-clicking.
  3. Click the Price tab and change the currency (as highlighted in box 1 below) to the currency in which the supplier provides the items to you.
  4. Return to the General tab and click button New line to add a new item line.
  5. In the window that appears type the details of the item you are receiving and hit button OK & Next to add further items.
  6. Once all items are added, again click the Price tab and review the item prices as highlighted in box 2 below:

    The columns headed Price FC and Extension FC in box 2 above show the cost price of goods to you in Euros - i.e. the Foreign currency which the supplier uses, while the figures in the columns on the right show the prices in Australian dollars - i.e. your local currency.

  7. Click OK to save the Supplier invoice and introduce the items to stock.
  • If you change the supplier on an invoice that has item lines, the following message will appear. Check the currency is correct for the new customer and adjust it if necessary.

In our example, the supplier uses Australian dollars (AUD), and is creating an invoice for Highland Health Centre which uses Solomon Islands dollars (SBD).

  1. Ensure Foreign Currencies are active as per the instructions at the top of this page.
  2. From the Navigator choose Customers > New Customer Invoice.
  3. In the Customer Invoice window that appears select your Customer in field Name and note the currently set currency and its rate as highlighted in box 1 below.
  4. Now click the New Line button to add a new item line.
  5. In the window that appears type the details of the item you are issuing and hit the OK button. Repeat as needed.
    • Box 1 shows the customer's currency, SBD, the Currency Rate, which shows the value of 1 Solomon Island dollar in the supplier's currency, Australian dollars, and the invoice value in the customer's currency.
    • Observe the item's foreign currency values (SBD) in the columns Price fc and Price fc ext on the Customer Invoice in box 2 below:
  6. Click OK to save the Customer invoice.
  • If you change the customer on an invoice that has item lines, the following message will appear. Check the currency is correct for the new customer and adjust it if necessary.

In our example, the supplier, International Dispensary, uses Euros (EUR), while we use Australian dollars (AUD).

  1. Ensure Foreign currencies are active as per the instructions at the top of this page.
  2. From the Navigator click drop down menu Supplier> New Supplier Credit.
  3. In the Supplier Credit window that appears select your Supplier in field Name and note the currently set currency and its rate as highlighted in box 1 below.
  4. Now click button New Line to add a new item line.
  5. In the window that appears type the details of the item you are receiving and hit OK. Repeat as needed.
  6. As this is a credit note, the value is shown as a negative amount
  7. Box 1 shows the supplier's currency, EUR, the Currency Rate, which shows the value of 1 Euro in our currency, Australian dollars, and the credit note value in the supplier's currency.
  8. Note the item's foreign currency values (SBD) in the columns Price fc and Price fc ext on the Supplier Credit in box 2 below:
  9. Click OK to save the Supplier credit.
  • If you change the supplier on an invoice that has item lines, the following message will appear. Check the currency is correct for the new customer and adjust it if necessary.

In our example, the supplier uses Australian dollars (AUD), and is creating a credit note for Highland Health Centre which uses Solomon Islands dollars (SBD).

  1. Ensure Foreign currencies are active as per the instructions at the top of this page.
  2. From the Navigator click drop down menu Customer> New credit…
  3. In the Customer Credit window that appears select your Customer in field Name and note the currently set currency and its rate as highlighted in box 1 below.
  4. Now click button New Line to add a new item line.
  5. In the window that appears type the details of the item you are crediting and hit button OK.
  6. Boxes 1 and 2 show details exactly the same as explained in the previous two examples
  7. Click OK to save the Customer credit.
  • If you change the customer on an invoice that has item lines, the following message will appear. Check the currency is correct for the new customer and adjust it if necessary.



  • Last modified: 2022/02/11 15:48
  • by Gary Willetts