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

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics AX (Archived) / Show journals by user ...
Microsoft Dynamics AX (Archived)

Show journals by user Assigned on list page

(0) ShareShare
ReportReport
Posted on by Community Member

Hello Everyone !
I have created a list page and showing some data related to invent journals on it. 
Data is being displayed properly. but i want to filter that data on the list page based on assigned user. 
If a journal is assigned to current user then it should be displayed otherwise not.
How can I accomplish that ?
I guess using a range in the query that i am using for data population on the list page. but I dont know which table contains the information of assigned user and journal connection.

thanks

*This post is locked for comments

I have the same question (0)
  • Verified answer
    Eng. Hussien Ahmed Profile Picture
    Eng. Hussien Ahmed 75 on at
    RE: Show journals by user Assigned on list page

    Hi Muhamed

    You can manage the Inventory Journal access on  the private groups in the declaration of the Inventory journal master data . You can specify the user group will access and see theis Journal , and it will automaticaly filter it in your list .

  • Verified answer
    Mahesh Raj Profile Picture
    Mahesh Raj 89 on at
    RE: Show journals by user Assigned on list page

    I am assuming that you have already developed the workflow for inventory journal.

    Below is the relation between two tables. If journal is assigned to mutiple users then there

    will be multiple records in this table. (One record per user)

    WorkflowWorkItemTable.refrecid           == InventJournalTable.RecId

    WorkflowWorkItemTable.refTableID       == InventJournalTable.TableId

    WorkflowWorkItemTable.CompanyId     == InventJournalTable.DataAreaId

  • Community Member Profile Picture
    Community Member on at
    RE: Show journals by user Assigned on list page

    Thank you Mahesh.
    Can you please tell me how the table WorkflowWorkItem is connected with InventJournalTable ?

  • Mahesh Raj Profile Picture
    Mahesh Raj 89 on at
    RE: Show journals by user Assigned on list page

    Hi Muhammad

    I dont think there is a standard assignment or workflow avilable on the inventory journals.

    If you need to assign it to the users then you need to first develop and create workflow on inevntory journal.

    If you have already developed workflow for inventory journals, then user assignments are stored in WorkflowWorkItem table.

  • Community Member Profile Picture
    Community Member on at
    RE: Show journals by user Assigned on list page

    Dear Crispin John Augustine,

    Thank you very much for you reply.

    Yes You are right. i need to know how to find the table and the connection.

    My root table in the query is InventJournalTable,  that is getting data. Now i don't know which table contains information about user assignment and its connection with InventJournalTable.

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

News and Announcements

Dynamics 365 Community Calls Return
Join experts in person to explore low code and AI agents at the Power Platform Community Conference sponsored by Microsoft
Responsible AI policies for the Community

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 > 🔒一 Microsoft Dynamics AX (Archived)

#1
Syed Haris Shah Profile Picture

Syed Haris Shah 9

#2
Mea_ Profile Picture

Mea_ 4

#3
KP-31070522-0 Profile Picture

KP-31070522-0 3

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans