Method Community

Hello Justin. I haven't been able to make the grid calculate and make my line item prices and total amount convert into dollars. For some reason Exchange Rate linked field is not retrieving the appropriate rate, it shows up as 1 where it should be 21.69. I also looked at the table in MS Excel via ODBC and ER shows up as 0. I think maybe ...

I first need to make the template work. Our Item list prices are in HNL (home currency) and at this moment al our forms in Method (Estimates, Sales Orders, Invoices) show item lines in grids in HNL, even though our customers are in USD. I need all money amounts within templates to convert automatically to USD using the exchange rate ...

Justin, thank you very much. You're right, it's prices that need to be changed. I need forms (Estimates, Sales Orders, Invoices, etc.) to behave as in QB ,where item prices, sales tax and total amount depend on the customer:job's currency. Home currency is different than USD.

I'm trying to make a Work Order automatically calculate foreign currency amounts directly in item grid. Item Cost comes in home currency even though selected customer is in foreign currency. I believe I need to configure some kind of action within grid to have the automatic calculation using actual QB exchange rate.