I want to display outstanding invoices per customer in Power BI, including the payment notes associated with these entries in Exact Online.
In Exact, I see these via Aging Analysis → To be Received → Related Notes and Tasks. For example, there are comments about payment agreements and reminders sent.
I have tried the table ExactOnlineREST.Financial.Notes@eol for this, but it does not return any rows.
Is this the correct table for these notes? If not, through which table can I retrieve them? And through which field can I link the notes to the correct outstanding entry or booking?
If these notes are not available via the Exact Online API, I would also like to know.
This question was automatically closed after 1 week of inactivity. The last answer given has been marked as the solution.
Please ask a new question via a separate topic if the issue occurs again. Please include a link to this topic in the new question by pasting its URL into the text.