Hi We have a problem with the adjust echange rates routine. When it runs it updates the exchange rates, even if we have changed the currency factor. This is causing a problem as the actual amount posted on the invoice then differs to the actual amount that the would be within the customer ledger for that document. Has anyone else encountered this or know of a solution? We are using 3.6. Many thanks Chris
Hi Chris I am kind of confused by your question. If your base currency is GBP and you invoice a $1000 it will have a home value. If the exchange rates alter the value of the invoice in GBP can move up or down, but the customer will still owe you $1000. When you alter the currency factor this is the static rate moving forward so the customer ledger will not be reflecting the actual current value, unless you run the adjust exchange rate routine, which revalues your currency transactions based upon the latest rates. My confusion probably stems from not understanding your issue. I think this works fine, the invoice will always remain at “X” in foreign currency whilst in the ledgers the value move with the currency rates and the adjust routine. At least that is the way I remember it I am not infront of the software at the moment. [:D]
I can assure you that the Exchange Rate Routine works fine, the process does not alter posted entries, e.g. the amounts posted to G/L will have the Rate of the original transaction, but as a customer debt of 1.000 usd will have a different valuation at the end of the month, the pending amount in LCY will be updated in the Customer Ledger accordingly. Additionally you have a couple of fields in the Customer Ledger Entry, that save the historical values, e.g. Amount, Remaining Amount, Original Amt. (LCY),Remaining Amt. (LCY),Amount (LCY). All these fields should give you all the necessary info you need. In fact, all these fields are just flowfields that related to the Detailed Customer Ledger Entry where you find the whole history of the application. Saludos Nils