Restrict

Sunday, September 23, 2012

Oracle Payable Real time Question with Answer

Oracle Payable Real time Question with Answer


Question
Answer
What are the types of invoices?
Standard, Debit memo, Credit memo,Prepayment,Retainge,Withholding invoice,Expense Report
What is Prepayment and Process?
A prepayment is a type of invoice you enter to make an advance payment.We can adjust prepayment against standard invoice in future.
What are Types of Prepayment?
Permanent -which is used for long term deposit. Ex:-Fixed deposit,Term deposit
Temporary-which is used for short term advance.Ex:-Advance to supplier
What is the use of permanent prepayment and Accounting entry?
Ex:Term deposit for long term    
    Advance to supplier    Dr       100
    To Supplier                 Cr       100
Batch payment process
Its a 11i bulk payment for multiple supplier
Standard concurrent program in AP
Create Accounting, period close exception report, India-Creditor ledger
Difference between invoice and invoice batch and what setup required?
It’s either, or relation. We have to activate profile option batch% as yes. It will disable the new button at find screen at invoice.
Can we change invoice if we made the payment?
Yes we can change if its not accounted and if the amount exceeding the previous amount otherwise can’t change.
What are the criteria for entering a standard invoice?
Supplier, Supplier site, payment term, payment method, distribution account
What are the modules interfaced through AP module?
Purchasing,GL
What is the work of payment manager?
We can make payment supplier category wise and for multiple supplier payment in a one struck.
What are the events for close the AP period?
Can we sweep invoice which is in hold position?
No, We have hold and release that then we can close the period.
What do you mean of retention in AP?
It means holding some part of payment for a contract suppler. Retain value will be release at the end of the contract. We can make through Retainage invoice.
What are the encumbrance options for AP? How are they used?
PO encumbrance and requisition encumbrance available in Financial options.
Encumbrance used to reserve the funds at the time of raising PR or PO.
What are the different types of supplier site?
Purchasing,Pay,Primary pay,RFQ only,Procurement card
How can we default supplier site at invoice level?
Enable primar pay check box in supplier site for that particular site.
What is the use of Withholding invoice and which scenario?
What is the entry for AP invoice?
Expenses Ac      Dr  100
To Supplier Ac  Cr 100
What is recurring invoice? What is the scenario we are using this?
Repeatedly incurring invoice for expenses that occurs regularly.
Example: Rent for every month and lease payment
What are the methods of accounting?
Accrual and Cash method
What is special calendar & why its required?
Use the Special Calendar window to define periods that Payables uses for automatic withholding tax, recurring invoices, payment terms, and for the Key Indicators Report. For example, if you monitor staff productivity weekly, use this window to define weekly periods for the Key Indicators calendar type.
What types of Distribution Set and whats the use of skeleton DS?
Use Full Distribution Sets to create distributions with set percentage amounts or Skeleton Distribution Sets to create distributions with no set distribution amounts. For example, a Full Distribution Set for a rent invoice assigns 70% of the invoice amount to the Sales facility expense account and 30% to the Administration facility expense account. A Skeleton Distribution Set for the same invoice would create one distribution for the Sales facility expense account and one distribution for the Administration facility expense account, leaving the amounts zero. You could then enter amounts during invoice entry depending on variables such as that month's headcount for each group.
What is EB Tax and set up. How its linking to the AP and AR module?
1. Define party tax profiles 2. Define regime 3. Create Tax 4. Create tax Status 5.Create tax rate 6.update tax configuration options
How to create tax rates?
Create tax in EB tax
Withholding tax and utilization
It’s like TDS concept in India.
What is the use of Offset Account method
Three types i.e. None,Balance,Account  If we selecting None then Supplier account will be same for all  OU ,If we selesting Balanceing then supplier account will seggregate for OU wise , if we select Account then its segregare All Code combination as based on real distribution account we have entered for OU wise.
How many types of payment method.
5 types i.e.Bills payable,Check,Electronic,Outsourced Check,Wire
What is pay group?
It is to group invoices in to supplier category for payments.
What is prepayment settlement date in payable option?
Number of days you want Payables to add to the system date to calculate a default settlement date for a prepayment. Payables prevents you from applying the prepayment to an invoice until on or after the settlement date.
What is GL date basis in payable option?
The date you want Payables to use as the default accounting date for invoices during invoice entry.
Invoice Date-Invoice date you enter during invoice entry.
System Date-Current date for your Payables system. The date you enter the invoice.
Goods Received/Invoice Date-Date that you enter in the Date Goods Received field. If no value is entered, then the invoice date is used.
Goods Received/System Date-Date that you enter in the Date Goods Received field. If no value is entered, then the system date is used.
What is difference between debit memo and credit memo?
Debit Memo: A negative change in invoiced amount identified by customer and sent to supplier. Ex.Purchase return
Credit Memo: A negative change in invoiced amount identified by supplier and sent to customer.Ex:TDS payable
What is meant by with-holding tax invoice?
After you apply withholding tax to an invoice, you can optionally create invoices to remit withheld tax to the tax authority.
What are the mandatory setups in AP?
Financial option,Payable option,System setup option,Create payment term,Create payment administrator,Creation of supplier,Open payable period,Open GL period,Open Inventory period,Open Purchase period,
Can we make foreign currency invoice and payment?
Yes,but in payable option we have to enable use multiple currency and in bank,enable multi currency payments
Purpose of Payable invoice open interface?
It can use the Payables Open Interface Import program to create Payables invoices from invoice data in the Payables Open Interface Tables
Payable open interface import? (Expense Report Import)?
Use Payables Open Interface Import to import invoices from the Payables Open Interface Tables.
What is Multi Currency payments?
Multi currency is possible but we have to set up at the time of Bank Creation.
Can we implement MRC at Payables?
Yes
What does the Unaccounted Transaction Sweep Report do?
It will sweep the transaction to next period.
What reports should I run before closing the period?
Period close exception report,Unposted transaction
What is the program to transfer data from AP to GL?
Transfer Journal Entries to GL   (Parameter-Ledger ,End date)
What is meant by void payments?
When you void a payment, Payables automatically reverses the accounting and payment records so your general ledger will have the correct information, and so the status of the paid invoices is reset to Unpaid. Payables also reverses any realized gains or losses on foreign currency invoices recorded as paid by the payment
What are the types of journal categories available in the AP?
Payable
What is meant by matching and what are the types of matching’s available?
2 way-Invoice and PO, 3 way-Invoice,PO and Receipt and 4 way-Invoice,PO,Receipt and Inspection
What is a Hold and Release? Types of hold?
Hold means restriction in invoice for further processing.User can define any kind of holds to hold the invoice for further processing.
Type:-Manual and System hold
How to approve ‘n’ no. of invoices?
You can be Approved n number of invoices using the Request "Invoice Validation"
What is Zero-Payment in AP?
Create zero-amount payments to pay basic invoices with offsetting credit or debit memos, or to record cancelled invoices as paid so they are no longer included on the Invoice Aging Report. Before you make a zero-amount payment, you must enable the Allow Zero-Amount Payments option for the bank account you will use to create the payment.
What is Proxima Payment Terms?
Cut off day
What are the tables associated with Invoice?
AP_INVOICES
Which interface tables are used for Invoice Import?

What is Interest Invoice and how it can be created?
Payables automatically creates invoices to pay interest for overdue invoices if you enable automatic interest calculation for a supplier, and you pay an overdue invoice for the supplier in a payment batch or with a Quick payment. The new interest invoices are ready for Approval and payment.
How many key flexfields are there in Payables?
No
Can you cancel the invoice? If yes, explain?
Yes, but before create accounting
What is pay date basis?
Due,Discount,None
What is terms date basis?
From which date the payment term will be calculated.
Types:- System,Goods Received,Invoice,Invoice Received,Null
What is the report used to identify duplicate suppliers?
"Supplier Audit Report" can be used to help identify potential duplicate suppliers.
What is meant by accrual write off?
If you choose the Perpetual Accrual Method within Purchasing, Purchasing records an accounts payable liability to an AP accrual account for goods received but not invoiced. When Payables matches and approves the invoice for the received goods, Payables clears the accounts payable accrual account and records the actual liability amount to the invoice accounts payable liability account.After you have entered your receipt transactions and matched and approved your invoices, you can run the Accrual Reconciliation Report to identify any differences between your Purchasing receipts and Payables invoices.
Use of Future dated payments?
You can use future dated payments to control the timing of your payments, and therefore control your cash flow. A future dated payment instructs your bank to disburse funds to your supplier's bank on a specific date (the maturity date)
What are the period statuses in AP?
Never opened,Future,Open,Closed,Permanently closed
Tell me steps for Period closing Process in AP?
http://dillipkumarjena.blogspot.in/2012/09/month-end-activity-for-oracle-r12.html
What is meant by third party payments?
How to transfer funds between your internal banks?
Fund transfer
Can I find out which invoices are matched to a PO?
yes
ERS Invoice means?
Evaluated Receipt settlement Which makes auto invoice in payable.
What is meant by RTS transactions?
Return to supplier which has to assign at the time of creating supplier.
What are the steps to define a Bank?
1. User management-Role-Security wizard through Sys Admin 2.Bank branch 3. Bank Account 4.Bank Document assignment
How to assign Cash clearing Account
While doing bank creation, we have to give cash clearing account.



Q. What Are The Tables That Replaced AP_BANK_ACCOUNTS_ALL, AP_BANK_ACCOUNT_USES_ALL and AP_CHECK_STOCKS_ALL ?
A. Now Bank functionality moved to Cash Management.
Following tables on the left are replaced with the tables on the right
AP_BANK_ACCOUNTS_ALL => CE_BANK_ACCOUNTS
AP_BANK_ACCOUNT_USES_ALL => CE_BANK_ACCT_USES_ALL
AP_CHECK_STOCKS_ALL => CE_PAYMENT_DOCUMENTS

















No comments: