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!!
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.)
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.
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.
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.
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
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
André Arnaud de Cal... 290,524 Super User 2024 Season 2
Martin Dráb 228,493 Most Valuable Professional
nmaenpaa 101,148