job report

Business Central/NAV Developers Forum
1

Hi, is it possible to see the sum of working hours for some jobs? I mean: I’d like knowing how many hours my colleagues worked on all the jobs. I need this because we have many sub-jobs refering to a pricipal job, and i want to know total hours. Is there a report or a way to have this result? In reports as 1203 (job register) field menù shows me few fields. How can I have and see more? Thanks

2

hi, it’s Time Sheet table contain all this data. In any way in my configuration it is the table #14837. Hope this helps, BR, Anthony

3

Also table Employee Qualification can contain fields that can be related to his/her character of work.

4

Hi Alberto, You’ll find all the information you need in the table Job Ledger Entries. Just set the appropriate filters: Ex: Entry Type = Usage Type = Resource No. = MARY Job No. = MyJob OR Master Job No. = MyMaster Job (if you have a customized field). A developer can easily build a report to show this information by Master Job, by Job, by Resource

5

Hi David and Antony, what i need is to see TOTAL HOURS spent, by each resource, per Master Job. I was asking if there was a way to do it without a developer (i’m not) A developer can easily build a report to show this information by Master Job, by Job, by Resource I think you are right: it’s the only way. Thanks

6

If you don’t have a developer to assist you, there is a way to have the result for one Resource, for one Job, but you have to repeat this process anytime you need a result. You could:

  • open the Job Ledger Entries
  • filter on your Master Job (probably a new field in your solution)
  • filter on your Resource No.
  • copy the result to Excel
  • in Excel, sum the column Quantity
7

Thanks David. I’m already using this way. But I’d like to do all with Navision. I don’t have a developer who can assits me, and I was trying to do it alone. Regards