Hi community,
How to get the report or the list of the suppliers who have passed their expiry dates?
suggest, please , Thank you
Solved
Supplier expiry date list
Best answer by ShawnBerk
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 [YOURIFSINSTANCE].supplier_info si
INNER JOIN [YOURIFSINSTANCE].identity_invoice_info iii ON
si.supplier_id = iii.supplier_id
WHERE iii.expire_date < trunc(SYSDATE)
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 [YOURIFSINSTANCE].supplier_info si
INNER JOIN [YOURIFSINSTANCE].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
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.