[cpaton]

In netsuite I have a form with a field currency_type and an amount field.

I have saved search which gets currency_type.exchange_rate and multiplies it by the amount field to do a currency conversion.

I want to link the data in netsuite to excel via odbc which I’ve done, but I’m having trouble with a few things and would love some help:

1. Any lists are appearing with their id number not the data entered

2. Exchange rate – I’m getting a currency ID but I’d like to get today’s exchange rate that is associated with the ID.

Can anyone with experience exporting data via odbc help?
This is a cached copy. Click here to see the original post.

[sstanell]

RE: ODBC – getting today’s exchange rate

The id you are receiving is likely a reference to another table which contains the information you want. If I have a list of colors having the ids (1=Red, 2=Blue, 3=Green) and a field that uses this list, selecting Blue in NetSuite will show as 2 in ODBC. Once you determine the table that contains the list information, you can use SQL Joins to select the appropriate data.

Your query may look something like this:

SELECT CURRENCY_AMOUNT

FROM MAIN_TABLE

JOIN CURRENCY_TABLE on

CURRENCY_AMOUNT.CURRENCY_TYPE = CURRENCY_TABLE.INTERNAL_ID

The join allows you to reference the values associated with your currency type. Hopefully I understood your question and this helps.

[Author]

Posts