Results 1 to 4 of 4
  1. #1
    3 Star Lounger
    Join Date
    Jul 2001
    Location
    Florida, USA
    Posts
    394
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Job Costing/Management (Office 2000)

    Hello,
    Does anyone have or know where I can purchase a Job Costing / Job Management database template for Access? I need to somehow set up a database that would show the project status and ongoing costs for each item that we sell. Sounds like a overwhelming task to start from scratch and I thought if someone already has one built, I can perhaps change it a little for our needs.

    Perhaps someone can direct me to where I could go to inquire.
    Louise

  2. #2
    Super Moderator
    Join Date
    Aug 2001
    Location
    Evergreen, CO, USA
    Posts
    6,624
    Thanks
    3
    Thanked 60 Times in 60 Posts

    Re: Job Costing/Management (Office 2000)

    Do you need a full set of accounting features in addition to the Job Costing functions? If you do, I would seriously discourage you from trying to develop it on your own. We put over 1000 hours into the development of a Job Cost Accounting package, and sold a dozen or so, but Peachtree came out with some basic job costing capabilities in their Complete system a few months later, and that pretty much shut down our sales opportunities. There are some basic accounting systems that you can get the code for - see Tony Towes' Accounting Software List. Also, is your application related to the construction industry, or is it a "custom manufacturing" situation? The bottom line is that even for a mid-scale system with full accounting, you could easily purchase something like MAS 90 with it's Job Costing add-on.
    Wendell

  3. #3
    3 Star Lounger
    Join Date
    Jul 2001
    Location
    Florida, USA
    Posts
    394
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Job Costing/Management (Office 2000)

    Thanks Wendell for the reply. No, we won't be needing a full set of accounting features. I used Peachtree at my previous job and it did a very good job with the job costing feature. This job used QuickBooks which also has a job costing feature but I don't think it's as good as Peachtree's. What I was thinking was more on the line of job tracking. Is it on schedule? Are the costs in line? Did the parts we ordered come in, if not........ Would actually be closer to an Earned Value Management System. I was told today to learn MS Project for some of it and we've been in touch with an Access developer who has done this sort of thing before. Depending on the cost, we may go that route. This way the database could grow as we grow.
    Thanks again,
    Louise

  4. #4
    Super Moderator
    Join Date
    Aug 2001
    Location
    Evergreen, CO, USA
    Posts
    6,624
    Thanks
    3
    Thanked 60 Times in 60 Posts

    Re: Job Costing/Management (Office 2000)

    MS Project will probably do a fair bit of what you are being asked to do - it's a fairly powerful Project Management package, and with the Professional version it will actually store the data in SQL Server rather than the store the standard version uses which was derived from Excel many generations ago. You can also automate Project with Access, or vice versa - though it can result in a fairly large and complex development project. The challenge of course is that if you have to put cost data in both a Project Management system and an Accounting system, how do you avoid double data entry??? For a while, Peachtree had a version of their basic accounting package which supported Automation, but I understand they withdrew it when they were acquired by their current owners. <img src=/S/disappointed.gif border=0 alt=disappointed width=15 height=15>
    Wendell

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •