Solved

Display Note Text in Supplier Invoices Analysis

  • 28 July 2021
  • 2 replies
  • 171 views

Userlevel 4
Badge +9

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? 

 

 

icon

Best answer by Thushitha Chandrasiri 28 July 2021, 17:35

View original

This topic has been closed for comments

2 replies

Userlevel 7
Badge +20

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,

Userlevel 4
Badge +9

Hi @ThushAsanka 

Many thanks. The query worked!