Ap functioanl questions

[yogeshwar5590]

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

[siva sankar]

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

[siva sankar]

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

[siva sankar]

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

[siva sankar]

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

[siva sankar]

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