Skip to main content

Notifications

Microsoft Dynamics GP forum
Suggested answer

Report Writer Invoice Header Notes Notes printing incorrectly on Mult-Invoice Print

Posted on by 670

Customer requested that the Header notes for their invoice get printed on the invoice:  This was a simple enough request and the process went smoothly.

The test prints pleased the customer.

The customer just found in production that the header notes aren't printing correctly when more than one invoice is printed, the notes from the first invoice are printing on the next.

This is similar to the issue discussed here:  https://www.gpug.com/communities/community-home/digestviewer/viewthread?MessageKey=a246c68b-218d-49a6-b4c4-66056eae919e&CommunityKey=4754a624-39c5-4458-8105-02b65a7e929e&tab=digestviewer#bma246c68b-218d-49a6-b4c4-66056eae919e

Does anyone have a solution or do I need to open a bug ticket with MS?

Thank you!!

  • Suggested answer
    Lisa at AonC.com Profile Picture
    Lisa at AonC.com 3,023 on at
    RE: Report Writer Invoice Header Notes Notes printing incorrectly on Mult-Invoice Print

    Check what you have for your Display Type.  It sounds to me like it is set to the wrong type.  It depends on what Band you have the field dropped into.  If it is in a footer it like needs to be set to Last Occurrence (since the data cursor would already be on to the next customer statement).  

    pastedimage1648522402488v1.png
    The setting doesn't always feel logical, so tinker with it.  

    When I am testing fields like this, I set the conditional field to something obvious when I am testing (for example, Customer Number) so I can look for the pattern.  (I usually find it is displaying the previous or next record's data and that helps me determine the best Display Type.)

  • Hokuminaria Profile Picture
    Hokuminaria 2,950 on at
    RE: Report Writer Invoice Header Notes Notes printing incorrectly on Mult-Invoice Print

    Hey Tim,

    Thank you for your response.

    When looking at your screenshots, i cant tell what is wrong. When i attempt to set this up like you have it, i do not have the SOP_HDR_Work table on my report to create this calculated field. This tells me you are either on a different version possibly, or you have further modifications to this report which required the addition of this table. I am unable to tell if any of the original table links have been removed or changed.

    You best bet is to create a case so we can get your report in house and take a look at it to see what is wrong. I do not believe this is a bug as your calculated field is based on a table that is not on the report by default.

    The default Table on my report would be the the Sales Transaction Work that i can pull the note field from. You could try creating the calculated field based off this and see how it looks when printing.

    It could also be the current table links on the report if you added/removed a table. The field data type could be set wrong.

    Please create a support case and we would be happy to look at this further.

    Thank you!

    Brandon Jarrett | Microsoft Support Engineer.

  • Tim Andaya Profile Picture
    Tim Andaya 670 on at
    RE: Report Writer Invoice Header Notes Notes printing incorrectly on Mult-Invoice Print

    Hi Brandon, 

    I guess I wasn't clear enough:  Report Writer has a function, RW_GetNoteText which will extract 1 line at a time from the Record Notes Master (SY03900) using the SOP_HDR_WORK table note index.

    pastedimage1648494191940v1.png

    The process was relatively simple and it looks beautiful when you print 1 invoice.

    pastedimage1648494351357v2.pngpastedimage1648494810361v3.png 

    The problem occurs when you print a batch of invoices; in this scenario, it would seem that that the report is only pulling the notes once and reusing them on each invoice in the run; in this example, it printed 5, 6, 7, and 4 (3 from the previous test print and the last from the actual invoice) instead of 1, 2, 3, and 4, then printed only line the fourth record, 8, instead of printing 5, 6, 7, and 8.  The only invoice printed correctly was the 3rd in the run that had no notes, which were, mercifully, blank.

    pastedimage1648495078589v4.pngpastedimage1648495263980v5.png

    So, I am beyond the creation process but, I may have configured it wrong and need to add a table, it isn't clear.

    If I can't get a good solution soon, I'm going to need to open a bug ticket.

  • Hokuminaria Profile Picture
    Hokuminaria 2,950 on at
    RE: Report Writer Invoice Header Notes Notes printing incorrectly on Mult-Invoice Print

    Hello Tim,

    It is hard to tell without knowing what report is having the issue and how your calculated field was setup to pull this field. Below are a few articles i found on how to do this.

    How to add a record-level note to the "PM Paid Transaction History Detail" report in Microsoft Dynamics GP

    KB 858264 - How to add purchase order notes to the POP Purchase Order Blank Form in Report Writer in Microsoft Dynamics GP

    Notes Displayed on the PO Receipts Header Field - Microsoft Dynamics GP Forum Community Forum

    Add the notes to the SOP Blank Packing Slip - Dynamics GP | Microsoft Docs

    Note Text for item record in RW - Microsoft Dynamics GP Forum Community Forum

    I hope this helps!

    Thank you!

    Brandon Jarrett | Microsoft Support Engineer

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

Anton Venter – Community Spotlight

Kudos to our October Community Star of the month!

Announcing Our 2024 Season 2 Super Users!

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

Dynamics 365 Community Newsletter - September 2024

Check out the latest community news

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 290,524 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 228,493 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,148

Leaderboard

Product updates

Dynamics 365 release plans