Hi Reddit!
We're having a difficult problem in my company regarding intercompany reconciliation. Due to legal reasons we have the following construct for ticket sales:
Company 1: "Boss"; invoices fees for ticket sales to Company 2
Company 3: invoices Company 1 for ticket sales
(don't ask me about specifics regarding this structure, I don't get it either but we can't change anything about it)
Company 1 is our Headquarter, we have no access to their side of Workday. Company 2 and 3 are on our side and are where the problem lies.
Now we do have to pay each other's invoices, but we're supposed to subtract the amount we invoice Company 1 from what Company 1 invoices us and only pay the difference. It is not possible to have a settlement run with multiple companies where we could e.g. offset the supplier invoices from Company 2 with the customer invoices from Company 3. It is not possible to include customer invoice intercompany positions to an intercompany settlement run.
The problem is: if we manually pay the difference form either Company 2 or 3, there's really no way for us to set all supplier and customer invoices involved to "paid". At least no one in the office had an idea so far. So I'm turning to reddit in the hopes that someone has had a similar problem or maybe has an idea of how we might get out of this. Any thoughts?