Skip to main content
Solved

Last Operation in a Shop Order

  • July 7, 2025
  • 5 replies
  • 57 views
M
Do Gooder (Customer)
Forum|alt.badge.img+3
  • marslan
  • Do Gooder (Customer)
  • 9 replies

I am trying to find a Dormant time between the current executable operation VS last operation in a shop order. 

One option is I can go to Finish Date and identify but for our business need this might not be enough

 

I am looking for when the operation in sequence was actually touched. Example I have operation 10, 20, and 30. 30 is executable, so I want to know when really the 20 was last touched? - It could be operation itself, material receiving, or last material receive date.

 

My question is, where can I find all those dates in IFS cloud?

 

Best answer by Abdul

​@marslan, Shop Order No is a key field for Shop_Ord_tab, and it wouldn't be duplicated even if you are creating shop orders for different sites.

Anyways, you can use shop_ord_Api.get_contract(order_no,release_no,sequence_no) function in your quick report to get the shop order site.

    5 replies

    Abdul
    Superhero (Partner)
    Forum|alt.badge.img+20
    • Abdul
    • Superhero (Partner)
    • 538 replies
    • July 7, 2025

    Hi ​@marslan,

    Please refer to the Shop Order History screen to get all Shop Order/Operation/Material-related information.

    Please refer to the screenshot below.

     

    Regards

    Abdul Rehman

    https://www.linkedin.com/in/abdul-rehman-ifscloudexpert/
    M
    Do Gooder (Customer)
    Forum|alt.badge.img+3
    • marslan
    • Author
    • Do Gooder (Customer)
    • 9 replies
    • July 7, 2025

    So when there are multiple operations and few them have completed (or any other activity) - it captures all?

    Abdul
    Superhero (Partner)
    Forum|alt.badge.img+20
    • Abdul
    • Superhero (Partner)
    • 538 replies
    • July 7, 2025

    ​@marslan, Yes, you are correct. This screen captures all information.

    https://www.linkedin.com/in/abdul-rehman-ifscloudexpert/
    M
    Do Gooder (Customer)
    Forum|alt.badge.img+3
    • marslan
    • Author
    • Do Gooder (Customer)
    • 9 replies
    • July 8, 2025

    Yes but when I went to the DB for SHOP_ORDER_HISTORY it doesn’t show the SITE (CONTRACT): basically warehouse. an in future it could be the possibility of having same shop order number with different sites, do you know how to connect them to bring in the SITE in the data base?

    I am using Quick Reports (for your reference).

    Abdul
    Superhero (Partner)
    Forum|alt.badge.img+20
    • Abdul
    • Superhero (Partner)
    • 538 replies
    • Answer
    • July 8, 2025

    ​@marslan, Shop Order No is a key field for Shop_Ord_tab, and it wouldn't be duplicated even if you are creating shop orders for different sites.

    Anyways, you can use shop_ord_Api.get_contract(order_no,release_no,sequence_no) function in your quick report to get the shop order site.

    https://www.linkedin.com/in/abdul-rehman-ifscloudexpert/


    Terms & ConditionsCookie settingsAccessibility statement