I have been fighting an ongoing battle since we updated to E10 in January.
For the AR Invoice Form, using the standard E10 ARForm SSRS report as a base, I created a new custom form for our format. The ARForm uses code in the report to add the invoice number to the page header. (code.SetVarInvoiceNum function in the Invoice number group header).
For invoices that have only 1 page, all is good. What we encounter is on some that have multiple pages per invoice, the values in the header (invoice number) jump ahead one invoice so things don’t match up. We get page 3 of the invoice with the correct detail, but the invoice number and invoice date are pulling in the values from the next invoice. We have to print each invoice individually to get it to print correctly, rather than all the invoices as a batch. That can take more time if there’s a lot of invoices in the batch/group.
Here’s an example. The 2 values highlighted in yellow are the current invoice (551924). The values in orange are values for the next invoice (551925): The orange highlighted values are retrieved using the Code.GetValue() function. Page number is the Globals!PageNumber SSRS function.
All would be fine except that we have the page number in the report header section since it’s not possible to get a page number in the report detail section in SSRS, rather than the invoice header section in the report Matrix. If not for the page number, I could format everything to the group header of the invoice number group and print correctly.
If I print the batch of invoices to the standard E10 AR Form, it all prints correctly. It just seems to be our custom AR invoice form. We didn’t have this issue in E9 since we were using Crystal Reports for everything.
Is there a better method to accomplish this?