Our customer would like to link all AP invoices that relate to one AR invoice together, in order to get profitability report per deal. Using Projects is not an option as they generate a couple hundred invoices per month.
The report needed is:
BP Code (customer), name, AR Invoice no, date, revenue (service invoices, by the way)
AP invoice 1, date, amount (this is for materials for example)
AP invoice 2, date, amount (this is for labor for example)
...
TOTAL PROFITABILITY = AR Revenue minus Sum(AP Invoices 1 to N)
I hope this is clear enough. Thanhs for your help.
Andres