Friday, May 21, 2021

Important Questions in Oracle Payables

  • Types of Invoices in Oracle Apps?
    • Standard
    • Prepayment
    • Expense Report
    • Mixed Invoice
    • Credit Invoice
    • Debit Invoice
  • What is Mixed Type Invoice in Oracle Apps?
    • Mixed Invoice is one of the Invoice Type in the Oracle Payables. 
    • You can enter both the Negative(-) and the Positive(+) amount for this Mixed Type Invoice. 
    • This Payment type is not rigid like Standard, Prepayment, Credit & Debit Memo Invoices to enter the amount in the specific signs (Positive or Negative).

  • Difference between the Manual Hold and the System Hold?
    • System Hold apply to the Invoice if something mismatched in the Invoice as per the Standard Process like Invoice Header Total and Line Total Should be equal other System Hold for Example related to Invoice Matching if something goes about the Invoice Tolerance Limit then System put the Hold. 
    • System hold is something related to setup Controls but whereas Manual Hold is something which put manually in the Invoice due to any reason like Product received from the Supplier is damaged so need to hold the Payment for that Invoice.
  • What is Pay alone in AP Invoice?
    • Pay alone is something related to Invoice Payment. 
    • This is the Flag we set for AP Invoice, it means this invoice will be paid alone. 
    • For example, Supplier XYZ has two Invoices, but for one Invoice we have enabled the Pay Alone Flag then when we will run the Payment Batch then System will create one check for one invoices and separate one check for Pay Alone Invoice. This is the working of Pay Alone.
  • Can we pay the AP invoice before Due Date?
    • Yes, we can pay the Invoice before Due date. 
    • For Manual Payment, there is no concern but for Payment Batch, when we are running the Payment Process Request((PPR) then we need to Enter the Pay Through Date this Date is Very Important, If we have set the Pay Through Date “15-Aug” then this Payment Request will pick only those AP invoices which has been due before “15-Aug-YYYY”.
  • How AP Invoice Payment Due Date Calculates in Oracle Payables?
    • Invoice Payment Due date depends on the two factors.
      • Payment Terms attached to the Invoice
      • Invoice Date.
    • For Example, if Payment Terms is 30 Days and the Invoice Date is 01-Aug-2020 then Payment Due Date Will be 01-Sep-2020
  • What is Primary and Secondary Ledger in Oracle Payables?
    • Primary Ledger is the main Ledger and Secondary Ledger is the replica of the Primary Ledger. 
    • Transactions will be done in the Primary Ledger. 
    • The main reason of using Primary and Secondary Ledger is the difference in the Organization requirement and the statuary requirement. 
    • For Ex, One US based company office is in India and as per US, their Calendar works from Oct to Sep but the in India their calendar works from April to March. So in this Kind of requirement, Primary and Secondary Ledger concept comes. Where we can design the Primary calendar as per the US based but can design the Secondary calendar as per India statuary requirement. 

  • What is Recurring Invoice in Oracle?
    • As its name represents ‘Recurring’. Recurring means again and again. If any Organization books the Office rent invoice every month for the same amount or any other fixed expenses every month then oracle has provided the Recurring Invoice. We just need to do the recurring Invoice setup for that amount and system will create the invoice automatically on the First day of the Months.
  • What is the use of Payables Trial Balance Report ?
    • Payables Trial Balance Report shows the Total Liability or the Supplier Outstanding in the System. 
    • This Report shows the Liability in the System supplier and Site Level. 
    • This Provide the Summary Information’s for all the Unpaid amount for the Supplier Invoices which are validated.
  • What we do in the AP and GL reconciliation ?
    • In the AP and GL reconciliation, we try to match the Total Liability from the Payables with the Liability accounts total in the GL. 
    • We have some set of Liability accounts in the Payables, which we only use in the Invoice Headers to book the Liability and we match only these Liability GL accounts in the AP and GL reconciliation report.
    • We took the help of Payables Trial Balance report to find the Total AP liability and then run the GL Trial Balance report to match the Payables Trial Balance Report Total with the GL trial Liability Accounts.
  • Distribution Set in Oracle Payables?
    • Distribution set is the combination of multiple Distribution lines using different -2 GL accounts Combination. 
    • For Example, we booked most of the AP invoices in two different GL accounts combination so each time we need to enter two lines in the invoice distributions to book the AP invoices expenses in these two GL accounts but this process can be make query quickly and easy. 
    • Oracle have functionality like Distributions set in Oracle Payables where we can any number of GL accounts line for a Given Distribution sets and then in the Oracle Payables Invoices we don’t need to create Distribution lines manually. 
    • We just need to enter the Distributions Set in the AP Invoice Lines and oracle system automatically creates the Invoice distribution lines with GL accounts given in the distribution set in Oracle Payables R12.

No comments:

Post a Comment

SupplierAddressImportTemplate.xlsm South Africa Suburb Field mapping in POZ_SUPPLIER_ADDRESSES_INT

Suburb mpping in Supplier Address Import Template will be mapped to Address Element Attribute2 (HZ_LOCATIONS. ADDR_ELEMENT_ATTRIBUTE2)