Confirm

Expand all | Collapse all

Estimated value field

  • 1.  Estimated value field

    Posted 06-23-2019 07:12
    I am writing a report and I'm trying to find the estimated value (total cost) in the jobs screen of maintenance management. I've looked at the relevant schemas I can think of with no luck.  Can someone please advice where is this field.

    ------------------------------
    Afzal
    Knowledge Community Shared Account
    ------------------------------


  • 2.  RE: Estimated value field

    Pitney Bowes
    Posted 06-23-2019 22:13
    Hi Afzal,

    In Confirm® the Estimated Value of a Job will derive from the Target Rate entered in the Schedule of Rates (SOR) Item library (if one is entered) or if Preferred Contract is entered, from the Contract Rates (however a Job need not be raised under any particular Contract).

    If no Target Rates are present and no Preferred Contract is entered, the Estimated Value will be blank.

    Estimated Value is not stored in a singular Confirm database field. It has to be calculated in a report as it would be in the application itself.

    Thanks,
    Saurabh Mathur

    ------------------------------
    Saurabh Mathur
    Pitney Bowes Australia Pty Ltd
    Melbourne
    ------------------------------



  • 3.  RE: Estimated value field

    Posted 06-24-2019 07:54
    Hello Saurabh, I am trying to write a report where it shows a job with total cost for for example Job 1, £5000, job 2 £500 and i dont want individual SOR's or their rates, just the total cost (estimated value).  I have exported a built in report and re-imported and i run it i get the error (see attached).  I also tried to work around it but keeps giving me duplicated entries.  Can you please advise on where i am going wrong.

    ------------------------------
    Afzal Hussain
    Knowledge Community Shared Account
    ------------------------------

    Attachment(s)



  • 4.  RE: Estimated value field

    Posted 06-28-2019 10:03
    Hi Afzal,
    If you remove the fields from the tables job_item, sor_item & contract_boq from the SELECT & GROUP BY, this will remove the duplicate lines, and remove the details at SOR level and retain it at job level.
    Regards
    Haf

    ------------------------------
    Hafezur Rahman
    Confirm Systems Administrator
    London Borough Of Richmond Upon Thames
    Twickenham
    ------------------------------



  • 5.  RE: Estimated value field

    Posted 06-24-2019 06:32
    Hi Afzal,

    Depending on what the state of the job and what value you are looking for, the following is a list of the tables you need to look at to calculate the values.

    Job Item
    Order Item
    Claim Item
    Variation Item
    Payment Item

    If you were looking for just a job estimate, where the job is not on an order, you will need the Job Item table.

    If the job was on an order and uncommitted, you can use Order Item or Job Item.

    Hope this helps.

    Haf

    ------------------------------
    Hafezur Rahman
    Application Specialist
    Richmond and Wandsworth Councils
    ------------------------------



  • 6.  RE: Estimated value field

    Moderator
    Posted 08-05-2019 01:32
    Hi Afzal,

    Greetings!
    I hope you got the resolution of your query.
    Please mark the best answer by selecting "Make Best Answer" in the Reply menu.
    It will help us and other users save their time.

    For more information click here.

    Regards

    ------------------------------
    Aakash Singh
    Pitney Bowes Software India Pvt. Lt
    NOIDA
    ------------------------------