Sort printing invoices

(0) Share

Report

Posted on by jaloag

678

Hi all.

I'm modifying standard invoice report (206), because I want to change the order in which the registered invoices are printed. Rather than no. I want to be sorted by bill-to name, e.g.:

Invoice no. 12 - Bill-to name A
Invoice no. 8 - Bill-to name B
Invoice no. 15 - Bill-to name B
Invoice no. 3 - Bill-to name C
Invoice no. 6 - Bill-to name D
Invoice no. 13 - Bill-to name D
.
.
.

The problem is always sorted by number. I've tried:

- Change the "Sales Invoice Header" Dataitemtable view property to "Bill-to Name". -> No success.
- Change the order property in all the tables of the layout. -> No success.

What else I can try? It is impossible?

Thanks in advance. Regards.

*This post is locked for comments

I have the same question (0)

All responses (12)

Answers (0)

Sort by

Jan Veenendaal 510 on at

Like (0)

Report
Copy link

Link copied!

Hi,

This sorting is done in the Report Viewer - so you need to change the RDLC Layout.

All tables on the invoice layout are contained in 1 rectangle, and that rectangle is in a Tablix. The Tablix contains a group - and you need to modify the sorting of that group.

I am afraid that you will run into some unexpected results if you are not careful. Please test any modifications extensively!

Was this reply helpful? Yes No
jaloag 678 on at

Like (0)

Report
Copy link

Link copied!

Hi Jan.

I've changed the sorting of the group in the global tablix which are tables included... but the behaviour is the same. It prints the invoices sorting by invoice no. :-(

Thanks.

Was this reply helpful? Yes No
Suggested answer

Miguel Llorca Gómez 7,019 User Group Leader on at

Like (0)

Report
Copy link

Link copied!

Hi Jose Angel,

Did you try activating "interactive sorting" feature (it allows sorting the report columns as needed).

The setup for this feature is simple. In the necessary textbox, enable the Interactive Sorting property and assign the sorting cell:

It is also possible to assign the sorting to multiple cells at the same time, so that each report column will be sorted separately.

Hope this helps!!

Was this reply helpful? Yes No
Jan Veenendaal 510 on at

Like (0)

Report
Copy link

Link copied!

Sorry to hear that. I've tried this in NAV2015 and it works ok there.

Was this reply helpful? Yes No
Miguel Llorca Gómez 7,019 User Group Leader on at

Like (0)

Report
Copy link

Link copied!

Hi again! I think that you can solve your issue applying a hotfix. For R2 I found that: mbs2.microsoft.com/.../KBDisplay.aspx;EN-US;2934571

But if you want to be sure, apply the latest CU :-)

Good luck and please, let me know the results!

Was this reply helpful? Yes No
Miguel Llorca Gómez 7,019 User Group Leader on at

Like (0)

Report
Copy link

Link copied!

Hi Jose Angel, did you solve your issue??

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report
Copy link

Link copied!

I would advise you not to tamper the standard 206 report. It would be better to create a copy of it, on your object ID range and to work on that copied version. By using Report Selection functionality you can simply change the report called when printing invoice. Avoid changing the standard objects whenever possible and isolate your changes in separate objects as much as you can. If you must change the standard object, do it with as less code as possible.

Was this reply helpful? Yes No
jaloag 678 on at

Like (0)

Report
Copy link

Link copied!

Hi Miguel.

Your link does not work, can you send it again?

Thanks.

Was this reply helpful? Yes No
Miguel Llorca Gómez 7,019 User Group Leader on at

Like (0)

Report
Copy link

Link copied!

Sure! Click here...

Was this reply helpful? Yes No
jaloag 678 on at

Like (0)

Report
Copy link

Link copied!

Hi Miguel, I've opened your link and it´s an older version than the one I have installed. :-(

Thanks.

Was this reply helpful? Yes No