Skip to Content
This question has been flagged
mergeinvoicessales.order10.0
2 Respostes
3978 Vistes
Avatar
NAYoru

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
Descartar
Avatar
Patrick Lukusa (klp)
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
Descartar
Avatar
NAYoru
Autor Best Answer

Thanks you! :)


Would it be possible to show the sales order date?

Avatar
Descartar
Related Posts Respostes Vistes Activitat
Missing required Account on Accountable invoice Line
error invoices sales.order
Avatar
Avatar
Avatar
Avatar
4
de maig 23
10572
Create a new project once quote is accepted by client
project task invoices sales.order
Avatar
0
de set. 23
2121
Changing the workflow for the Sales module. We don't use Sales Orders
workflow invoices sales.order quotes
Avatar
Avatar
1
de des. 21
3691
What is the link between sale order and invoice, and delivery order and invoice in odoo 11?
invoices link deliveryorder sales.order odoo11community
Avatar
Avatar
1
de juny 20
8134
The following fields are invalid: Unit of Measure - Odoo 10 Community Edition
sales.order delivery_order UOM 10.0 Odoo10.0
Avatar
Avatar
Avatar
3
de febr. 20
4999