Finance | Project Operations, Human Resources, ...

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

(0) Share

Report

Posted on by Tim Andaya

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.

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

Thank you!!

Categories:

Microsoft Dynamics GP

All responses (4)

Answers (0)

Suggested answer

Lisa at AonC.com 3,141 on at

Like (0)

Report

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).

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 2,950 on at

Like (0)

Report

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 670 on at

Like (0)

Report

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.

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

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.

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 2,950 on at

Like (0)

Report

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