Steve-

Have you tried matching from the supplier 360?

Best-Christy

Hi, 

I wanted to open this back up.

1. has anyone come up with an automated supplier statement reconciliation outside of exporting data from either supplier invoice analysis or supplier 360?
2. . Is there a field in IFS where you can track the last time a supplier statement was reviewed? Hoping for something similar to the way customer accounts have a “Next review date” field under customer - Credit info

Thanks

Adam

Hi,

Currently, IFS Cloud does not offer a built-in automated supplier statement reconciliation feature similar to the automated reconciliation capabilities often available for customer accounts. Most users reconcile supplier statements manually by exporting data from Supplier Invoice Analysis or using Supplier 360. You can integrate third-party reconciliation software with IFS to automate supplier statement reconciliation. These tools typically extract data from IFS, upload the supplier statement, and automatically match invoices and payments, flagging discrepancies.

Unfortunately, IFS Cloud does not natively offer a specific field for tracking the last time a supplier statement was reviewed, similar to the Next Review Date field in the Customer Credit Info section. However, there are a couple of options for tracking this manually or through customization:

1. Create a Custom Field - You can create a custom field for suppliers to track the date of the last supplier statement review. This would work similarly to the Next Review Date field for customers. This field can be made mandatory or set to trigger a notification for the next statement review date to help purchasing or accounts payable teams stay on top of reviews.
2. Use an Event Action to Track Reviews - You can also set up an Event Action in IFS that logs when a supplier statement is reviewed or an invoice is reconciled against a statement. For example, an event can be triggered when a user enters or updates a specific field (such as a note or remark in the supplier profile) to log the timestamp of the last review action.
3. Use the Existing Notes or Document Management System - Supplier 360 or the Supplier Master Data screen includes sections for notes and document attachments. You can manually log the date of the last statement review in the notes section of the supplier record.

I'm happy to share my advice on this. If you found the answer helpful, please mark it as the correct answer. This will allow us to close the thread and make it easier for other community users to find and benefit from in the future.

Best regards,

Thakshila