I have 5 tables:
A. invoices (many invoices from each vendor).
B to E. Advance payments, packaging, and other amounts they should deduct from the total in A.
I want to consolidate the total to pay, per vendor, after discounts (A-(B+C+D+E)), and have a detailed report for each vendor (invoices - deductions).
This last action is my challenge, the report for each vendor should include invoice & debit numbers, and send it for each vendor.
I could use Integromat to automate some processes, but I can’t get the detailed report per vendor yet.
Thank you all in advance.