Skip to main content

Notifications

Microsoft Dynamics GP (Archived)

Report Writer, body have 12 records by default

Posted on by Microsoft Employee

In Microsoft Great Plain report writer, body listing 12 records space by default. I want to suppress the records which are empty. Means if report pulled only 4 records, then report has to utilize 4 line space only. How I can achieve that? Please help me...

*This post is locked for comments

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    Re: Re: Re: Re: Re: Re: Re: Report Writer, body have 12 records by default

    and again!!!

    You can edit the remittance / check stub for unposted cheques...click on transactions >> Purchasing >> Edit Cheques...select yor vendor and click on Stub.

    Also see if you ticked the 'print previously applied documents' option.

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    Re: Re: Re: Re: Re: Re: Re: Report Writer, body have 12 records by default

    Hi again,

    It could also be that you ticked 'auto apply available credits' in the automatic cheque batch creation window...this would apply any unapplied credits during the cheque creation process...and these documents and their corresponding debit applied documents would appear on the remittance. Worth looking into anyway.

     

    Best regards,

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    Re: Re: Re: Re: Re: Re: Report Writer, body have 12 records by default

    Hi, just had a quick thought on this one...(i.e. I haven't tested or investigated it yet!!)...but I seem to remember that the first time you do a cheque run, it includes all previously applied documents...not just the ones that are applied to the current cheque. Now...this is going back to version 7.5, and it might have been changed...but I seem to remember that the solution was to do a complete run of zero cheques for the first run...this 'dummy' run includes all previously applied documents, so that when you run the first live cheque run, these are ignored, and you just get the actual applied invoices.

    (does anybody else remember this...or did I dream it up?)

    Or..there could be something wrong with your modified cheque report!!

    Best regards,

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    Re: Re: Re: Re: Re: Report Writer, body have 12 records by default

    Hi,

    we are just started the check printing with stub on top.  on  body of the report is displaying many applied document information rather than the relevent records.

    I need to print only the applied document.

    please help me.

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    Re: Re: Re: Re: Report Writer, body have 12 records by default

    Thanks Ian,

     This works as my requirement.

    Thanks again.....

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    Re: Re: Re: Report Writer, body have 12 records by default

    Hi,

    1. Open the check with stub on top report in report writer.
    2. Click on Tools >> Section Options to open the 'Report Section Options window'.
    3. Highligh 'Remittance Header' in the 'Additional Headers' box, and then click on 'Open'.
    4. Type '5' into the 'Records per body report' field (currently it is set to 12).

    This will force just 5 records to be printed in the remittance part of the report. The full remittance will be printed as part of the 'Seperate Remittance' if you choose that option when you print cheques.

     Let me know if this does not resolve your issue.

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    Re: Re: Report Writer, body have 12 records by default

    Thanks Ian, 

    This is CheckwithStubOnTop report. I want to print the check with payment voucher on top. but the body part is occupying 12 records space. In our case this will be maximum of 5 required. other space I need to utilise for different purpose.

    If I can make it the body default size to 5, that will solve my problem.

    I hope you can help me this case. 

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    Re: Report Writer, body have 12 records by default

    What is the name of the report...or is this a custom report developed in report writer?

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,253 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,188 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans