web
You’re offline. This is a read only version of the page.
close
Skip to main content
Community site session details

Community site session details

Session Id :
Small and medium business | Business Central, N...
Answered

New CUE with Multi Filters to diferent tables

(0) ShareShare
ReportReport
Posted on by 95
Hello everyone,
I'm creating a CUE to get the sales shiptmen lines pending invoicing, but I would like it to show the information filtered by ID assigned to the sales order of the logged in user.
the filter i am using is  CalcFormula = count ("Sales Shipment Line" where("Type" = Filter(Item | Resource | "G/L Account"), "Qty. Shipped Not Invoiced" = Filter(<> 0)));
but i dont now how i add the filter to the Sales Header ID user. in Sales Shipment Line i have the Nº order to relation both tables, but i dont know how i can do it.
I am noob in AL programing.
Regards,
I have the same question (0)
  • Verified answer
    Terrance Morgan Profile Picture
    515 on at
    RE: New CUE with Multi Filters to diferent tables

    Select Data > Edit Relationships.

    In the Edit Relationships dialog box, do the following:

    Select a data source for Primary data source, and select a data source for Secondary data source.

    Select Custom.

    To define a relationship between fields that have different names, click Add.

    To edit an existing relationship, select the fields on the right, and then click Edit.

    In the Add/Edit Field Mapping dialog box, do the following, and then click OK:

    Under Primary data source field, select a field.

    Under Secondary data source field, select a field with similar data to the field you selected for the primary data source.

    For more information about editing relationships, see Blend Your Data.

    --
    Terrance | Apps4Rent

  • Verified answer
    Business Central Profile Picture
    95 on at
    RE: New CUE with Multi Filters to diferent tables

    Hello,

    I have been able to solve it with a query as indicated.

    Thank you

  • Suggested answer
    Thomas Brownell Profile Picture
    on at
    RE: New CUE with Multi Filters to diferent tables

    Hello,

    It sounds like what you need to use is an Query object.  With a Query object, you will be able to join the two or more tables.  Then on the CUE table you will need to create a new normal field that gets populated through AL code.  In the AL code you will need to at least initialize the value in the page OnOpenPage trigger.  I have included some links to our documentation that should help:

    • Query Object: docs.microsoft.com/.../devenv-query-object

    • Creating CUEs: docs.microsoft.com/.../devenv-cues-action-tiles

    • Page Triggers: docs.microsoft.com/.../devenv-page-and-action-triggers

    Best Regards,

    Thomas Brownell

    Sr Support Engineer

    Dynamics NAV/Business Central

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Mansi Soni – Community Spotlight

We are honored to recognize Mansi Soni as our August 2025 Community…

Congratulations to the July Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Small and medium business | Business Central, NAV, RMS

#1
Sohail Ahmed Profile Picture

Sohail Ahmed 2,869 Super User 2025 Season 2

#2
Sumit Singh Profile Picture

Sumit Singh 2,484

#3
Jeffrey Bulanadi Profile Picture

Jeffrey Bulanadi 2,242

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans