Skip to main content

Notifications

Small and medium business | Business Central, N...
Suggested answer

Service Quote report: How to show Total Hours for resources?

(2) ShareShare
ReportReport
Posted on by 67
Our customer DOES NOT want their customers to see which resource worked during a job.
 
 
 
Instead, he wants to show an accumulated total of /Labor Hours/ 
 
My thoughts were to...
1) Hide rows from the Service Lines of type /Resource/ - this is working, see above
2) Sum rows of type /Resource/ as a subtotal above /Total/ box - unsure how to go about this
 
  • Suggested answer
    YUN ZHU Profile Picture
    YUN ZHU 77,245 Super User 2025 Season 1 on at
    Service Quote report: How to show Total Hours for resources?
    Hi, if you don't want to customize it, you can try the function in Report Builder. Personally, I think it is much more complicated than AL and cannot be debugged.
    Report Builder functions - Sum function in a paginated report (Report Builder)
     
     
    Hope this helps.
    Thanks.
    ZHU
  • Suggested answer
    Valentin Castravet Profile Picture
    Valentin Castravet 25,794 Super User 2025 Season 1 on at
    Service Quote report: How to show Total Hours for resources?
    Is there a way to do this without development?
     
    I don't believe so. You could do the following, while it doesn't require as much development, it still requires adding 1 simple filter to the report layout. You could change your process of entering time on the service order lines. Instead of invoicing each individual resource line, you would consume it i.e. instead of having a value in the quantity to invoice field, you would have a value in the quantity to consume field. Then you would have 1 generic resource line added that would be invoiced. Then on your report add a filter to not show any lines where the quantity to invoice is zero. This way the report only shows the generic resource line.   
  • ERPlatanos Profile Picture
    ERPlatanos 67 on at
    Service Quote report: How to show Total Hours for resources?
    @Mohamed
     
    Thanks for your response. Is there a specific reason to use word layouts? I've already started this with an RDLC layout. I'm familiar with basic report customizations for both.
     
    I'm looking for help on how to directly accomplish the task I mentioned in the post. How do I create a field to total quantity and price of a certain Line Type (Resource, in this case)?
     
    Instead of a service quote showing...
    "Daniel" 2 hrs @ $100/hr; Total $200
    "Mike" 2 hrs @ $50/hr; Total $100
     
    I want it to show...
    Labor 4 hrs; Total $300
  • Suggested answer
    Mohamed Amine Mahmoudi Profile Picture
    Mohamed Amine Mahmoudi 14,149 Super User 2025 Season 1 on at
    Service Quote report: How to show Total Hours for resources?
    Hi @ERPlatanos,
     
    you can design the report with word template and than you must import them to BC
    I hope this can helps
     
    Best regards,
    Mohamed Amine MAHMOUDI
  • ERPlatanos Profile Picture
    ERPlatanos 67 on at
    Service Quote report: How to show Total Hours for resources?
    Is there a way to do this without development?
  • Suggested answer
    Mohamed Amine Mahmoudi Profile Picture
    Mohamed Amine Mahmoudi 14,149 Super User 2025 Season 1 on at
    Service Quote report: How to show Total Hours for resources?
    Hi,
     
    this is possible with customization and developing
     
    Best regards,
    Mohamed Amine MAHMOUDI
  • Suggested answer
    Valentin Castravet Profile Picture
    Valentin Castravet 25,794 Super User 2025 Season 1 on at
    Service Quote report: How to show Total Hours for resources?
    I would get a developer to customize the rdlc report. The report would simply sum all line items with the type resource. This way you don't need to change the current process of how service orders are created.
     
    Valentin Castravet
    Zander ERP Services
  • Suggested answer
    YUN ZHU Profile Picture
    YUN ZHU 77,245 Super User 2025 Season 1 on at
    Service Quote report: How to show Total Hours for resources?
    Hi, for the second point, I think this needs customization, you need to add a new total field.
    Hopefully the information below can give you some tips.
     
     
    Thanks.
    ZHU

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

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Vahid Ghafarpour – Community Spotlight

We are excited to recognize Vahid Ghafarpour as our February 2025 Community…

Congratulations to the January Top 10 leaders!

Check out the January community rock stars...

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 292,160 Super User 2025 Season 1

#2
Martin Dráb Profile Picture

Martin Dráb 230,962 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans