How can I combine 2 pivot ( Sale and Pos Order ) into 1 pivot view on my new module?
You Can use select queries for both the models and there is no need for same field or relation you can just use Union All.For Example
select pos_order as po
LEFT JOIN pos_order_line pol ON(pol.order_id = po.id)
UNION ALL
select sale_order so
LEFT JOIN sale_order_line sol ON(sol.order_id = so.id)
Hope this will help you in this regard and don't forget to define the fields you want to show on the pivot view.
I have a problem because I'm new guy in Odoo 11, my task is combine 2 pivot ( Sales and Pos Order ) into 1 pivot view of new Module that i create. So how can i do this? step by step, because I'm just new guy. Please help me, thanks in advance