Skip to main content

Hi community,

 

How to get the report or the list of the suppliers who have passed their expiry dates? 

 

suggest, please , Thank you 

If you just want the list without the date or creating a report, you can do an Advance SQL search on Suppliers like this.

 

If you need the date and want this in a downloadable report, then you would need the SQL Query Tool or a Quick Report setup like this.

 

select si.supplier_id, si.name, si.country, iii.expire_date from mYOURIFSINSTANCE].supplier_info si

INNER JOIN NYOURIFSINSTANCE].identity_invoice_info iii ON

si.supplier_id = iii.supplier_id

WHERE iii.expire_date < trunc(SYSDATE)


There is an Inactive Date under the Supplier - Invoice / General tabs

If an Expiration date has been entered under the Supplier - Purchase / Misc Supplier Info tab - you can see this in the Suppliers - Purchase Specific Information screen

 

 


Reply