Price Quotes > Enable Line Level Currencies

In WorkBook, the Price Quote allows setting a different currency per line to display the purchase values in the currency of your suppliers and, as an option, allows you to set the exchange rate for that purchasing currency to override the normal exchange rate predefined in the system.

This value can then be inherited into Purchase Orders and Sales Invoices accordingly.

CREATE A PRICE QUOTE WITH PURCHASE CURRENCY

Create a new price quote and select the checkbox “enable line level currencies”

Open

Proceed to the “currency set-up” tab

• Click “add new currency” icon to add the relevant purchase currencies that need to be used on the price quote

• In the pop-up box select the currency from the available options

• Leave the “override rate” field blank if you want the exchange rate to calculate based on today’s automated currency exchange rate, or enter a value if you would like to set/override the exchange rate

• Click OK to confirm

Open

• Once the currencies have been added, continue to the ‘lines’ tab > click on the sandwich menu and ‘modify grid’

• Check that the relevant columns are visible in your grid view

• Make sure the following columns have been selected:

  • Purchase currency

  • Purchase amount in currency

• Add purchase line items, as per the table below:

• Add remaining line items and complete/approve price quote as per usual process

CREATE PURCHASE ORDER USING PURCHASE CURRENCY

There are two options to create a Purchase Order in the purchase currency that is set on the relevant Price Quote.

Option 1: Copy purchase data from a price quote

• Create a new purchase order and select the option “copy purchases data from a price quote”

• Click OK to confirm

• In the pop-up, select the relevant price quote from the dropdown

  • Select the checkbox on the relevant line items that you want to create POs for

  • Under the “copy method”, select the option “create a new PO for every line currency and PQ supplier combination for the selected data”

  • then select the preferred profit margin option and relevant header activity

• The resulting purchase order value will be displayed in the purchase currency

Option 2: Create a new PO from scratch

• Create a new purchase order and select the option to copy from “nothing”

• Then select the relevant purchase currency and click OK

• Manually enter the agreed price in the purchase currency (or go to the details tab if the option “enable unit amount specification on purchase order” is turned on - System Variable 1037).

• Complete/approve PO as per usual process

CREATE INVOICE BY COPYING DATA FROM PRICE QUOTE

Price Quotes can be copied into invoices as per the usual process, the purchase values will be copied over as per the price quote currency and the exchange rate will remain the same as the price quote. 

• Select price quote to copy to invoice:

• Values are copied into the invoice according to the price quote currency

• Continue with the normal invoice process to complete / approve the invoice

Related articles