Skip to main content
Solved

Is there a currency conversion process in FSM?

  • August 26, 2020
  • 3 replies
  • 399 views

jbernardo
Hero (Partner)
Forum|alt.badge.img+13

All of our prices are in CAD since we are Canadian company. 

If we have to bill a customer who’s bill to is listed as USD, then the pricing rules will not take effect due to the pricing rules listing only CAD. If we put the converted rate as USD, that will quickly go out of date with how quickly rates change.

My question is: Does FSM have a way to convert it based on current exchange rate? or must it be set by whichever price is in the pricing rule?

Best answer by anmise

All of our prices are in CAD since we are Canadian company. 

If we have to bill a customer who’s bill to is listed as USD, then the pricing rules will not take effect due to the pricing rules listing only CAD. If we put the converted rate as USD, that will quickly go out of date with how quickly rates change.

My question is: Does FSM have a way to convert it based on current exchange rate? or must it be set by whichever price is in the pricing rule?

You could setup an integration with a service that provides fx rates and update the CURRENCY_CONV code table. 

I didnt know about that code table! if i were to update this manually, how does this table work with pricing rules?

 

ours is currently set to this:

 

But when something is USD it comes up as $0

You’ll need prices in all your currencies. The conversion table will convert your cost to your corporate currency (e.g. USD to CAD) and you also get the converted price on the invoice.  

3 replies

  • Superhero (Employee)
  • August 27, 2020

All of our prices are in CAD since we are Canadian company. 

If we have to bill a customer who’s bill to is listed as USD, then the pricing rules will not take effect due to the pricing rules listing only CAD. If we put the converted rate as USD, that will quickly go out of date with how quickly rates change.

My question is: Does FSM have a way to convert it based on current exchange rate? or must it be set by whichever price is in the pricing rule?

You could setup an integration with a service that provides fx rates and update the CURRENCY_CONV code table. 


jbernardo
Hero (Partner)
Forum|alt.badge.img+13
  • Author
  • Hero (Partner)
  • August 27, 2020

All of our prices are in CAD since we are Canadian company. 

If we have to bill a customer who’s bill to is listed as USD, then the pricing rules will not take effect due to the pricing rules listing only CAD. If we put the converted rate as USD, that will quickly go out of date with how quickly rates change.

My question is: Does FSM have a way to convert it based on current exchange rate? or must it be set by whichever price is in the pricing rule?

You could setup an integration with a service that provides fx rates and update the CURRENCY_CONV code table. 

I didnt know about that code table! if i were to update this manually, how does this table work with pricing rules?

 

ours is currently set to this:

 

But when something is USD it comes up as $0


  • Superhero (Employee)
  • Answer
  • August 30, 2020

All of our prices are in CAD since we are Canadian company. 

If we have to bill a customer who’s bill to is listed as USD, then the pricing rules will not take effect due to the pricing rules listing only CAD. If we put the converted rate as USD, that will quickly go out of date with how quickly rates change.

My question is: Does FSM have a way to convert it based on current exchange rate? or must it be set by whichever price is in the pricing rule?

You could setup an integration with a service that provides fx rates and update the CURRENCY_CONV code table. 

I didnt know about that code table! if i were to update this manually, how does this table work with pricing rules?

 

ours is currently set to this:

 

But when something is USD it comes up as $0

You’ll need prices in all your currencies. The conversion table will convert your cost to your corporate currency (e.g. USD to CAD) and you also get the converted price on the invoice.