FAQ in GL,AP,AR

prasant25 · #1 (**permalink**) 04-18-2006, 01:18 AM

Hi Every body,

Happy Greetings of the day,I am a great need of FAQ'S for GL,AP,AR modules, is there any kind hearted people who can help me in this matter, i will be thank full to them, Exchange of that i will also send some FAQ's what i have in my library,

Regards
Prasant

techguru · #2 (**permalink**) 04-18-2006, 07:07 AM

Sridhar,

It helps every one if you can share those questions here .. if it's not copyright meterial.. Please share if the questions are your own not from any company.

Thanks,

sridhar_6735 · #3 (**permalink**) 04-18-2006, 07:54 AM

Hi

The faq are collected from various consultants and i would prefer to send them individually.

Sridhar

krishnamohan126 · #4 (**permalink**) 06-30-2006, 05:12 AM

1. How many payment methods can be assigned to a customer?

a. One
b. Two
c. Eight
d. Unlimited

2. What are the two types of commitments in Oracle Receivables?

3. While entering Invoices manually, Ship to Address of the customer is mandatory.

a. True
b. False

4. Name the two Invoicing Rules in Oracle Receivables

5. Assuming a payment term ‘IMMEDIATE’ is attached to a Transaction Type, can we raise an Invoice with Payment term ’30 Days’ for the transaction type?

a. Yes
b. No

6. In which of the following field, Standard Memo Lines appear as List of values

a. Invoice Lines Description
b. Transaction Type
c. Miscellaneous Receipt Description
d. Invoice Item Code

7. Auto Cash Rule Sets are defined to

a. Automatically apply receipts to invoices
b. Automatically apply commitments to invoices
c. Automatically apply credit memos to invoices
d. All of the above

8. If a value in a Profile class is changed, the system will

a. Automatically change the value for all existing customers with the profile class
b. Assign the new value only to new customers
c. Prompt the user whether to update for all customers or only for new customers.
d. None of the above

9. Which is of the following is a mandatory descriptive Flexfield to be defined before importing simple invoices through Auto Invoice?

a. Line Transaction Flexfield
b. Link-to Transaction Flexfield
c. Reference Transaction Flexfield
d. None of the above

10. Name the interface tables used for Auto Invoice Lines and Distributions

11. What are the valid values for the column LINE_TYPE in the interface table?

12. Can the user import invoices with user defined code combinations without using auto accounting?

a. Yes
b. No

13. Which of the following information is not required when the user is importing Credit memos?

a. Transaction Type
b. Customer
c. Payment terms
d. Amount

14. Miscellaneous Receipts can be imported into Oracle Receivables using Auto Lockbox

c. True
d. False

15. Name the interface table used for Auto Lockbox.

16. The three steps in Auto Lockbox in sequence are

a. Validation, Import, Post QuickCash
b. Import, Validation, Post QuickCash
c. Post QuickCash, Import, Validation
d. Any of the above

17. Lockbox is defined for a

a. Bank
b. Bank Branch
c. Bank Account
d. None of the above

18. Lockbox transmission formats are normal copied into

a. $AR_TOP/sql
b. $AR_TOP/out
c. $AR_TOP/reports
d. $AR_TOP/bin

19. Assuming a transaction number is not assigned to a receipt in the transmission file and Auto Cash rules are not used, the system will

a. Assign a status of ‘Unidentified’
b. Assign a status of ‘Unapplied’
c. Ignore the receipt
d. Apply to the oldest invoice

20. Dunning Letters are

a. Statement of Account Covering Letter
b. Invoice Covering Letter
c. Reminder Letters
d. Receipt Covering Letters

Answers:

1. D
2. Deposits and Guarantees
3. False
4. Bill in Advance and Bill in Arrears
5. Yes
6. A
7. A
8. C
9. A
10. RA_INTERFACE_LINES_ALL and RA_INTERFACE_DISTRIBUTIONS_ALL
11. A
12. LINE,TAX,FREIGHT & CHARGES
13. C
14. B
15. AR_PAYMENTS_INTERFACE_ALL
16. B
17. C
18. D
19. B
20. C

krishnamohan126 · #5 (**permalink**) 06-30-2006, 05:13 AM

PAYABLES

Q1. iSupplier Invoices: How do I use iSupplier Portal Invoice Entry?
A: iSupplier Invoice entry is a new feature released with one-off patch 2234922, Procurement Family Pack H and Financials Family Pack C (same as 11i.AP.J). Using this new feature your suppliers can enter their invoices on-line directly into AP through the iSupplier module. For a complete overview of this new feature including implementation steps and usage instructions, please refer to the 11i Payables User Guide (pages 4-171 through 4-174) available via Metalink. This users guide is current as of Family Pack C (11i.AP.J) and contains installation instructions for all new features released in 11i.
[top]
Q2. Match/Hold: How do I remove a Final Matching hold so that I can pay the invoice?
A:This hold is in effect because the invoice was matched to a PO line that has a status of Final Closed. There is no way to manually remove the hold; the system must remove the hold. There are two workarounds for this situation:
Workaround #1: You need to reverse the distribution line that has the final match hold. You can then create a new PO line, and match to that line.
Workaround #2: You can manually create a distribution line on the invoice that is not matched to the PO, but is charged to the correct GL account. For More information on Final Match Holds see Note 1026090.6.
[top]
Q3. Match:What do the codes in the Final Match flag mean and what does Final Match do?
A:After you match an invoice to a Purchase Order, you can look at the AP_INVOICE_DISTRIBUTIONS_ALL table and observe different codes in the FINAL_MATCH FLAG column. The FINAL_MATCH_FLAG has the following QuickCodes:
N No The PO shipment line has not been matched.
Y Yes The PO shipment line has been matched, AND one of the invoices for this PO has been final matched. When a PO is final matched to an invoice, all other invoices for that PO are updated, too. So you cannot tell from this flag, which invoice was final matched. D Done The PO shipment line is closed. You cannot invoice this distribution line.
Note: When you match an invoice to a PO, nothing special happens. But when you final match an invoice to a PO, that means you can never match another invoice to that PO. The PO lines that have been matched are closed.
[top]
Q4. Invoice Type: What is a "Mixed" Invoice and how do I enter one?
A:Mixed Invoices are invoices or credit/debit memos for which you can perform both positive and negative matching to purchase orders and to other invoices.
For example, you can enter an invoice for -$100 with Invoice Type Mixed. You can match to an invoice for $-200, and match to a purchase order for $100.
To enter a Mixed invoice:
1. Enter the invoice or credit/debit memo in the Invoices Summary, and enter Mixed as the invoice Type. You can enter either a positive or negative invoice amount.
2. Match to purchase orders, and/or invoices.
[top]
Q5. How do I create a Withholding Tax invoice?
A:After you apply withholding tax to an invoice, you can optionally create invoices to remit withheld tax to the tax authority.
Payables can automatically create withholding tax invoices, or you can perform this task manually. If you chose to automatically create withholding tax invoices, you must choose whether to do this during Approval or during payment processing. Indicate this choice in the Withholding Tax region of the Payables Options window. See: Withholding Tax Payables Options.
If you choose to create withholding tax invoice manually, create an invoice for each Withholding Tax type invoice distribution on an invoice. Create the invoice for the tax authority supplier and site assigned to the Withholding Tax type tax name and for the amount of the Withholding Tax type invoice distribution.
Please see Note 198307.1 and the 11i Payables User Guide (pages 10-26 through 10-55), for more information on Withholding Tax invoice creation.
[top]
Q6. Interest: How do I create Interest Invoices?
A:Chapter 10 of the 11i Payables User Guide discusses setting up and using Interest Invoices. Also see Note 198308.1 for more information on creating Interest Invoices including coverage of the following Interest Invoice sub-topics:
1) Setting steps that must be completed
2) Minimum Interest amounts
3) Expense GL Account to be charged for interest expense
4) Liability GL Account to be charged for interest expense
5) Automatic Interest
6) Invoice Due Date calculations
7) Interest amount calculations
[top]
Q7. Match: How do I Match Invoices to Purchase Orders?
A: Note 198535.1 provides detailed instructions for matching purchase orders to Invoices. This content is presented in the form of a white paper in PDF format. The 11i Payables User Guide (pages 4-68 through 4-82) also provides a thorough overview of the Invoice Matching process.
[top]
Q8. New Features: What new Invoice Processing features have been introduced since 11i was released?
A: For a complete description of new features released in Mini-Packs "A" through "I" please review Note 166537.1. Beginning with 11i.AP.J and continuing with Family Packs C+, Payables will deliver new feature descriptions in the "About" document for each Mini/Family Pack. Please see the 11i.AP.J About document for more details.
AP support strongly recommends that you install the corresponding documentation patch for Mini/Family Packs that you apply. These documentation patches contain the most up to date On-Line Help files with instructions on how to use or implement the new functionality introduced by the patch.
Note: 11i.AP.J was the last Payables Mini-Pack for 11i. After Mini-Pack J, Payables will deliver all 11i consolidated patches in Family Packs. 11i.AP.J will contain the same code release as Financials Family Pack C.
New Invoice Processing Features by Mini/Family Pack:
AP.J / Family Pack C: Interest Expense Proration, Enhanced Matching Controls for Finally Closed Purchase Orders, Payment Batch Enhancements, Invoice Approval Workflow Enhancements, iSupplier Portal Invoices.
AP.I: View Currency Details, Primary Pay Site, Invoice Approval Workflow
AP.E: Negative Supplier Balance Report, Employee Update Program
AP.A: Automatic Creation of Debit Memo from RTS, Input Tax Groups
[top]
Q9. Approval/Validation: What happened to the Invoice Approval option after applying 11i.AP.I?
A: In Mini-pack I, Payables is adding a new workflow named Invoice Approval Workflow that asks approvers to review invoice details, and confirm online whether the invoice is accurate and should be paid. The Payables Approval program has been renamed to prevent confusion with the new workflow and to more accurately reflect its function. For a complete list of the renamed programs see Note: 179837.1.
[top]
Q10. Supplier Import: Is it possible to import suppliers from my legacy system into Oracle Payables?
A: This functionality does not currently exist however enhancement an enhancement request has been logged. Please follow bug 94383 for up to date status on this request.
[top]
Q11. Requestor: In 11i, what is the "Requestor" field used for on the Invoice Workbench?
A: This field represents the person who requested the goods or services that are on the invoice. If you use Invoice Approval Workflow, then you can define rules that use this value to generate a hierarchical list of approvers for the invoice.

krishnamohan126 · #6 (**permalink**) 06-30-2006, 05:16 AM

Questions For Oracle Payables

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

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

3. What's the difference between the "Payables Open Interface Import"
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.

techguru · #7 (**permalink**) 01-29-2007, 06:19 AM

Thread Tools	Search this Thread
Show Printable Version Email this Page	Search this Thread: Advanced Search