Hello.
I am trying to get a project to work, I have uploaded it to the demo site.
What it is every month we get a bank statement, we have to allocate the money into different categories, so on the add page, we put in the amount from a line in a statement. This amount might be £879.59 but only £400.00 of it might have been on materials for a job known as stock, and the remaining £479.59 might be to replace office items.
What we do at the moment is use Rapid File, and we enter the amount of £879.59, this deducts the VAT content by /47*7 and then subtracts the VAT content from the amount to leave us with the net amount of £748.59
So on the add page I enter in the Amount or £879.59 and the person who it was paid to.
On the list page it now displays the Amount paid of £879.59, the VAT Amount of £131, The net Total of £748.59 and the Audit Total of £748.59
If I now go onto the edit page and put £200 in for STOCK and save it, back on the list page the AUDIT AMOUNT is now down to £548.59, so I can see I am allocating all the money until my AUDIT AMOUNT is £0.00.
This is long winded, as I have to either do the maths before hand, of keep saving and going back to the list page to see what my AUDIT AMOUNT is, Is there a PHP Code Snippet I can either put on to the Add page, so when I enter the Amount, it can show the net cost in a separate box, and as I enter the amounts in the fields, it will subtract it from the value in the PHP Code Snippet box until that comes down to zero, Probably using the same code I use for the AUDIT AMOUNT, or will it have to go on the edit page?
I have put a demo to the project here.
http://demo.asprunner.net/pggrimes%5Fhotma...st.php?a=return
I do hope you can help me on this, as I am now pulling out my hair, and trust me, there is not much left.
Thanks
Paul.