Skip to content
ProjectControls.com
Planning, Scheduling & Programming Discussion

Best Project Database

In the Open Standard
Nasreen AlmutawaMember for 17 years 7 months
Created
7
4
0
I work in a petrochemical company, and we are handling multiple small projects most of the time. Most of our projects fall around 2 milion dollars or below. My question is, how can I decide on the best software or / database to be used for managing all of our projects. Currently we have SAP, Primavera, and an MS Access database. and now i’m hearing about @task software as well. My goal is to have all project related information in one database and use it. This includes schedules / resources / cost / Reports generation ...etc. Please advice as i am lost.
Save Follow Follow forum Report
Reply New topic

7 replies

Oldest first
  1. 0
    Dieter Wambach ·
    #1
    Nasreen

    I don’t really understand your question and - frankly spoken - I’m doubting if you are joking.

    You have:
    - SAP: erp software faor all main business processes, but not e.g. project management. PS "Project System" is related to the cash flow for investing money e.g. for a project, and made to cooperate with a pm-software.
    - Primavera: software to support project management
    - MS Access: Small database to create reports, e.g. by integrating report files from SAP and Primavera.

    Hope that helps
    Dieter
    Report
  2. 0
    Nasreen Almutawa ·
    #2
    Dear Dieter,

    Thank you for your reply. i think i wasn’t clear. what i meant is can i use just one programme for all project management issues. as you know scheduling can be done in SAP as well. and project cost can be reflected in primavera.
    Report
  3. 0
    Dieter Wambach ·
    #3
    Nasreen

    Project costing you can do in Primavera, but NOT accounting.
    SAP PS and PM have a scheduling algorithm. But the best parameter is (dsex; I’m not sure for the name) for externally calculated. If you assign this setting to an activity its dates won’t be touched by scheduling. This algorithm is very basic and not sufficient for projects.
    In Germany you can find many companies who use both and transfer the data in between. But in this case a good concept is required.

    Hope this helps

    Dieter
    Report
  4. 0
    Vladimir Liberzon ·
    #4
    Dieter,
    I agree that PM software is not for accounting. Usually we suggest our customers regularly compare the results of PM software cost monotoring with the reports of accounting system.
    But I don’t understand what best parameter do you mean, please clarify.
    Regards,
    Vladimir
    Report
  5. 0
    Dieter Wambach ·
    #5
    Vladimir

    SAP has basic functions for a netplan - activities and relationships - and a schelduling algorithm. The GUI (Graphical User Interface) is designed for (financial) controllers.
    This parameter setting does mean that the SAP algorithm to calculate the plan regards the dates of an activity with these settings as fixed - calculated externally. For my opinion SAP PS and PM are designed for cooperation with a pm software.

    Regards
    Dieter
    Report
  6. 0
    Vladimir Liberzon ·
    #6
    I have the same opinion. SAP scheduling is poor.
    But usually it is necessary not to import/export cost data but to compare.
    Sometimes the difference is intended.
    And in any case we suggest to manage parallel costs of the same activities - internal costs, contract costs, approved costs. And each of these costs consists of components (labour costs, material costs, overhead costs, etc.).
    Regards,
    Vladimir
    Report
  7. 0
    Dieter Wambach ·
    #7
    Vladimir

    I agree

    There isn’t always a need to create automatted interfaces. Sometimes manual transfer of to compare two reports will be absolutely sufficient.

    Regards
    Dieter
    Report

Log in or join to reply

ProjectControls.com is free to join. Members can post questions, reply, vote and follow discussions.

Log inJoin free

Existing members: your original username and password still work. Forgot password?