4 Replies Latest reply: Aug 14, 2012 8:01 AM by 953165 RSS

    Invoices without Sales order reference

    953165
      Hi,

      I am new to Oracle receivables.
      Can anybody explain me, what is the purpose of Invoice transactions that not having sales order references?

      Thanks.
        • 1. Re: Invoices without Sales order reference
          Luko
          Hello,

          You do not have references for manual invoice. Now every invoice is connected with sales order.

          Regards,
          Luko
          • 2. Re: Invoices without Sales order reference
            953165
            Thanks,

            Basically I have requirement to get Total Revenue amount (income from customer).
            In that case should I consider such invoices?
            and from where we can get actual total revenue amount applied against invoices?

            Thanks in Advance
            • 3. Re: Invoices without Sales order reference
              Luko
              Hello,

              1. If I were you I will ask user to specify transaction types or accounts because user maybe do not want some kind of transaction example: interest invoices etc. Maybe want only transaction from order entry. You must check this.


              2. I'm not developer but look at http://www.oracleappshub.com/accounts-receivable/ar-back-to-basictechnical-foundation/ this will help you.

              I pick this sql from http://www.oraclebusinessapps.com/downloads/revcogs1/revcogs.sql

              Look at account_class = 'REV'

              SELECT *
              FROM ra_cust_trx_line_gl_dist_all
              WHERE customer_trx_line_id IN (
              SELECT customer_trx_line_id
              FROM ra_customer_trx_lines_all
              WHERE interface_line_context = 'ORDER ENTRY'
              AND interface_line_attribute6 IN (SELECT line_id
              FROM oe_order_lines_all
              WHERE header_id = (SELECT header_id
              FROM oe_order_headers_all
              WHERE order_number = &your_order_number))
              AND account_set_flag = 'N'
              AND account_class = 'REV');

              Regards,
              Luko
              • 4. Re: Invoices without Sales order reference
                953165
                Hi Luko

                Thanks for reply :)

                Edited by: Kapil Mistry on Aug 14, 2012 6:01 AM