Hi,
I want to create two custom fields in the menu Supplier Invoices Analysis (view = INCOMING_INVOICE2) and need some help:
- A Custom Field which shows the On Hold Reason (SQL Column: on_hold_reason) from the menu Authorize Invoices for Payment (view: PAYMENT_PLAN_AUTH_QRY).
- A Custom Field which shows the Coordinator (SQL Column : AUTHORIZE_CODE) from the menu Purchase Order (view: PURCHASE_ORDER).
Can someone please assist me and help me get the right statements to create both custom fields?
Kind regards,
Simon
Best answer by Dumeesha Wanigarathna
View original