Here is a diff file which should update the sourceforge code to the latest code.
As well as the taxes issue it also includes a couple of extras with a separate authoriser possible for assignment of cash and for expenses, and it also has a default tag field in the pctab as it will frequently be the same tab for all expenses.
As a final thing on this I have also written the code to upload and display scans of receipts so that the person authorising can view the actual receipt. It would be nice to have a small mobile app that allowed the claiming of expenses directly from a mobile device so a photo can be taken of a receipt and then uploaded by remote workers.
Anyway it is probably best if I hold off loading that code here (though it's on my github page) till the previous code is committed or it could get complicated.
I have written a little javascript application that allows employees out on the road to upload expenses claims. They can take photos of receipts and upload them alongside the relevant claim so that the authoriser can view them. It is written in a way that can be easily compiled as a cordova app.
I have tested it on a number of devices and it seems to work ok
Of course it depends on the previous work I have posted in this thread so we will have to wait for that to be committed.
I have just picked this up again.
I getting an SQL error with your new code in PcExpenses.php:
Database Error 1064 :
You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near ')' at line 12
Database SQL Failure : The SQL that failed was
INSERT INTO pcexpenses (codeexpense, description, glaccount, tag, taxcatid) VALUES ('999', 'TestXYZ', '1060', '0', '5', )
I have attached the script, as it has been tweaked slightly on run with the webERP database.
As I mentioned in another post, your work on Petty Cash Tax has been committed to the trunk.
There was a little bit of work needed to integrate it into the webERP environment (as you can probably imagine), and only a few little bugs encountered.
You mentioned that you had written a javascript mobile app for expenses entry and receipt capture. Are you able to share that?