Print invoice - incorrect values on second page
ACaignie
Member Posts: 91
Hello,
I have a problem in NAV2017 (BE - CU11) with printing a batch of invoices/CN (customized reports, not 206 or 207).
The problem is that the header information of the second invoice/CN is printed on the last page of the first report. Printing 1 invoice is always correct.
Some report information:
- The header information is printed on the 'page header' using getdata and setdata functions
- The lines are grouped on invoice number + copy. There is a page break after each instance of the group, and at the end.
- In the group header the setdata functions are called in textboxes using the 'visibility' property.
- There is a group footer with a textbox containing a VAT text and/or payment conditions
- The invoice totals are printed on the last page of the invoice in the 'page footer' section using getdata functions. This is done to print the total on the bottom of the page and not just after the detail lines.
If invoice lines are printed on the last page this works fine. However if only the group footer is printed on the last page of the invoice, then this page contains the data of the next invoice (header and footer information). And from then on it goes wrong for every invoice printed later: the header information is the info from the next invoice, but the detail information is correct.
Does anyone know how I could solve this? CU21 has the same problem, so an update is not the solution.
I already tried to print the VAT text as detail line in the tablix, but this doesn't solve it. Neither does creating a new tablix for the 'setdata' functions.
Thx in advance,
Andy
I have a problem in NAV2017 (BE - CU11) with printing a batch of invoices/CN (customized reports, not 206 or 207).
The problem is that the header information of the second invoice/CN is printed on the last page of the first report. Printing 1 invoice is always correct.
Some report information:
- The header information is printed on the 'page header' using getdata and setdata functions
- The lines are grouped on invoice number + copy. There is a page break after each instance of the group, and at the end.
- In the group header the setdata functions are called in textboxes using the 'visibility' property.
- There is a group footer with a textbox containing a VAT text and/or payment conditions
- The invoice totals are printed on the last page of the invoice in the 'page footer' section using getdata functions. This is done to print the total on the bottom of the page and not just after the detail lines.
If invoice lines are printed on the last page this works fine. However if only the group footer is printed on the last page of the invoice, then this page contains the data of the next invoice (header and footer information). And from then on it goes wrong for every invoice printed later: the header information is the info from the next invoice, but the detail information is correct.
Does anyone know how I could solve this? CU21 has the same problem, so an update is not the solution.
I already tried to print the VAT text as detail line in the tablix, but this doesn't solve it. Neither does creating a new tablix for the 'setdata' functions.
Thx in advance,
Andy
0
Best Answer
-
What if you use standard report instead of customise report? It may not be related with Cu if standard is working fine but customise is not.Make Simple & Easy5
Answers
-
What if you use standard report instead of customise report? It may not be related with Cu if standard is working fine but customise is not.Make Simple & Easy5
-
Hi Yukon,
The standard report works, I will try to figure out why :-). I have seen that in report 206 the setdata functions are called in a separate tablix, maybe that is the answer?
The problem I have is that it is still a big mystery to me when these setdata functions are called, and when the header and footer values are fetched. I don't have any clue why the setdata function in the group header is called before this header is printed.
Maybe someone has a clear explanation ?
Andy0 -
Looking at the standard report I figured it out: like in NAV 2009 I only had one tablix, whereas in std NAV there is a 'master' tablix containing a list, and this list contains the detail tablix.
Still don't have a clue why it is done like this, but if it works...0
Categories
- All Categories
- 73 General
- 73 Announcements
- 66.7K Microsoft Dynamics NAV
- 18.8K NAV Three Tier
- 38.4K NAV/Navision Classic Client
- 3.6K Navision Attain
- 2.4K Navision Financials
- 116 Navision DOS
- 851 Navision e-Commerce
- 1K NAV Tips & Tricks
- 772 NAV Dutch speaking only
- 617 NAV Courses, Exams & Certification
- 2K Microsoft Dynamics-Other
- 1.5K Dynamics AX
- 333 Dynamics CRM
- 111 Dynamics GP
- 10 Dynamics SL
- 1.5K Other
- 991 SQL General
- 383 SQL Performance
- 34 SQL Tips & Tricks
- 35 Design Patterns (General & Best Practices)
- 1 Architectural Patterns
- 10 Design Patterns
- 5 Implementation Patterns
- 53 3rd Party Products, Services & Events
- 1.6K General
- 1.1K General Chat
- 1.6K Website
- 83 Testing
- 1.2K Download section
- 23 How Tos section
- 252 Feedback
- 12 NAV TechDays 2013 Sessions
- 13 NAV TechDays 2012 Sessions