Typically, All Orders can determine whether or not Quickbooks has the multi-currency feature turned on or off by querying the Quickbooks company preferences. At times, however, there may be issues retrieving this information in which case we may need to manually tell All Orders whether or not multi-currency is or is not turned on for decided if it is appropriate to send transactions over with exchange rates. We also might want to control whether or not the currencies themselves synchronize with Quickbooks, which for example, would mean standard/default exchange rates entered on one system will override the exchange rates in the other. The following set of scripts will allow you to control each aspect of this to control what information is passed to and from Quickbooks and what is not.
To run any of the scripts below, right click and save the file from the link, open All Orders as the admin, go to the file menu, click Maintain, click the Advanced tab, click the Run DB Command button, Browse for the script file wherever you downloaded it to, select and then run it. Close out of All Orders and open it back up again to have the changes take affect.
TurnOffCurrencySync.sql
This script will turn off the synchronizing of the currencies themselves. This means if a currency is edited, such as an exchange rate changing, it will not go between the two systems. It also means if a currency is assigned to a customer/vendor it will not update that customer or vendor in the other system and it may have to be done manually.
TurnOnCurrencyRateSync.sql
This script will turn the synchronizing of the currencies on.
TurnOnExchangeRateSync.sql
This script will turn off the sending over of exchange rates when postings invoices, payments, and bills to Quickbooks.
TurnOffExchangeRateSync.sql
This script will turn on the sending of exchange rates.
