Changing exchange rates for posted invoices/credit notes

Navidude

HI,
I'm trying to figure out how to change a posting date and exchange rate for a posted credit note. If anyone knows how to do this, the help will be much appreciated.

Thanks,
Navidude

kine

The exchange rate is used from exchange rates for the currency, based on the posting date of the documents. What you want to change? You want to change the rate, the date used for this or what you need to do in different way?

kriki

Once posted, you can't change those fields.

-You can manually change the posting date in all the tables where something is written. But before doing this, you have to know very well what you are doing.
-The exchange rate is close to impossible, because it has been used to convert the foreign currency in LCY and this has been written in T17,T21,...

Navidude

Thanks for your imput. I can change the posting date (27-01-06) to the new date (16/2/06) but I still have problems with getting the exchange rate to adjust to that of 16/2/06. I understand that there are a lot of tables that need to be altered, and I'd like to keep this as clean as possible. What are my options for canceling this credit note and making a new one? Any help I can get will make my accountants very happy.

Thanks,
Navidude

kriki

Navidude wrote:

What are my options for canceling this credit note and making a new one? Any help I can get will make my accountants very happy.

The option is to make it worse. You can't just delete records from some tables.
E.g. posted invoices or credit memo's. If you delete 1, you numbering will contain gaps and I don't know for your country, but in all countries I know: the tax-controllers get VERY upset about that.
Deleting entries in the customer/vendor/item ledger entries : also that is close to impossible because they get connected to other entries and if an entry does not exist anymore, the Navision DB gets very upset about it.
I am afraid the accountants will have to fix it in an accountant way, not in a programmers way. They will have to create an invoice (or journal line) to undo the data generated by the wrong credit memo and then create the correct credit memo.

radianis

Hi Navidude,

I agree with kriki that you should not change the table because it will make a lot of people suffers. By the way, I think your accountant will also be happy by telling him/her that Navision protect such a thing for information integrity, so nobody could play with number. But if you do that (I suggest not to do it), please don't tell internal or external audit, they will think your financial system is unreliable. For accountant, errors is okay, you can change the net difference either plus or minus by entering to journal. Or create credit memo with the same conditions with the error one and then create the new invoice, then finito ...
........