Hi @BZNSIMON ,

Supplier Invoices Analysis window is attached to the LU - ‘IncomingInvoice’ which is listed under Excluded LU list (Solution Manager\User Interface\Custom Objects\Excluded Logical Unit). Then you are not allowed to created custom object for this page. You can read about this in F1 documentation. 

Hi @Dumeesha Wanigarathna , 

Are you sure about this? When I check the menu Excluded Logical Units I can’t find the LU in the list. 

We are on apps10 update 7. 

Kind regards,

Simon

HI @BZNSIMON ,

Have you tried to create custom object in this page ? 

I checked in the latest reference environment for App10. See below.  However that record is registered in 2016 and then I doubt why it is not there in UPD7.  Our UPD7 As released reference environment is down for the moment and therefore I cannot check that.  If you are unable to create a custom field for the LU then the above may be the reason.

Hi @Dumeesha Wanigarathna, 

I am able to create Custom Fields, see the screenshot below. 

Hello @BZNSIMON ,

Yes. I too tried and able to add a read only custom field after removing the LU from excluded list. can you try a SELECT statement as below for your first requirement.

SELECT t.on_hold_reason FROM Payment_Plan_Auth_Qry t WHERE t.company = :COMPANY AND t.invoice_id =:INVOICE_ID

May be the LU was excluded due to a reason like performance  as per the above content in F1 docs

Hi @Dumeesha Wanigarathna 

Thanks a lot, the statement worked! Do you also have the statement for mysecond requirement? I can imagine that this is a trickier one. 

Kind regards,

Simon

Hi @Dumeesha Wanigarathna , 

I managed the make the correct statement for the last requirement myself. There is only one issue when there are multiple PO References seperated with a semicolon. When that is the case IFS returns no value. But I will create another topic for that issue. 

Kind regards and thanks for your help!

Simon