Skip to main content

Notifications

Announcements

No record found.

Small and medium business | Business Central, N...
Answered

How to set Report Selections for Job Quote (report 1016)

(0) ShareShare
ReportReport
Posted on by 189

Hi 

I know that this is a question already asked and answered in 2017, but the answer is not good, so I try again to see if the system was improved within the last 5 years.

It seems we have to make Job Quote report selection for each individual customer, and this is quite cumbersome when we have only one report layout valid for all customers.

Are there still no option to make a global selection valid for all customers like "Reports Selection - Sales"?

Best regards

Thomas Madsen Nielsen

  • Suggested answer
    MahGah Profile Picture
    MahGah 15,428 on at
    RE: How to set Report Selections for Job Quote (report 1016)

    I am glad it worked. Thanks for extra feedback. I added to my list for future.

  • TMNielsen Profile Picture
    TMNielsen 189 on at
    RE: How to set Report Selections for Job Quote (report 1016)

    yes, I was able to load a Report selection via table 77.

    In the excel record I just had to set the column "Use for Email Body" to value true and insert the Layout Code field from Custom Report Layout (see screenshot below) in the column "Email Body Layout Code". 

    pastedimage1639740149234v1.png

  • TMNielsen Profile Picture
    TMNielsen 189 on at
    RE: How to set Report Selections for Job Quote (report 1016)

    It actually works.

    Before I loaded this entry in table 77, I got an error message when I tried to sent a Job Quote email without making the Report Selection on the customer.

    Now I can send an email. I don't have an email body report, but I can manually enter text for the email body.

    So far so good. Next I will try to figure out if I can actually add a Report Selection for the Job quote email body.

    Best regards

    Thomas Madsen Nielsen

  • Suggested answer
    MahGah Profile Picture
    MahGah 15,428 on at
    RE: How to set Report Selections for Job Quote (report 1016)

    Hi

    Someone told me the following method before. But I never tried it. Feel free to try it in Sandbox first. 

    Use Configuration package and take table 77 out. Then add a new line like follow and upload back. Then test. 

    pastedimage1639665436102v1.png

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

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Tips for Writing Effective Verified Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,391 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,445 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans