Skip to main content

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? 

 

 

Hi @BZNSIMON ,

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,

Hi @ThushAsanka 

Many thanks. The query worked! 

 

Terms & ConditionsCookie settings