Skip to main content
Question

Where to find invoiced qty on po line

  • September 10, 2026
  • 1 reply
  • 13 views
Hero (Customer)
Forum|alt.badge.img+11

The Purchase Order Line projection has an Invoiced Qty.  That is not a column in the underlying table Purchase_Order_Line_All.  In 10, I was able to view the system information that showed the call being made to get that information.  How can I find out where Cloud is getting that information for the projection?

    1 reply

    Hero (Employee)
    Forum|alt.badge.img+9
    • Jane Perry
    • Hero (Employee)
    • September 10, 2026

    Hi.  I searched your question and found the following information - 

    In IFS Cloud, the concept of "System Information" from IFS Applications 10 has been replaced by Aurena/Cloud tools like Page Inspector, API Explorer, and Browser Developer Tools.

    Here is how to find where Cloud gets the Invoiced Qty information, followed by the exact backend derivation logic for Purchase Order Lines.

    1. How to Find Attribute Derivations in IFS Cloud

    Method A: Page Inspector (The direct replacement for System Info)

    1. Navigate to the page containing the Purchase Order Line.

    2. Click your User Profile avatar / initials in the top-right corner.

    3. Select Page Inspector (or use keyboard shortcut Ctrl + Shift + Shift).

    4. Select the table/form field or line section for Purchase Order Lines.

    5. In the Page Inspector panel:

      • Page Tab: Shows the Marble page definition and binding field name.

      • Attributes / Entity Tab: Displays the Projection Entity, the Attribute Name (InvoicedQty), whether it is Read Only, and if it maps directly to an Entity Attribute or a Fetch / Custom Expression / Function.

    Method B: API Explorer (Solution Manager)

    1. Go to Solution Manager > Integrations > API Explorer.

    2. Search for the projection name (e.g., PurchaseOrderHandling or PurchaseOrderLinesHandling).

    3. Click on the projection to open its API details.

    4. Search for the entity PurchaseOrderLine and look at the attribute definitions. You will see attribute properties such as entity mapping, data type, and function backing.

    Method C: Browser Developer Tools (F12)

    1. Press F12 to open your browser’s Developer Tools and switch to the Network tab.

    2. Filter by Fetch/XHR or search for .svc.

    3. Perform an action or refresh on the PO line page.

    4. Look at the OData request sent to the backend (e.g., GET .../PurchaseOrderHandling.svc/PurchaseOrderSet(OrderNo='...')/LineArray...). The metadata response ($metadata) reveals projection entities and derived properties.

    2. Where Invoiced Qty Originates in the Backend

    In the database, Invoiced Qty is not a stored database column on PURCHASE_ORDER_LINE_TAB. Instead, it is a transient/derived attribute on the PurchaseOrderLine entity.

    PL/SQL Function

    The projection computes Invoiced Qty by calling the backend PL/SQL method:

     

     

     

    Purchase_Order_Line_API.Get_Invoiced_Qty(order_no, line_no, release_no)

    Underlying Database Tables & Joins

    The Get_Invoiced_Qty function calculates the total by aggregating matched supplier invoice lines from PUR_ORDER_INVOICE_MATCH_TAB (Purchase Order Invoice Match):

     

     

     

    SELECT SUM(quantity_invoiced) FROM pur_order_invoice_match_tab WHERE order_no = :order_no AND line_no = :line_no AND release_no = :release_no;

    If you are building custom SQL reports, BI views, or Quick Reports and need the exact invoiced quantity for a PO line, you can either:

    1. Call the wrapper API function: Purchase_Order_Line_API.Get_Invoiced_Qty(order_no, line_no, release_no)

    2. Query PUR_ORDER_INVOICE_MATCH_TAB directly grouped by order_no, line_no, release_no.

     

    I hope this information helps!  Jane

    Terms & ConditionsAccessibility statement