We outsource for 3000$ per month. Add feature to PHP code

Cancelled Posted Apr 20, 2013 Paid on delivery
Cancelled Paid on delivery

We have created a solution to do bank reconciliation here: [login to view URL]

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: [login to view URL]

At [login to view URL] 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 [login to view URL] 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: [login to view URL]

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 [login to view URL] 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 [login to view URL] 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 [login to view URL], 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.

We have already developed a solution to convert currencies at historical rates, created as a part of this project: https://www.freelancer.com/projects/PHP-Javascript/Create-PHP-module-convert-currencies.4289750.html It can be seen in action here: [login to view URL] That solution utilizes [login to view URL] to download historical rates. I will provide the source code shortly.

Please read the requirements/getting started guide here before starting on this task. [login to view URL]

CakePHP Java JavaScript PHP Symfony PHP

Project ID: #4447642

About the project

Remote project Active Apr 20, 2013