
- Forum
- ERP
- Oracle Apps
- Ap functioanl questions
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 ...
-
03-15-2007, 03:43 AM #1
- 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
-
03-15-2007, 10:24 AM #2
- 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
-
03-15-2007, 10:31 AM #3
- 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
-
03-15-2007, 10:39 AM #4
- 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
-
03-15-2007, 10:45 AM #5
- 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
-
03-15-2007, 11:17 AM #6
- 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
-
Hi,
Thanks very much for this comment. It help me to think about my ideals.
Tks again and pls keep posting.
-
03-30-2011, 05:00 AM #8
- Join Date
- Mar 2011
- Answers
- 6
thank all ..........
-
Sponsored Ads
«
Oracle Apps AP and AR Migration from R11i to R12
|
Difference between Document Sequence and Accounting Sequence
»

Reply With Quote






