This works only if the sales with an assigned customer are assigned to an invoice if there is a customer assigned without an invoice this report won’t be useful to report to the Tax Office (SAT)

They need to report the products that they are selling and the taxes they have to pay per type of tax, so we can create a report of taxes to pay for unassigned sales so it is needed to create such a report. With the pos.order.lines model we can get all the information that is needed for the Tax Tag and the Client assigned in that sale.

It is necessary to create a report that shows this information from the pos.order.line and show the tags of the tax that is used in every line. This is how you can create a pivot table that gives you the information about every type of tax and client registered in every sale from Point of Sale.

In the pivot table we need to see the Total amount paid and the amount before taxes, since we cannot do the subtraction of values directly in the pivot table we need to move the data to a spreadsheet where we can easily do the subtraction

With this information we can go to the Tax Office (SAT) portal and create the Global Invoice with the amounts to report of every type of tax.