This question has been flagged
2 Replies
2455 Views

Hello.


When I merge multiple sales order in one invoice, I get all items listed without order date.


How can I sort these items by sales order date?


Example:

SO001 - 23/07/2017
Product 1
    Product 2
SO003 - 24/07/2017
Product 1
SO004 - 25/07/2017
Product 1
Product 2
Product 3
Thanks.
Avatar
Discard
Best Answer

2 solutions.

1) Use analytic accounts just for displaying and sorting purposes on the invoice lines:

  • Activate the analytic accounting for sales

  • Tag every sales order with an analytic account having a name same as the reference number of the sales order

  • When a merged invoice is generated you can sort its lines by clicking on the "analytic account" column

  • This solution doesn't require any customization

2) Or customize the invoice form view (screen) so it can display the "hidden" column named "source document" as I show you here: https://youtu.be/2TpCBqj6s6E

Avatar
Discard
Author Best Answer

Thanks you! :)


Would it be possible to show the sales order date?

Avatar
Discard