SQL Link between Project billing event and AR invoice?
Summary:
I need to identify the event which generated an AR invoice. Which table stores this information?
Content (please ensure you mask any confidential information):
Hi.
The context of the problem is the following:
We have an AR invoice created and we need to achieve the following:
- 1. Cancel the invoice by modifying the event amount to 0.
- 2. The credit note would be automatically generated in the next execution of the scheduled Generate Invoices process.
- 3. Next, modify the amount of the previous event again and have a corrective invoice automatically generated in the next execution of Generate Invoices.
In order to cancel an AR invoice modifying the event amount using API REST