We consolidate our Inter-Company invoices monthly. Works fine, but it lists the details for each sales order, and the final total is not by item, but simply for the entire consilidated invoice.
Does anyone have a format where the invoice added together all items and provided a summary/consolidation by item that comes back to total invoiced.
For instance, we have 5 IC orders over a month - three order contain the same item - so the final total should be over the month XX units of product were invoiced for a total of $$.
Ideally, for our European entities, we would like the totals to split the goods by VAT rate in the receiving country for Vat reporting.rather than totalling up ALL.