Client Query - Supplier Set with Wrong Currency and Invoice Received

Client Query - Supplier Set with Wrong Currency and Invoice Received

Problem/Question

I have set up one of my suppliers with the wrong currency, and I have delivered a purchase order and it is ready to invoice.
How do I delete it so that I can change the currency on the Company and re-input and process the Purchase order?

Solution

It is not possible to alter the currency against a supplier if you have already posted an invoice to your accounts from this supplier.

If you have not already posted any other invoices from the supplier to your accounts, it is possible to edit the currency under Financials in their Company Record after you have deleted all Purchase Invoices, Delivery Notes and Purchases Orders connected with that supplier. 

  1. Go to [Purchasing | Purchase Invoice (For Stock)].
  2. Switch off the date filter, then click Go.
  3. In the grey box at the top of the Code column enter the number of the purchase order.
  4. You should now see all of the purchase invoices relating to this order.
  5. They ALL need to be unposted and deleted - we will be recreating them shortly.  Please note the details and what items are on each of them as you need it at step 14.
    • To unpost and delete an invoice double click it in the grid, click Edit and switch off the Post Invoice toggle, then click Save Screen.
    • When this is done you can delete the invoice by clicking red Delete button.
  1. Go to [Purchasing | Delivery Note] and remove all deliveries relating to this order. Please note the details and what items are on each of them as you need it at step 13.
    • If removing these would take your stock level below 0, then a stock adjustment to prevent this is needed beforehand - this process is covered in a separate article, How Do I Adjust Stock Levels?
  1. Once all delivery notes relating to the order have all been removed, open the original purchase order.
  2. Click Edit.
  3. Switch off the Create Purchase Invoice toggle.
  4. Click Save.
  5. Go to the On Order List.
  6. Find any item on the purchase order and click Create Delivery Note.
  7. Amend the details to reflect the Purchase Invoices deleted in step 5.
  8. Click Actions then select Go To Purchase Invoice.
  9. Amend details to reflect what was on the invoice in step 5.
  10. Repeat steps 12 to 16 for each delivery relating to this purchase order.
  11. If you adjusted stock at step 7 it can now be adjusted to the correct level.
After completing the above you will be able to change the currency of the supplier.

If you have already posted previous invoices to yours accounts with this supplier, you will need to create a new supplier and recreate the Purchase Order again against the new supplier.