This is a accounting software therefore I would need someone to help me complete a scripting page using PHP and MYSQL coding. The job is required to does the following.

- Record an entry of payment either by Check/Cash in MYSQL.


- Calculated the customer balance left brought forward from previous payment and include the current payment.


- Based on the amount of payment marked paid in the invoices table based on the earliest date ascending, until it reaches value of the total paid amount.


- Update the remaining balance of the amount into the customer record balance in the MYSQL.


- Generate a text report based on this with the Payment details, Invoices being cleared and balance left over. And store the text report in the MYSQ entry to be used by another program later.