Thread Rating:
  • 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
how to record labor hours spent on a project
09-28-2016, 04:54 AM,
#1
how to record labor hours spent on a project
Hi all, I would like to record the hours employees spend on various internal projects as well as holidays, sick time, etc., so that I can get a big picture for where the time has gone. Is it possible to do some or all of this in WebERP? How?

Thanks,
Dale
http://www.dalescott.net
Reply
09-28-2016, 05:01 AM,
#2
RE: how to record labor hours spent on a project
Hi Dale I do remember years ago we were sent a contribution that enabled the filling in of timesheets. If you like i can see if i can dig it out

Tim
Reply
09-28-2016, 09:40 AM,
#3
RE: how to record labor hours spent on a project
Pasting my response on the mailing list for the record

Hi Dale,

>I could create
> a part number for each project, and use work orders to record labor as
> if the project was a production part. Is this possible?

Yes that's correct... you can create any number of labour type items ... the stock type when you define a stock category allows for a labour type to be defined - this then allows for GL entries to recover labour (CR a P & L account/DR WIP) when there is an issue of this labour to a work order. These labour items can also be part of the bill of material at a particular work centre.

Not sure of any other way... a timesheet interface would be cool to put time into works orders with employees in particular work centres perhaps mapped to labour items.

Phil
Phil Daintree
webERP Admin
Logic Works Ltd
http://www.logicworks.co.nz
Reply
03-17-2017, 08:34 AM,
#4
RE: how to record labor hours spent on a project
(re-opened to move discussion on project management from "Sales Process - Purchase Flow" forum thread ).

Hi @phil, I had understood from the discussion on the mail list that a strategy using manufacturing workorders for projects might be viable, as would a strategy based on using contracts. I intend to work through the manufacturing strategy, after working through the manufacturing process for a real assembly. Do you have any new thoughts on this?

The updated draft tutorial has a new URL http://www.dalescott.net/managing-projects-using-weberp/.

2017-03-16
dalescott
*******
@phil, was your comment about the lack of project management functionality directed at the "project management" bullet in my reply to the OP? My intention is to use existing functionality only as a baseline for what can be achieved without adding any new features.

You may recall our discussing this last fall on the forum, and on the web-erp-users mail list. I'll "re-open" our old forum thread so we can discuss this further without hijacking this thread (I need to post an updated URL for my draft tutorial anyway).

2017-03-15
phil
*******
RE: Sales process - purchase flow
There is no project management functionality - I have spec'd a construction contract/project consisting of multiple webERP contracts at

http://www.weberp.org/wiki/ProjectManage...Completion

http://www.dalescott.net
Reply
03-17-2017, 12:56 PM, (This post was last modified: 03-17-2017, 12:58 PM by dalescott.)
#5
RE: how to record labor hours spent on a project
@falkoner (and yeah, I'm guessing tags aren't generating notifications), I seem to recall having searched the mail archives before for "timesheet" and not finding anything useful. It would be great if you could find those timesheet files. It would be even greater if you summarized the interface with webERP..... and..... if it's not asking too much..... ;-) technically how much work do you think there is to get the absolute minimum working? Thanks! Dale

@phil, I was hoping you would carry over any new thoughts on doing the best with what there is. I'm still pursuing creating an item with BOM to represent a project, and creating a work order to capture the labor costs of the project as well as any material costs e.g. prototype part purchasing, prototype pcbs, etc.), or maybe create a separate work order for each phase of a project. Are there any reasons why you would prefer a different _existing_ approach, e.g. contracts? Can anyone else add anything?
http://www.dalescott.net
Reply
03-17-2017, 08:36 PM,
#6
RE: how to record labor hours spent on a project
(03-17-2017, 12:56 PM)dalescott Wrote: @falkoner (and yeah, I'm guessing tags aren't generating notifications), I seem to recall having searched the mail archives before for "timesheet" and not finding anything useful. It would be great if you could find those timesheet files. It would be even greater if you summarized the interface with webERP..... and..... if it's not asking too much..... ;-) technically how much work do you think there is to get the absolute minimum working? Thanks! Dale

Hi Dale, I have sent you the patch I received by email. I got it to work so you can record the details, but that is all it is doing at the moment. It doesn't use the information. It also requires a bit of TLC to bring it in line.

Thanks
Tim
Reply
10-25-2018, 05:49 AM,
#7
RE: how to record labor hours spent on a project
Dale,
I have finally summoned the enthusiasm to extend this area. I wrote up a spec at http://www.weberp.org/wiki/ProjectManage...Completion for accounting for projects and % completion accounting.
I started work with an employees table and next stop is timesheet entry. Of course this is would allow labour recording against work orders in general not specifically for the wider project accounting goal. I would be interested in this script of Tim's if it was of any use and your thoughts on how this should work.
I was thinking about using a phone app and importing records, but on reflection it is probably best to have it all in webERP.

Phil
Phil Daintree
webERP Admin
Logic Works Ltd
http://www.logicworks.co.nz
Reply
10-31-2018, 02:19 AM, (This post was last modified: 10-31-2018, 12:52 PM by dalescott.)
#8
RE: how to record labor hours spent on a project
Hi Phil, sorry for my tardy response, I skimmed your spec on the wiki but will review in detail and comment more back here. I don't have a clear vision for timesheets and project management but it looks like a good path to start down.

I searched for the timesheet files from Tim, but although I found later correspondence about the files unfortunately I don't have the files themselves. Tim, if you're listening, could you post the files to this thread?

I agree also with not using a separate timesheet app, but I expect if an organization starts using timesheets in webERP there could be many users who will need _only_ timesheets compared to other webERP features, and perhaps the experience will need to be optimised, e.g. from a timesheet button in the top-menu, to a separate timesheet login and resulting experience, to a complementary stand-alone web app (IMHO creating and maintaining a native timesheet app is probably too much work).

Cheers,
Dale
http://www.dalescott.net
Reply
10-31-2018, 02:54 AM,
#9
RE: how to record labor hours spent on a project
(10-31-2018, 02:19 AM)dalescott Wrote: I searched for the timesheet files from Tim, but although I found later correspondence about the files unfortunately I don't have the files themselves. Tim, if you're listening, could you post the files to this thread?

Hi Dale, here is the patch, I sent it to you on 17/3/2017 if that helps.

The patch isn't mine it was sent to me by Heinrich Steubler (aka Mr Solar) and I take no credit, or responsibility for it Smile

Tim


.gz   65f6db06922418801257e69144ba439686c596b5.patch.tar.gz (Size: 4.35 KB / Downloads: 1)
Reply
10-31-2018, 02:24 PM,
#10
RE: how to record labor hours spent on a project
Thanks Tim! :-) Wish I had your filing system.

Phil, if you put preliminary code on a public server I'd be happy to help test.
http://www.dalescott.net
Reply


Forum Jump:


Users browsing this thread: 1 Guest(s)