Exforsys
+ Reply to Thread
Results 1 to 8 of 8

Ap functioanl questions

This is a discussion on Ap functioanl questions within the Oracle Apps forums, part of the ERP category; Hi, 1. What are the types of Invoices , what is prepayment & steps to apply it to an Invoice ...

  1. #1
    yogeshwar5590 is offline Junior Member Array
    Join Date
    Mar 2007
    Answers
    1

    Ap functioanl questions

    Hi,

    1. What are the types of Invoices , what is prepayment & steps to apply it to an Invoice ?

    ANS :

    2. What are the Distribution Type while entering the Invoice?

    3. What's the difference between the
    Program and the "Payables Invoice Import" program?

    4.What is Debit Memo & Credit Memo in Payables?

    5. What is Proxima Payment Terms?

    6. What will accrue in Payables?

    7. What is Tolerance?

    8. What is Aging Periods?

    9. What is a Payable Document?

    10. What are the tables associated with Invoice?

    11. Which interface tables are used for Invoice Import , give the important columns?

    12. What is 2 way , 3 way and 4 way matching?

    13. How you will transfer payables to general ledger?

    14. You created a set of book , where you will attach this SOB in AP?

    15. What is use of AP Accounting Periods?

    16. What is Interest Invoice and how it can be created?

    17. What is a Hold? Explain the types of Hold

    18. How many key flexfields are there in Payables?

    19. Explain the set up used for Automatic or Manual Supplier Numbering.

    20. Can you hold the partial payment if yes then how?

    21. Can you cancel the invoice? If yes, explain

    Thanks Yogeshwar


  2. #2
    siva sankar is offline Member Array
    Join Date
    Feb 2007
    Answers
    31
    Hi,

    TYpes of Invoices:

    1)Standard Invoice
    2)Debit Memo
    3)Credit Memo
    4)Withholding tax invoice
    5)PO Default
    6)Prepayment Invoice
    7)Expansive Reports
    8)Recoring Invoices
    9)mixed Invoices

    Prepayment Invoice:

    Whenever we want make payments to the suppiler in advace that time,we create this prepayment invoice and we will make the payment.

    Credit Memo,Debit Memo:Both invoices are got -ve amount,and adjusted against standard invoice.
    Credit memo will be created, when ever suppiler giving discount.
    Debit Memo will be created,if buyer is going to deduct the amount.

    Thanks,
    Siva Sankar


  3. #3
    siva sankar is offline Member Array
    Join Date
    Feb 2007
    Answers
    31
    Hi,

    How many key flexfields are there in Payables?

    0 (No key flexfields in PO,AP)

    Tables:

    AP_INVOICES_ALL
    AP_INVOICE_DISTRUBUTIONS_ALL
    AP_PAYMENTS_ALL
    AP_PAYMENT_SCHEDULES_ALL
    AP_INVOICE_PAYMENTS_ALL
    AP_TERMS_ALL
    AP_TERM_LINES_ALL
    AP_CHECKS_ALL
    AP_CHECK_FORMATS
    AP_HOLDS_ALL

    Thanks,
    Siva Sankar


  4. #4
    siva sankar is offline Member Array
    Join Date
    Feb 2007
    Answers
    31
    Hi,

    What is 2 way , 3 way and 4 way matching?

    While creating the purchase order,we will mention the match approval level at shippments
    we will have 3 types
    1)2 way:Po&Invoice quanties must match with in the tolerance before the corresponding invoice can be paid.
    2)3 way:PO,Receipt and invoice quanties must match with in the tolerance before the corresponding invoice can be paid.
    3)4 way:PO,Receipt,Inspection and invoice quanties must match with in the tolerance before the corresponding invoice can be paid

    Thanks,
    Siva Sankar


  5. #5
    siva sankar is offline Member Array
    Join Date
    Feb 2007
    Answers
    31
    Hi,

    What is a Hold? Explain the types of Hold

    Invoice holds:If invoice is not approve then that invoice will be keeping under hold status.By selecting holds button in invoice form,we can see the hold details.
    Select * from ap_hold_all

    Thanks,
    Siva Sankar


  6. #6
    siva sankar is offline Member Array
    Join Date
    Feb 2007
    Answers
    31
    Hi,
    Which interface tables are used for Invoice Import , give the important columns?

    Ap Interface Tables:

    AP_INVOICES_INTERFACE
    AP_INVOICE_LINES_INTERFACE

    BASE TABLES:
    AP_INVOICES_ALL
    AP_INVOICE_PAYMENTS_ALL
    AP_PAYMENT_SCHEDULES_ALL
    AP_INVOICE_DISTRUBUTIONS_ALL

    AP_INVOICES_INTERFACE COLUMNS:

    Invoice_id
    Invoice_num
    Po_number
    vendor_id
    vendor_num
    vendor_site_id
    vendor_site_code
    invoice_amount
    Invoice_currency_code
    so on..
    Ap_invoice_lines_interface columns:
    Invoice_id
    Invoice_line_id
    line_number
    line_type_lookup_code
    amount
    po_header_id
    po_number
    po_line_id
    po_line_number
    po_line_location_id
    po_shipment_num
    po_distrubution_id
    po_distrubution_num
    Inventory_item_id
    and so on...
    Thanks,
    Siva Sankar


  7. #7
    jerryvn01 is offline Junior Member Array
    Join Date
    Jun 2010
    Answers
    7
    Quote Originally Posted by siva sankar View Post
    Hi,

    What is a Hold? Explain the types of Hold

    Invoice holds:If invoice is not approve then that invoice will be keeping under hold status.By selecting holds button in invoice form,we can see the hold details.
    Select * from ap_hold_all

    Thanks,
    Siva Sankar
    Hi,

    Thanks very much for this comment. It help me to think about my ideals.

    Tks again and pls keep posting.


  8. #8
    Jonathanus is offline Junior Member Array
    Join Date
    Mar 2011
    Answers
    6
    thank all ..........


    •    Sponsored Ads



Latest Article

Network Security Risk Assessment and Measurement

Read More...