Hi K.Jiab / K.Jandee
As discussedAttached is the pivot table summary.
This is the first draft ... so I am sure you will find some issues that needs to be fixed
• I suggest AP team runs this report every morning from Porvs
• Then copy & paste data into this spreadsheet & then refresh pivot table
• Daily Track & follow up actions by our team members
For this report to work , we AP to ensure that ALL invoices are keyed into Porvs