cancel
Showing results for 
Search instead for 
Did you mean: 
Krisjl21
Level 1

How do I get Currency Data from SDK?

Does QB have to be configured for Multiple Currencies in order for the SDK to return the currency for an order or customer?

 

I developed a solution using the QB Web Connector and my client has requested the Currency to be extracted from QB.  I am getting the Customer Record, Sales By Item Detail Report and Open Sales Order By Item Report.  I would prefer to get the Currency on the reports but I can also make the Customer record work too!.

 

I have added the Currency field, using IncludeRetElement and IncludeColumn, but I don't get anything back from QB.  I assume because QB is not configured for Multiple Currencies and the Currency List either doesn't exist or is empty.

 

Thanks,

Kris

Solved
Best answer January 30, 2020

Best Answers
Rea_M
Moderator

How do I get Currency Data from SDK?

Hello there, Krisjl21.

 

Yes, you need to enable the Multicurrency feature so you can track your transactions in foreign currency. This will also allow you to assign a specific currency type on your customer or vendor profiles. Let me guide you how.

 

However, let me remind you that you can no longer turn off the feature once turned on. It's recommended to create a backed up your QuickBooks company file before proceeding. 

 

To turn Multicurrency, here are the steps:

 

  1. Go to the Edit menu.
  2. Select Preferences.
  3. Click the Multiple Currencies menu.
  4. Select the Company Preferences tab.
  5. Click the Yes, I use more than one currency radio button.
  6. Read the things to consider before turning on the feature, then select Yes.
  7. From the drop-down, select your home currency.
  8. Click OK.

I've attached screenshots below for your reference.

 

P15.PNGP16.PNG

 

Once done, you can now create transactions that require you to use foreign currency. You can assign it per customer or vendor profile. However, you can only set one, so you need to create new profiles for them.

 

If you wish to add foreign currency customers, vendors, and accounts, as well as updating your exchange rates, you can check out the Set up and use Multicurrency. This contains complete details about the said feature and steps you can take after activation.

 

Let me know if you have other concerns about QuickBooks features, I'm always ready to help. 

View solution in original post

1 Comment 1
Rea_M
Moderator

How do I get Currency Data from SDK?

Hello there, Krisjl21.

 

Yes, you need to enable the Multicurrency feature so you can track your transactions in foreign currency. This will also allow you to assign a specific currency type on your customer or vendor profiles. Let me guide you how.

 

However, let me remind you that you can no longer turn off the feature once turned on. It's recommended to create a backed up your QuickBooks company file before proceeding. 

 

To turn Multicurrency, here are the steps:

 

  1. Go to the Edit menu.
  2. Select Preferences.
  3. Click the Multiple Currencies menu.
  4. Select the Company Preferences tab.
  5. Click the Yes, I use more than one currency radio button.
  6. Read the things to consider before turning on the feature, then select Yes.
  7. From the drop-down, select your home currency.
  8. Click OK.

I've attached screenshots below for your reference.

 

P15.PNGP16.PNG

 

Once done, you can now create transactions that require you to use foreign currency. You can assign it per customer or vendor profile. However, you can only set one, so you need to create new profiles for them.

 

If you wish to add foreign currency customers, vendors, and accounts, as well as updating your exchange rates, you can check out the Set up and use Multicurrency. This contains complete details about the said feature and steps you can take after activation.

 

Let me know if you have other concerns about QuickBooks features, I'm always ready to help. 

Need to get in touch?

Contact us