[dnewnham]

Hi,

I am trying to find the table and field name that corresponds to the “exchangerate” field that sits on the accounting tab in a sales order. It doesn’t seem to be in the TRANSACTION table.

Any ideas?

thanks,

Doug
This is a cached copy. Click here to see the original post.

[george.panaritis]

I believe “exchangerate” is in the CURRENCY record and not on the TRANSACTION record

[dnewnham]

Then it must be pulling the rate in based on the date of the transaction. The rate recorded on our Sales Orders is the rate we had entered in the period of the Sales Order. I will have to work around it.

[Tom Concannon]

Well I know that the exchange rate is stored on each individual transaction because you can see it in transaction search results. I don’t know how you can identify this field in the ODBC views but it is probably in there somewhere. Sorry for the lack of a detailed solution but maybe Suite Answers or NetSuite Central has help to figure this out.

[rnedelkow]

There is a Currency Rates view that has the exchange rate.

Thanks,

[DBL]

RE: Querying Transaction Tables using ODBC

Originally posted by Tom Concannon

View Post

Well I know that the exchange rate is stored on each individual transaction because you can see it in transaction search results. I don’t know how you can identify this field in the ODBC views but it is probably in there somewhere. Sorry for the lack of a detailed solution but maybe Suite Answers or NetSuite Central has help to figure this out.

For info, the ‘override’ exchange rate is not in my Transaction view either.

I guess you could get an implied rate from the Transaction_Line view using Amount / Amount_Foreign for the ‘total’ record (Transaction_Line_Id=0 ?) but with Amount being rounded to 2 decimal places, I don’t know if this will be accurate enough

[dnewnham]

Thanks for that idea. I can probably also look up the rate for the same period as the transaction was created. That will probably do me for now.

[Author]

Posts