Skip to main content
Solved

Is there a currency conversion process in FSM?


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

jbernardo wrote:
anmise wrote:
jbernardo wrote:

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.  

View original
Did this topic help you find an answer to your question?

3 replies

  • Superhero (Employee)
  • 1426 replies
  • August 27, 2020
jbernardo wrote:

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)
  • 171 replies
  • August 27, 2020
anmise wrote:
jbernardo wrote:

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)
  • 1426 replies
  • Answer
  • August 30, 2020
jbernardo wrote:
anmise wrote:
jbernardo wrote:

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.  


Reply


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings