Changing currency rate changes old order invoices ?

Hi Cs-carters,



I am running mve 3.0.3

My audience is kuwait, so I had kept base currency as USD and secondary currency as KWD with some rate.

Now, when I want to change the rate it affects old invoices in KWD

Should currency rates be part of the invoice ?

Has anyone faced this issue before ? If yes whats the workaround ?



regds,

Shikhar

Hi Cs-carters,



Cs-cart support replied that its a standard functionality, they could do custom development.

I believe currency rate should be part of the invoice and the invoice in secondary currency shouldn't change ever.



Anyways, I fixed it somehow by modifying old invoices and products prices in my primary currency.

So it shows up fine in secondary currency with new conversion rate.

^ agreed.

I don't (yet) run with multiple currencies, but this is a major worry if I am interpreting this correctly…



You set up USD and KWD, with currency values like this, as an example:



USD = 1

KWD = 1.50



Your completed orders/invoices all show the total order price being USD $100, KWD 150.



Now you change the KWD currency rate to 1.4, so your old orders/invoices show a total order of USD100 and KWD 140…is that what you mean?



This may well be a game changer for me with using CS-Cart for a new store, especially considering CS-Cart expect you to pay for “custom development” to fix what is effectively a “working as designed, yet faulty in practice” function.

StellarBytes, Yes you are absolutely correct, this is what will happen.

Even if Cs-cart modifies code to show customers' invoice with previous conversion rate, I would be happy.

Though strictly speaking it should be everywhere. But I don't know how big a change that will be and how much affect it will have on reports by making them slow.

[color=#282828][font=arial, verdana, tahoma, sans-serif]“to fix what is effectively a “working as designed, yet faulty in practice” function.”[/font][/color]



[color=#282828][font=arial, verdana, tahoma, sans-serif]Clearly a design bug[/font][/color]

[quote name='Traveler' timestamp='1372080155' post='164263']

[color=#282828][font=arial, verdana, tahoma, sans-serif]“to fix what is effectively a “working as designed, yet faulty in practice” function.”[/font][/color]



[color=#282828][font=arial, verdana, tahoma, sans-serif]Clearly a design bug[/font][/color]

[/quote]

If CS-Cart are requesting you to pay for “custom development”, then it isn't a bug as far as they are concerned. It works how they intended. There is no database table which stores previous currency rates, so they clearly made an oversight, or didn't see the need for this functionality. Maybe that's just how things are done in Russia, I don't know. Without putting too much thought into this, I would have thought based on previous quotes I have received for “custom development” that this will cost more than the original CS-Cart license.

I think you can store conversion rates in order data and use it. I wanted to fix it that way, but it wasn't much of a paining area for me as we work in KDs only, so didn't work on it.

This is clearly a bug. It can not be seen any other way! I have the same issue. Have USD, AUD and EUR currencies. If a customer places an order in EUR, and the exchange rate changes, the EUR total of invoice changes.



Has any one lodged a bug for this? Or, does any one know if this is fixed in upcoming V4 release?

Valentin, on this forum (Vali) is a great web developer I've been using. He has a fix for this if you're willing to pay for it and consider it important enough to the running of your store (I do, and he has already applied the fix).

Thank you @Scott_C for your appreciation, the fix is not done yet but we are almost there ;)





Valentin

@Vali Sell it to Cs-cart team after you are done.

[quote name=‘Vali’ timestamp=‘1372249145’ post=‘164357’]

Thank you @Scott_C for your appreciation, the fix is not done yet but we are almost there ;)





Valentin

[/quote]



Any progress about this?

Has this been fixed yet? I am in the process of upgrading our store, and this was one of the few really annoyiing bugs contained in CS Cart. Can not believe it hasn't been fixed yet. All that has to be done is that the currency and currency rate should be stored with each order. Else, there is no way to reproduce old invoices with correct values. Clearly a bug.

I don't think it has been fixed yet. A workaround is to update your earlier order with the new currency conversion rate. That's how I did it and never changed the rate after that :P

Any update on this matter?

Kind of strange and (in some cases illegal) that the amount on old invoices changes if the currency rate changes.

Let me know if anyone knows an update :)

Any update on this matter?

Kind of strange and (in some cases illegal) that the amount on old invoices changes if the currency rate changes.

Let me know if anyone knows an update :)


Check amount in the base currency. Amounts will be always correct in this case

No, that is not entirely true:

If you have for example two currencies with USD as base:


USD = 1
EUR = 1.50

Your completed orders/invoices all show the total order price being USD $100, EUR 150.

Now you change the EUR currency rate to 1.4, so your old orders/invoices show a total order of USD100 and now EUR 140.

That is very strange that it does modify already received orders.

No, that is not entirely true:

If you have for example two currencies with USD as base:

USD = 1
EUR = 1.50

Your completed orders/invoices all show the total order price being USD $100, EUR 150.

Now you change the EUR currency rate to 1.4, so your old orders/invoices show a total order of USD100 and now EUR 140.

That is very strange that it does modify already received orders.

In CS-Cart currency rate is used to display base amount in the selected currency. Unfortunately, rates are not stored anywhere

Which is cleary a bug? Right?

As for account and tax reasons among others is 'illegal' to not store and then modify already paid and processed invoices?