Thread Rating:
  • 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
Petty Cash and Tax
12-11-2016, 10:25 AM,
#11
RE: Petty Cash and Tax
Hi Tim,

Great work.
I will pull these down from your github account and will try to get them working on my webERP test site.

Did you get a chance to look at Tax.php?
It would be great to have the net value and tax for each expenses captured in the Tax report PDF.

Andy.
https://www.linkedin.com/in/andrewcouling
Reply
12-11-2016, 11:52 PM,
#12
RE: Petty Cash and Tax
Hi Andy, this is done now and committed to github.

I can produce a diff file against the latest sourceforge code if there is a demand for it.

Tim
Reply
12-12-2016, 08:57 AM,
#13
RE: Petty Cash and Tax
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.

Testing and bug reports are appreciated.

Cheers
Tim


.gz   PettyCash.diff.tar.gz (Size: 33.85 KB / Downloads: 9)
Reply
12-13-2016, 01:55 AM,
#14
RE: Petty Cash and Tax
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.

Tim
Reply
12-21-2016, 07:48 AM,
#15
RE: Petty Cash and Tax
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.

Tim
Reply
12-21-2016, 07:58 AM,
#16
RE: Petty Cash and Tax
Hi Tim,

Thanks for the update. Great work.

Apologies for my delayed response - I have been busy with work the last couple of weeks.

I hope to test your code of my site over the Christmas period, and help to facilitate with it being committed.

Andy.
https://www.linkedin.com/in/andrewcouling
Reply
07-14-2017, 12:00 AM,
#17
RE: Petty Cash and Tax
Hi Tim,

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.

Can you see what is causing the error?

Andy.


Attached Files Thumbnail(s)
   

.php   PcExpenses.php (Size: 12.01 KB / Downloads: 2)
https://www.linkedin.com/in/andrewcouling
Reply
07-14-2017, 12:31 AM, (This post was last modified: 07-14-2017, 12:33 AM by TurboPT.)
#18
RE: Petty Cash and Tax
@afcouling:

Looks like you can simply remove the trailing comma at the end of line 88.
Reply
07-14-2017, 12:55 AM,
#19
RE: Petty Cash and Tax
Solved. I didn't spot that. Thanks for your help.
https://www.linkedin.com/in/andrewcouling
Reply
09-12-2017, 07:07 AM,
#20
RE: Petty Cash and Tax
Hi Tim,

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?

Many thanks for all your efforts.

Andy.
https://www.linkedin.com/in/andrewcouling
Reply


Forum Jump:


Users browsing this thread: 1 Guest(s)