Hi,
You can add a note on a supplier invoice in the menu Supplier Invoices Analysis (right mouse button > Notes). I want to display the note text (‘test’ in the screenshot below) in Business Reporter, therefore I need to create a new field (Relations for Facts) with a sql statement. But I do not know the correct sql statement. Is there someone who can help me?
Best answer by Thushitha Chandrasiri
Hi
You can use the below sql query to get the note text of a particular company and invoice_id.
select INVOICE_NOTE_API.Get_last_notes(company, invoice_id) from INCOMING_INVOICE2
Thanks,
+21Hi
You can use the below sql query to get the note text of a particular company and invoice_id.
select INVOICE_NOTE_API.Get_last_notes(company, invoice_id) from INCOMING_INVOICE2
Thanks,
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
