Bug#334527: sql-ledger: Exchange rate is easy to get wrong and impossible to edit
Gerardo Reynoso [EMAIL PROTECTED] writes: Package: sql-ledger Version: 2.4.7-2 Severity: normal It is remarkably easy to get the exchange rate wrong when entering AR items - either you put in 1/rate rather than rate or you forget it at the beginning or the payment rates wind up at 100. Once this is done, you can't edit the exchange rate in the payment line. Trying to add a new payment line with a new exchange rate gets the old exchange rate again. Removing and adding back the payment line gets the old exchange rate. The only reliable method I have found to date is: dump the database edit the error in the SQL reload the database. Being able to edit the Exchange Rate fields in the Edit AP Transaction dialogue would solve all this. It is true you cannot edit the exchange rate, but you can delete the wrong exchage rate and post it again as follows. [method for deleting by removing all relevant transactions] The reason for this is that if you could edit the exchange rate then all the accounting transactions using the edited exchange rate will need to be found and reposted again.This also will modify posted accounting transactions on the system. This assumes that the exchange rate applies to all transactions made on a given day, which I hope is *NOT* the case. All I want is the ability to modify the exchange rate applied to the transaction on the screen - *NOT* to modify any others. (In fact, automagically linking other transactions on the same day to the exchange rate is worryingly close to being a bug in itself). cheers, Rich. cheers, Rich. Hope this help to get around this trouble. I do not know if this will help for closing this bug. Regards, Gerardo Reynoso -- rich walker | Shadow Robot Company | [EMAIL PROTECTED] technical director 251 Liverpool Road | need a Hand? London N1 1LX | +UK 20 7700 2487 www.shadow.org.uk/products/newhand.shtml -- To UNSUBSCRIBE, email to [EMAIL PROTECTED] with a subject of unsubscribe. Trouble? Contact [EMAIL PROTECTED]
Bug#334527: sql-ledger: Exchange rate is easy to get wrong and impossible to edit
Hi Rich, On Monday 07 November 2005 08:46, you wrote: Gerardo Reynoso [EMAIL PROTECTED] writes: This assumes that the exchange rate applies to all transactions made on a given day, which I hope is *NOT* the case. The exchange rate is indeed the default all the ar/ap transactions will use unless you specify anoter exchange rate while applying a transaction via gl instead of ar/ap transaction or invoice. Also, while making a payment you can specify a different exchage rate. All I want is the ability to modify the exchange rate applied to the transaction on the screen - *NOT* to modify any others. Unfortunately this is not possibly on sql-ledger as only one exchange rate is allowed per day. As stated before there is no edit interface present for the exchange rate, you need to delete and repost all transactions for that specific day. (In fact, automagically linking other transactions on the same day to the exchange rate is worryingly close to being a bug in itself). Maybe it is more close to being a feature instead of a bug, :). More seriously, this (the edit exchange rate interface omission) seems to be intended to avoid some COGS problems that can happen while reposting invoices under certain circumstances (more info on this can be found on the sql-ledger project mailing list on sourceforge). Regards, Gerardo Reynoso -- To UNSUBSCRIBE, email to [EMAIL PROTECTED] with a subject of unsubscribe. Trouble? Contact [EMAIL PROTECTED]
Bug#334527: sql-ledger: Exchange rate is easy to get wrong and impossible to edit
Package: sql-ledger Version: 2.4.7-2 Severity: normal It is remarkably easy to get the exchange rate wrong when entering AR items - either you put in 1/rate rather than rate or you forget it at the beginning or the payment rates wind up at 100. Once this is done, you can't edit the exchange rate in the payment line. Trying to add a new payment line with a new exchange rate gets the old exchange rate again. Removing and adding back the payment line gets the old exchange rate. The only reliable method I have found to date is: dump the database edit the error in the SQL reload the database. Being able to edit the Exchange Rate fields in the Edit AP Transaction dialogue would solve all this. It is true you cannot edit the exchange rate, but you can delete the wrong exchage rate and post it again as follows. To post a new and hopefully correct exchange rate you will need to delete all the ar/ap transactions (not only payments) using the wrong exchange rate. While deleting the last remaining transaction this will also delete the wrong exchange rate. Now you can add again the transactions and payments previously deleted. While adding the first transaction you can also add the correct exchange rate. The reason for this is that if you could edit the exchange rate then all the accounting transactions using the edited exchange rate will need to be found and reposted again.This also will modify posted accounting transactions on the system. cheers, Rich. Hope this help to get around this trouble. I do not know if this will help for closing this bug. Regards, Gerardo Reynoso -- To UNSUBSCRIBE, email to [EMAIL PROTECTED] with a subject of unsubscribe. Trouble? Contact [EMAIL PROTECTED]
Bug#334527: sql-ledger: Exchange rate is easy to get wrong and impossible to edit
Package: sql-ledger Version: 2.4.7-2 Severity: normal It is remarkably easy to get the exchange rate wrong when entering AR items - either you put in 1/rate rather than rate or you forget it at the beginning or the payment rates wind up at 100. Once this is done, you can't edit the exchange rate in the payment line. Trying to add a new payment line with a new exchange rate gets the old exchange rate again. Removing and adding back the payment line gets the old exchange rate. The only reliable method I have found to date is: dump the database edit the error in the SQL reload the database. Being able to edit the Exchange Rate fields in the Edit AP Transaction dialogue would solve all this. cheers, Rich. -- System Information: Debian Release: testing/unstable APT prefers testing APT policy: (990, 'testing'), (500, 'stable') Architecture: i386 (i686) Shell: /bin/sh linked to /bin/bash Kernel: Linux 2.4.31 Locale: LANG=C, LC_CTYPE=C (charmap=ANSI_X3.4-1968) Versions of packages sql-ledger depends on: ii apache [httpd]1.3.33-8 versatile, high-performance HTTP s ii libdbd-pg-perl1.42-2 a PostgreSQL interface for Perl 5 ii perl 5.8.7-3Larry Wall's Practical Extraction sql-ledger recommends no packages. -- no debconf information -- To UNSUBSCRIBE, email to [EMAIL PROTECTED] with a subject of unsubscribe. Trouble? Contact [EMAIL PROTECTED]