Dynamics F/SCM Customer Experience (CRM) Dynamics GP Dynamics Business Central (NAV) Dynamics SL Power Platform Fabric Copilot

[Andrea Hall]

We upgraded to NAV2016 a month ago from NAV2009 R2 Classic. LOVE IT!!! We are using the out of the box Sales Invoice and have found when selecting a group of posted sales invoices and printing to PDF, some of the invoices are being merged or co mingled.
Scenario: customer A’s invoice is 3 pages and customer B’s invoice is 2 pages.  In the PDF you will see customer A page 1, page 2 display correctly, but on page 3 the header information is customer B’s and it has the totals for customer B, but has the shipping lines for customer A.  Then the next couple of invoices for various customers are correct?  
Also, the lines on each order are for the entire order, not just the lines that have posted on that specific invoice. However, when you send each invoice separately to PDF, then it is correct. 
Has anyone seen this and better yet resolved this??? Thanks.

——————————
Andrea Hall
Information Technology Director
Stonewall Kitchen
York ME
——————————

[Lewis Rosenberg]

Do you see the same behavior when you print to a printer or preview?

——————————
Lewis Rosenberg
IT Manager
Mars Fishcare
Chalfont PA

NAVUG Board of Advisors, Programming
NAVUG Programming Commitee
NAVUG Membership Committee
——————————
——————————————-

[Andrea Hall]

When we print to paper it looks fine.  And when we “preview” it correctly shows one invoice at a time with no page breaks, so they look good too. It’s an issue specific to PDF.

——————————
Andrea Hall
Information Technology Director
Stonewall Kitchen
York ME
——————————
——————————————-

[Adriana Di Vito]

Congrats on the NAV 2016 upgrade to you and your team, Andrea! Super well done! 

——————————
Adriana Di Vito
Marketing Director – Relationship Management
Sologlobe
Montreal QC
——————————
——————————————-

[Ramin Marghi]

Hi Andrea,

Congrats on the successful upgrade! A few questions to get the ball rolling:

1. What build of 2016 are you running (you can find this by going to the Application Menu, Help, About Microsoft Dynamics NAV)? Didn’t see a hotfix for this issue, but sometimes the earlier or RTM builds have weird quirks like this.

2. What report number is this? You can find this after you click print, in the Report Request Page that pops up, go to the Application Menu, Help, About This Page and it’ll be the number in parentheses after the report name in the Page field).

3. Do you have access to the Development Environment?

——————————
Ramin Marghi , CPA, CGA
NAV Finance Consultant
Catapult
VANCOUVER BC
——————————
——————————————-

[Andrea Hall]

Thanks Ramin.

1. Our code base is CU5 and our executables are CU14.

2. This is report 10074

3. Sure do. Have an in-house developer.

We also tried running this report in the Cronus database. It gave us different results that still were not perfect.
We are also trying to dig into the scenario or data because it’s repeatable with different sets of invoices but not all sets of invoices.

If this sparks an idea let us know.

——————————
Andrea Hall
Information Technology Director
Stonewall Kitchen
York ME
——————————
——————————————-

[Dave Cintron]

Programming reports in Visual Studio has a number of caveats, the most challenging of which is the understanding of grouping as it relates to the scope of variables. Even Microsoft programmers seem to have difficulty with this where their programming of RTC reports suffers from inconsistent methodology where headers and footers are involved. Changing any of this can throw off the formatting of the reports that deal with numbered documents like invoices. Has your invoice been modified in any way?

——————————
Dave Cintron
Dynamics West
Ventura CA
——————————
——————————————-

[Jeane Meade]

We had the same pagination issue on that same document when we moved from NAV 2009 to NAV 2015!  I’m not in the office right now, but will check the notes as to the fix.  I believe it had something to do with a row height or width in the body (lines) section.  While it looks fine in PDF view, when doing multi-order print to paper, the pagination on a multipage document was off.

——————————
Jeane Meade
IT/DBM
Sheldons’, Inc.
Antigo WI
——————————
——————————————-

[Andrea Hall]

Jeane Meade,

Thank you. We’ll be curious to see the detailed notes from the fix in your case.

Andrea

——————————
Andrea Hall
Information Technology Director
Stonewall Kitchen
York ME
——————————
——————————————-

[Iaroslav Pankovskyi]

Hi Andrea,
I feel sorry you are experiencing this issue. Luckily, we have run into exactly the same issue a couple of months ago. Here is how it can be solved:

– Navigate to “Printer Selections” page.

– Click on the “Edit List” button in the ribbon.

– Select the user who uses the print multiple invoices function, select the report ID (probably, “10074” in your case).

– Select the printer to which you want to print multiple Sales Invoices.

Close the page and start using the function. I hope this helps!

——————————
Iaroslav
——————————
——————————————-

[Claus Lundstrøm]

Hi Andrea,

If still an issue, I would like to do a Team Viewer and see the issue. Please ping me at clausl@continia.com

/Claus

——————————
Claus Lundstrom, Microsoft MVP
Senior Product Manager, Continia Software

——————————
——————————————-

[Andrea Hall]

Iaroslav,

Thank you for this. Unfortunately this didn’t fix our issue as the issue is when we print to PDF not an actual printer.

Take care,
Andrea

——————————
Andrea Hall
Information Technology Director
Stonewall Kitchen
York ME
——————————
——————————————-

[Iaroslav Pankovskyi]

Andrea,
Are you using a virtual PDF printer like Pr-mo PDF (there are lots of free software like this available)? If so, you can still select it as a printer on the Printer Selection page. That’s what I would do first thing. Second thing would be trying Ramin’s suggestion. Finally, if none of this works, you may need to contact your Microsoft Partner and/or submit the case to Mi-soft.

——————————
Iaroslav
——————————
——————————————-

[Ramin Marghi]

Hey Andrea,

Attached is a text output of the latest 2016 build of Report 10074. Ask your dev hop onto the Dev. Env., backup your existing Sales Report object, import this one (Note: this will replace your report object, which is why you should back up your existing one first!), and compile it (i.e. press F11).

Then take it for a spin and see how it works.

Thanks!

——————————
Ramin Marghi , CPA, CGA
NAV Finance Consultant
Catapult
VANCOUVER BC
——————————
——————————————-