Payables
What is the process/steps for Vendor Conversion?
Insert the Vendor info into the interface tables and perform the required validations: AP_SUPPLIERS_INT AP_SUPPLIER_SITES_INT AP_SUP_SITE_CONTACT_INT Run the below programs to load the data into the Base tables: Supplier Open Interface Import Supplier Sites Open Interface Import Supplier Site Contacts Open Interface Import
What is Invoice Tolerance?
We can define the matching and tax tolerances i.e how much to allow for variances between invoice, purchase order, receipt, and tax information during matching. You can define both percentage¿based and amount based tolerances.
Explain the set up used for Automatic or Manual Supplier Numbering.
In the Financials Options window, you can set the Supplier
Number entry option to either Autimoatic or Manual Automatic: The system
automatically assigns a unique sequential number to each supplier when you
enter a new supplier. Manual: You enter the supplier number when you enter a
supplier
What is Contract PO?
Contract PO is created when you agree with your suppliers on specific terms and conditions without indicating the goods and services that you will be purchasing.
What is a Payable Document?
A medium you use to instruct your bank to disburse funds from your bank account to the bank account or site location of a supplier.
In which table we can find the vendor number?
PO_VENDORS
Give the cycle from creating an invoice to transferring it to GL in AP.
1)Create Invoice 2)Validate Invoice 3)Create Accounting entries using Payables Accounting Process 4)Submit the Payables Transfer to General Ledger program to send invoice and payment accounting entries to the General Ledger interface. 4)Journal Import (GL) 5)Journal Post (GL)
What are the different types of Invoices in Payables?
Standard, Credit Memo, Debit Memo, Expense Report,PrePayment, Mixed, PO Default
You have created a new SOB. How will you attach this SOB to AP?
Go to Payables Manager for the appropriate Operating Unit. Navigation:Setup—>Set of Books—>choose.
can we create invoice without PO in payables? then how?
Expenses and Liabilities
What is a Hold? Explain the types of Hold.
Payables lets you apply holds manually on an invoice, Payments etc to prevent the payment from being made or to prevent the accounting entries to be created etc. Some of the Payable holds are — Invoice Hold, Accounts Hold, Funds Hold, Matching Hold, Variance Hold, Misc hold.
Purchasing
Payment Terms let you define the due date or the discount date , due amount or discount amount. Once the payment terms are defined, you can attach these to the suppliers and supplier sites and these terms will be automatically populated once the invoice is entered for a supplier site.
No Key Flexfields in AP
Item, Tax, Miscellaneous,Freight, Withholding Tax
What are the Prepayment types?
Temporary and Permanent
Aging Periods window are the time periods for the Invoice Aging Report. The Invoice Aging Report provides information about invoice payments due during four periods you specify
Whats the difference between the “Payables Open Interface Import” Program and the “Payables Invoice Import” program?
Payables Open Interface — for importing regular invoices
Payables Invoice Import — for importing expense reports. In 11i renamed as Expense Report Import.
What is prepayment & steps to apply it to an Invoice?
Prepayment is a type pf invoice that you enter to make an advance payment to a supplier or employee. To Apply it to an Invoice ,in the Invoices window, query either the prepayment or the invoice to which you want to apply it. Choose the Actions button and select the Apply/Unapply Prepayment check box. Click OK.
Can you hold the partial payment if yes then how?
Yes.
1.Go to the Invoice window. Go to the scheduled payments tab. 2.Click “Split” to split the scheduled payment into as many payments as you wish. 3.Check “Hold” against the Payment line you wish to hold.
Create Accounting. Transfer the transactions to GL_Interface Import the Journals Post the Journals
What program is used to transfer AP transactions to GL?
Payables Transfer to General Ledger Program
What is use of AP Accounting Periods?
In Payables accounting periods have to be defined to enter and account for transactions in these open periods. Payables does not allow transaction processing in a period that has never been opened. These periods are restricted to Payables only. The period statuses available in Payables are Never Opened, Future,Open, Closed, and Permanently Closed.
What are the different interface programs in AP?
Payables Open Interface Import to load Invoices and other transactions. Supplier Open Interface Import to load Suppliers. Supplier Sites Open Interface Import to load Supplier sites. Supplier Site Contacts Open Interface Import to load Supplier Site contacts.
Credit Memo is a negative amount invoice you receive from a supplier representing a credit. Debit Memo is a negative amount invoice you send to notify a supplier of a credit you recorded for goods or services purchased.
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.
Question :How many key flexfields are there in Payables?
Answer: 0 (No key flexfields in PO,AP)
Question: Name few Account Payables Tables
AP_INVOICES_ALL
AP_INVOICE_DISTRUBUTIONS_ALL
AP_PAYMENTS_ALL
AP_PAYMENT_SCHEDULES_ALL
AP_INVOICE_PAYMENTS_ALLAP_TERMS_ALL
AP_TERM_LINES_ALL
AP_CHECKS_ALL
AP_CHECK_FORMATS
AP_HOLDS_ALL
Question: 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)two way: PO & Invoice quantities must match with
in the tolerance before the corresponding invoice can be paid.
2)three way: PO, Receipt and invoice
quantities must match with in the tolerance before the corresponding invoice
can be paid.3)four way: PO, Receipt, Inspection and invoice quantities must match with in
the tolerance before the corresponding invoice can be paid
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
Which interface tables are used for Invoice Import , give the
important columns?
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
invoice_amount
vendor_site_code
vendor_site_id
Ap_invoice_lines_interface
columns:
Invoice_id
Invoice_line_id
line_number
line_type_lookup_codeamount
po_header_id
po_number
po_line_id
po_line_number
po_shipment_num
po_line_location_id
po_distrubution_num
po_distrubution_id
Inventory_item_id
No comments:
Post a Comment