Skip to main content
Solved

Work Order Cost

  • Jul 19, 2021 1:06 AM UTC
  • 3 replies
  • 302 views
Do Gooder (Customer)
Forum|alt.badge.img+2

hi there, does anyone know how I can get planned cost and actual costs at work or level instead of activity level? thanks

Best answer by AsankaGaru

Hi,

Budget tab will help you.

 

View original
    This topic has been closed for replies.

    3 replies

    Hero (Partner)
    Forum|alt.badge.img+12
    • AsankaGaru
    • Hero (Partner)
    • Answer
    • Jul 19, 2021 10:21 AM UTC

    Hi,

    Budget tab will help you.

     

    Asanka Garusinghe - https://www.linkedin.com/in/asanka-garusinghe-61634a64/
      Do Gooder (Customer)
      Forum|alt.badge.img+2
      • reneek
      • Author
      • Do Gooder (Customer)
      • Jul 19, 2021 8:08 PM UTC

      Thank you for that :)

      I am wanting to export the data into a crystal report.  

      In IFS it would usually give me the table name in the system info tab but there is nothing there. do you know if there is a table containing this data that i can extract it from?

       

      Many thanks in advance. 

      Renee 

        Hero (Partner)
        Forum|alt.badge.img+12
        • AsankaGaru
        • Hero (Partner)
        • Jul 19, 2021 8:42 PM UTC

        Hi,

        Its fetched using a get method it seems.

        Jt_Task_Cost_Line_Util_API.Get_Sum_Actual_Cost(WO_NO, WORK_ORDER_COST_TYPE_DB)

         

        WORK_ORDER_COST_TYPE_DB would be … material cost ‘M’, Personal ‘P’, External ‘E’, Expense ‘X’, Fixed Price ‘F’, Tool and equip ‘T’ 

         

        Asanka Garusinghe - https://www.linkedin.com/in/asanka-garusinghe-61634a64/
          Terms & ConditionsAccessibility statement