Sunday, November 09, 2008

Payables Duplicate Invoices

A common requirement that is there in almost all Payables department is to identify potential duplicate invoices. The standard Oracle report 'Invoice Audit Listing' is not effective when it comes to list down potential duplicate invoices. The 'Invoice Audit Listing' is more of a listing and the payables manager has to spend time and effort in analysing this report. Also, not to mention when it comes to performance this report takes quite a while to complete if you mention a very old 'Begin Invoice date'.

A common requirement that comes to my mind is to report all invoices which are of same amount and currency from a supplier within a given time period. Although this report is a relatively simple report to design, but as a thought i feel this should be included as a standard report in payables.

4 comments:

Anu said...

Hi Krishnanshu

How can i find out which all accounts are hit in the event generation to ar interfacing cycle in oracle projects

Please help

Anonymous said...

Can you please give the script which pulls duplicate invoices with same invoice amount and same distributions for a given vendor ....

Frank Dong said...

YOU CAN EXPORT INVOICES FROM THE INVOICE WORKBENCH AND ANALYSIS THEM.

Sridevi Koduru said...

I am Sridevi Koduru, Senior Oracle Apps Trainer at Oracleappstechnical.com With 8 Yrs Exp on Oracle Apps and 13 Yrs IT Exp Providing Online Training on Oracle Apps Technical, Oracle Apps Financial Functional, Oracle Apps SCM, Oracle Apps HRMS, Oracle Financial for Indian Localization, SQL, PL/SQL and D2K. I have Provided Training for 500+ Professionals Most of them are Working in Real Time now.

Contact for (One to One Personal Online Training) on Oracle Apps Technical, Oracle Apps Financial Functional, Oracle Apps SCM, Oracle Apps HRMS, Oracle Financial for Indian Localization, SQL, PL/SQL and D2K at training@oracleappstechnical.com | sridevikoduru@oracleappstechnical.com | +91-9581017828 | http://www.oracleappstechnical.com

Linkedin profile - http://in.linkedin.com/pub/sridevi-koduru/8b/76a/9b8/

About Me

My Photo
India
Krishanu's Oracle Applications Blog - Oracle Apps consulting services scenario in India. Also, an inside view of Oracle Apps outsource services in India. Also the blog features new developments in Oracle Apps and my learning's in this field. The views expressed are my own only and not of my employer Wipro Technologies. The views and opinions expressed by visitors to this blog are theirs and do not necessarily reflect mine.