Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Dynamics 365 Community / Forums / Microsoft Dynamics NAV (Archived) / Sales Invoice Report c...
Microsoft Dynamics NAV (Archived)

Sales Invoice Report customization

(0) ShareShare
ReportReport
Posted on by Community Member Microsoft Employee

Hello,

I am modifying our Sales Invoice and have come across an issue.

The Header contains customer details that I don't want on any pages except the first page.  I am able to hide the customer details, but I can't reclaim the space those fields occupy.  I want to reclaim that space after the first page to allow more space for the detail lines on the subsequent pages.  As of right now the report shows only a few line items even though their is a lot of blank space above the body in the header.

Is it possible to collapse the header when the fields are hidden?  Or is there another solution to this problem?

Thanks,

Brendon

*This post is locked for comments

  • mmv Profile Picture
    mmv 11,465 on at
    RE: Sales Invoice Report customization

    Hi,

    This is how it's done in the Aged Accounts Receivable.

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Sales Invoice Report customization

     

    community.dynamics.com/.../177421

  • Verified answer
    Brendon-11 Profile Picture
    Brendon-11 on at
    RE: Sales Invoice Report customization

    I was able to resolve my issue, though it required moving the header fields into the body.  By using 2 rectangles with nested tables (tablix) in the body.  I entered customer details in the table nested in the top rectangle and copied the existing invoice detail tables into the second rectangle.

    This allowed me to have the customer details on the first page and then on the following pages the rectangle containing the customer data collapsed and gave me the full page (minus the remaining header i.e. logo and invoice number that are present on all pages and footer).

    Thanks for your replies.

  • Suggested answer
    Saurav.Dhyani Profile Picture
    Saurav.Dhyani 17,965 Super User 2024 Season 2 on at
    RE: Sales Invoice Report customization

    Hi,

    Its not possible in Page Header and Footer.

    The Height of Page Header and Footer Remain Fixed in the Report Preview / Print as in the Report Designer.

    You can only set visible to True or False but that will not impact the Height of the Report Header and Footer.

    Let me know if you require any clarification.

  • mmv Profile Picture
    mmv 11,465 on at
    RE: Sales Invoice Report customization

    Hi,

    You may have to change the design.  Please look at the Aged Accounts Receivable Report.

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 Suggested Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

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

#2
Martin Dráb Profile Picture

Martin Dráb 230,214 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans