Method Community

One of my issues is related with the currency field in Estimates, Work Orders, Sales Orders and Invoices. It is not actually working. I mean if I choose a Customer and I include the currency code field to show in the form only home currency will show, and if a Customer has another currency code it won't show. We need users to know the currency of the Customer:Job in all the templates.

Hi Marco,

I recently wrote a post on how you can handle currency symbols when dealing with multi-currency. I’ll quote my answer below, as I believe this applies to what you are attempting. If you have any follow up questions, feel free to post back.

Method_Audisho:

Within Method, the currency symbol is hardcoded in numeric fields on Step 4.

You can circumvent this by removing the symbol from the field and instead using a label to display the symbol. Create some actions on your OnScreenLoad and TextChange of the Currency dropdown events for populating the label(s).

As for reports, you can handle this a few different ways. If you want the currency symbol to be displayed based on the user’s region setting of their computer, simply change the format string of the field to “{0:C2}”.

Additionally, you can set the currency symbol based on the currency of the transaction in one of two ways. One would be to add each money field to the report multiple times setting the format string to match a specific currency. The default format string “{0:$0.00}” will work for this, just modify the symbol. Then use conditional formatting to display the correct field(s) based on the selected currency.

Another way would be to write a script that would do essentially the same thing except that it would update the format string of the field so that you would not need to add it to the report multiple times.

Does this answer your question? Let me know if you need any further clarification.

I hope this helps.

-Audisho