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

Notifications

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics AX (Archived) / add project name colum...
Microsoft Dynamics AX (Archived)

add project name column (sortable/filterable) in timesheet line grid

(0) ShareShare
ReportReport
Posted on by Community Member

Hi,

I want to add Project Name column in the lines grid in TSTimesheetEntry form. You can access it from

Project Management and Accounting ->Common -> Timesheets -> My Timesheets -> select a record and open the form by double clicking it.

There is already ProjName column in it but it's a edit method which internally stores ProjId in the TSTimesheetLine table.

I tried to add ProjTable as datasource and make a join of it with TSTimesheetLine table and refer a projectname from projtable. i used outer join. but somehow while saving the record it wants to save the record in projtable. May be outerjoin is not the correct one.

This is what we do normally for List Page Grid. But this is entry form.

Can anyone please help me how do I make this proj name column sortable/filterable which is end goal?

*This post is locked for comments

I have the same question (0)
  • Verified answer
    Mea_ Profile Picture
    Mea_ 60,284 on at

    Hi VDY ,

    Look at any form where you have inventDim table as a datasource. You need to do the same, join projTable using inner or outer join and comment out super() in write method, so no changes would be saved to DB, also you need to make fields not editable and return true from validateWrite() instead of super() to skip validation of projTable fields.

  • Community Member Profile Picture
    Community Member on at

    Excellent ivegen. You saved my day.  Thanks very much.

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…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Congratulations to the November Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics AX (Archived)

#1
Priya_K Profile Picture

Priya_K 4

#1
Martin Dráb Profile Picture

Martin Dráb 4 Most Valuable Professional

#3
Ali Zaidi Profile Picture

Ali Zaidi 2

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans