Post Reply 
 
Thread Rating:
  • 0 Votes - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
Petty Cash and Tax
12-11-2016, 10:25 AM
Post: #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
Find all posts by this user
Quote this message in a reply
12-11-2016, 11:52 PM
Post: #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
Visit this user's website Find all posts by this user
Quote this message in a reply
12-12-2016, 08:57 AM
Post: #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)
Visit this user's website Find all posts by this user
Quote this message in a reply
12-13-2016, 01:55 AM
Post: #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
Visit this user's website Find all posts by this user
Quote this message in a reply
12-21-2016, 07:48 AM
Post: #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
Visit this user's website Find all posts by this user
Quote this message in a reply
12-21-2016, 07:58 AM
Post: #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
Find all posts by this user
Quote this message in a reply
07-14-2017, 12:00 AM
Post: #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 File(s) Thumbnail(s)
   

.php  PcExpenses.php (Size: 12.01 KB / Downloads: 2)

https://www.linkedin.com/in/andrewcouling
Find all posts by this user
Quote this message in a reply
07-14-2017, 12:31 AM (This post was last modified: 07-14-2017 12:33 AM by TurboPT.)
Post: #18
RE: Petty Cash and Tax
@afcouling:

Looks like you can simply remove the trailing comma at the end of line 88.
Find all posts by this user
Quote this message in a reply
07-14-2017, 12:55 AM
Post: #19
RE: Petty Cash and Tax
Solved. I didn't spot that. Thanks for your help.

https://www.linkedin.com/in/andrewcouling
Find all posts by this user
Quote this message in a reply
09-12-2017, 07:07 AM
Post: #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
Find all posts by this user
Quote this message in a reply
Post Reply 


Forum Jump:


User(s) browsing this thread: 1 Guest(s)