1. Get rid of all advertisements and get unlimited access to documents by upgrading to Premium Membership. Upgrade to Premium Now and also get a Premium Badge!

How to create duplicate Invoice report.

Discussion in 'Oracle Financials' started by Moonwalker, Jul 5, 2009.

  1. Moonwalker

    Moonwalker Forum Advisor

    Messages:
    68
    Likes Received:
    2
    Trophy Points:
    160
    I have a requirement to identify potential duplicate invoices and also to a report on all invoices which are of same amount and currency from a supplier within a time period.

    I dont want to use Invoice Audit Listing report, which other report can i use. Am fairly new to ebs, please any easy process will do.
     
  2. apps_expert

    apps_expert Forum Expert

    Messages:
    325
    Likes Received:
    28
    Trophy Points:
    330
    Location:
    Chennai, India
    Well you may look at Invoice register report, but your requirement is pretty custom. It would be very easy to prepare such a custom report by basing it on the ap_invoices_all and ap_distributions_all tables. The tables names are off my head so the spellings may be wrong.
     
  3. yknev

    yknev Active Member

    Messages:
    28
    Likes Received:
    0
    Trophy Points:
    100
    Dear Moonwalker,

    Give me u r exact requirement with columns and condition based on amount or period. I will try to write a query for u r recquirement.