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!

Oracle Payable

Discussion in 'Oracle Financials' started by RIAZ, Apr 15, 2009.

  1. RIAZ

    RIAZ Forum Advisor

    Messages:
    54
    Likes Received:
    0
    Trophy Points:
    130
    hi, I want to get the Invoice Status - (Accounted: Yes/No) from database but i don't know where this status is stored in DB. I am using Oracle 11i Apps (Payable)
     
  2. apps_expert

    apps_expert Forum Expert

    Messages:
    325
    Likes Received:
    28
    Trophy Points:
    330
    Location:
    Chennai, India
    hi riaz ap_ae_headers_all and ap_ae_lines_all store the accounting for all ap transactions. Check to see if your invoice is accounted or not
     
  3. RIAZ

    RIAZ Forum Advisor

    Messages:
    54
    Likes Received:
    0
    Trophy Points:
    130
    thanks for you reply,

    well i was just exploring different fields and i got POSTED_FLAG (Y/N) in ap_invoice_distributions_all.

    I think we can get the invoice status - Accounted (Y/N) from this field.

    what is your expert opinion regarding this ?
     
  4. Kirti

    Kirti Forum Advisor

    Messages:
    46
    Likes Received:
    12
    Trophy Points:
    130
    Hi RIAZ i believe (though I am not 100% sure) the posted flag is set to 'Y' when the accounting entries from ap_invoice_distributions_all are posted to GL by running the Transfer to GL program.

    This is what the TRM says about the field
     
  5. RIAZ

    RIAZ Forum Advisor

    Messages:
    54
    Likes Received:
    0
    Trophy Points:
    130
    Kirti,

    I just check /by enter invoices with and without creating accounting and this POSTED_FLAG is working (Y/N). I did not run posted to GL process.