You have chosen to sponsor your bid up to a maximum amount of .
We have created a solution to do bank reconciliation here: http://images.open-org.com/OO-developers/PhotoAccounting/Reconciliation.php
The solution is half-finished and has several bugs/limitations. In order to speed up the development, I want another developer on the project. The starting point is the new feature described here in this project.
To read some background about what a bank reconciliation is and hence the purpose of the software, have a look at the document I have written here: https://docs.google.com/document/d/1NgfB4qXVUPjvmdNbOoS2km7kWv3UbSbaSV_V4c1orUs/edit?usp=sharing
At http://images.open-org.com/OO-developers/PhotoAccounting/Reconciliation.php the left table shows receipts we have typed, and the right column shows the transactions found in the bank.
A limitation of the current solution is that sometimes a receipt will be in a non-danish-currency amount (short form DKK) (like for example dollars). In these cases, the http://images.open-org.com/OO-developers/PhotoAccounting/typer.php interface will set an amount in the amount_original_currency column in the database in the receipt table, but leave the "amount" column empty. The database can be inspected here: http://images.open-org.com/phpPgAdmin/display.php?server=ec2-23-21-91-85.compute-1.amazonaws.com%3A5432%3Aallow&database=d5vaere0kead0i&schema=public&table=receipts&subject=table&return=table
The change I need is that when a row in the database has a row with an empty value in the "amount" column at the point when the reconciliation.php is accessed, then the amount should get converted to DKK so that this converted amount is presented in the "amount" column in the left table in http://images.open-org.com/OO-developers/PhotoAccounting/Reconciliation.php. The amount in the table should be red to indicate that it may not be the exactly correct amount (the exchange rate might be slightly off).
When the record is matched with a column in the right table in reconciliation.php, the amount should get updated to the amount from the bank (but it should stay red, in the case where the match was wrong and should be redone). Basically it means that all receipts that have a currency set to something else than DKK, should be in red.
Please read the requirements/getting started guide here before starting on this task. https://docs.google.com/document/d/1biEViRLFwlG7GnO_NHYa6m_U0YiUKU9oNpRoCcO4xak/edit