Forum Discussion
Project for Web App Outline Numbers missing from data tables
It appears that the outline numbers are missing from the Project Task Table. Also was msdyn_wbsid is not avalible either. Is there a way to access these or recreate via some formula? Our project mana...
Has anyone found a solution to this problem or found what dynamics table the outline number is in. Its amazing of all things they leave out the outline numbers. I guess task order is a thing of the past ugh...
I created a work around using the displaysequence number but it requires a lot of manipulation using power query to get to the right view. Works well with the Gantt roadmap view keeps everything in order. You basically have to do the following:
- Round the display sequence in my case I did it down to 2 positions
- Add a custom text field call it Prefix. If the sequence is less than 10 then "0" else "" or space
- Change the sequence to a text field
- Add a custom text field call suffix use this command
- if List.Count(Text.PositionOf([sequence],".",Occurance.All)) = 0 then ".00" else ""
- You're basically creating a number field that will have a leading zero for anything less than 10 and a trailing .00 for any whole number.
- You then Merge Prefix, sequence and Suffix together and then merge the result to the Index Name or Task Name giving the result below.
- Hopefully Microsoft will resolve this and just add the outline number ugh...ugh.