Knowledgebase articles
- Welcome to the Knowledge Base
- Introduction
- Training
- Getting Started
- Preferences
- Activities
- Cases
- Importing Data
- Leads
- Marketing
- Introduction to Marketing
- Marketing Campaigns
- Mailing Lists
- Products
- Mailshots
- Upload Library
- Templates
- Event Management
- Compliance Records
- Force24
- Spotler Integration
- What is Spotler?
- Navigating your Spotler homepage
- GatorMail
- GatorLeads / Web Insights
- Tracking Code
- Setting up the Plugin
- Viewing Web Insights Data on your Form Layouts
- Domain Names and Online Activities
- Reporting incorrect Leads created through Web Insights
- Reporting on Web Insights data
- Using UTM Values
- Why aren’t Online Activities being created in the database?
- Why is GatorLeads recording online activities in a foreign language?
- GatorSurvey
- GatorWorkflow
- GatorPopup
- Opportunities
- Projects
- Integrations
- Mapping
- Electronic Signing Tools
- Creditsafe Integration
- Zapier
- Introduction to Zapier
- Available Triggers and Actions
- Linking your Workbooks Account to Zapier
- Setting up Zaps
- Posted Invoices to Xero Invoices
- Xero payments to Workbooks Tasks
- New Case to Google Drive folder
- New Case to Basecamp Project
- New Workbooks Case to JIRA Ticket
- Jira Issue to new Case
- 123FormBuilder Form Entry to Case
- Eventbrite Attendee to Sales Lead and Task
- Facebook Ad Leads to Sales Leads
- Wufoo Form Entry to Sales Lead
- Posted Credit Note to Task
- QuickBooks Online
- Survey Monkey responses to Tasks
- Multistep Zaps
- Email Integrations
- Email Dropbox
- Workbooks Exchange Server Sync
- Workbooks Outlook Connector
- RevenueGrid Intelligence and Engage
- Event & Webinar Integration Tools
- GoToWebinar
- ON24
- Microsoft Office
- Outreach
- Installation
- Outreach Authentication
- Sync People to Outreach Prospects
- Sync Organisations to Outreach Accounts
- Sync Workbooks Opportunities to Outreach
- Sync Tasks/Activities from Workbooks to Outreach
- Sync Outreach Sequences to Workbooks
- Sync Outreach Sequence States to Workbooks
- Sync Outreach Sequence Step Numbers to Workbooks
- Sync Prospects/Accounts/Opportunities from Outreach to Workbooks
- Sync Outreach Tasks/Calls/Meetings to Workbooks
- Scribe/Workbooks Connector
- RingCentral
- Auditing
- Comments
- People & Organisations
- Reporting
- Introduction to Reporting
- Using Reports
- Introduction to Charts
- Exporting Reports
- Advanced Reporting
- Report Snapshots
- Dashboards
- Transaction Documents
- Introduction to Transaction Documents
- Displaying & Adding Transaction Documents
- Copying Transaction Documents
- Transaction Documents Fields Help
- Transaction Documents Line Items Help
- Printing & Sending Transaction Documents
- Managing Transaction Document Currencies
- Managing Transaction Document Statuses
- Setting a Blank Default Currency on Transaction Documents
- Credit Notes
- Customer Orders
- Invoices
- Quotations
- Supplier Orders
- Contract Management
- Sagelink
- Introduction to Transaction Documents
- Configuration
- Introduction to System Administration
- Users & Security
- Database
- Accounting
- Email & Integration
- Customisation
- Creating & Modifying Picklists
- Theme
- Record Types
- Creating Custom Fields
- Report-based Custom Fields
- Linked Fields & Reference Fields
- Record Templates
- Form Layouts
- Customising relationships between parties
- Opportunity Stages
- Custom Records
- Sign In Customisation
- Automation
- Contact Support
- Releases & Roadmap
Exchange Rates
How to control the Exchange Rates that are used on Transaction Documents, and an overview as to when an exchange rate will be updated on a document.
If your Own Organisation trades in more than one currency, you can create Transaction Documents in any foreign currencies you use and can control the Exchange Rate that’s applied to those transactions. The Exchange Rate is used to convert the foreign currencies into your Home Currency, enabling you to create reports in your Home Currency.
NOTE: In order to create and use multiple currencies you must have the Multi-Currency Extension for all Users, and the Multiple Currencies Module must be enabled.
Exchange Rates can be changed at any time; you may update them daily, weekly or monthly or on an ad hoc basis.
Exchange Rates are applied by looking at the document date and using the Exchange Rate that you’ve set for the corresponding time period. For example, if you’ve set Exchange Rate ‘A’ for 1-15 December and Exchange Rate ‘B’ for 16-31 December, a Transaction Document dated 10 December will use Exchange Rate A, whereas a Transaction Document dated 16 December will use Exchange Rate B.
Tip
Workbooks can set the market rate exchange rate for you, if you wish, but you must specify the date range for which you want it to apply.
Exchange Rates and Transaction Documents in a Draft state are linked, therefore Home Currency values will change to reflect any rate changes. Thus, in the example quoted above, if the date on the second Transaction Document is changed (whilst the document is still in a Draft state) from 16 December to 10 December, the Exchange Rate will change from rate B to rate A.
When a Transaction Document is changed from a Draft state to Posted, the Exchange Rate in place at the time (based on the document date) will be applied. This Exchange Rate will not change unless a user with the necessary capability to edit a posted transaction changes the document date.
NOTE: Opportunity records do not have the concept of Draft and Posted states. They will use the Exchange Rate related to the Close Date at the time the Close Date is selected.
If the Close Date is changed to a date where a different Exchange Rate applies, the Exchange Rate for the new period will be applied. However, if the Close Date is not changed but the Exchange Rate for the relevant period is changed, the Exchange Rate will remain as per the one in place when the original Close Date was set.
Where Line Items are added to Transaction Documents whose price in the product book is in a third currency (ie, neither the Home nor the Document currency), Workbooks will display these in the Transaction Document in the Document currency, based on the exchange rates prevailing at the time. These figures will not be re-calculated, even when the document is Posted. This should be taken into consideration before Posting (completing) the document.