I need to build ratio of total of invoice amount for rent ( rent is Invoice Lines/Account/Code = 8105 without VAt and 8401 with vat) per client type Commercial or private. This needs to be cummulated by month. then I need to calculate total of rent by either with vat or without vat. I need to get the ratio between total amount of invoice price for each customer type. We need to take only Invoices in state: paid and open.
This ratio i need to apply to the deduct vat. See Sample file.
Therefore I have a files all invoices and all supplier invoices.
Solved by X. J. in 25 mins