FX Rate Setup

[iwells]

Hi,

Wondering what the implications of deleting a rate table and recreating it with a different setup (switching from multiply to divide) are in the system? We have 2 branches which have been using multiply with the multiplication rate, but they should be using division with the division rate. Management wants these branches corrected for standardization as well as audit purposes.

I see most tables store the historical rate and the rate operator so I assume (ugh) when processing differences based on exchange rates in the system the application looks at the transaction information and not the currency table. If that's the case I could delete the table and recreate and only enter the new division rates as of today.

I see there's an old post by johnhugh (

http://www.tek-tips.com/viewthread.cfm?qid=1619229)

but his issue is different than mine in that his operator was all that's wrong, all my rates are the reverse of what we want them to be.

Advice?

Thanks,
Ian

 

[ettienne]

You can switch them, it does not affect posted transactions.

Sage 300 ERP Certified Consultant

http://www.adssglobal.net

 

[iwells]

So I can simply delete the old rate table and recreate it starting today and ignore the 2-3 years go rates entered in the system?

 

[ettienne]

You could or not.

Sage 300 ERP Certified Consultant

http://www.adssglobal.net