Q: What formula should I use to balance AP to GL?
A: Use the following as an example of how to balance. In this example, you are closing your accounting period for April and you have just posted your final invoice and payment batches to your general ledger system.
To reconcile your accounts payable activity for April, make the following calculation:
“Accounts Payable Trial Balance” as of March 31
+ “Posted Invoice Register” for the period between April 1 and April 30
- “Posted Payment Register” for the period between April 1 and April 30
= “Accounts Payable Trial Balance” as of April 30
Reconciling AP to GL is accomplished with the use of the following reports.
“Posted Invoice Register”
“Posted Payment Register”
“Accounts Payable Trial Balance” (current and last period)
These reports ensure that your Trial Balance accurately reflects your accounts payable liability by matching the Posted invoices and payments with the AP liability account. You can also compare your AP liability accounts to GL by doing a query of the accounts in GL to identify the account or accounts out of balance. The trial balance total should be the same as your GL liability account.
Run the GL “Account Analysis” report for the liability account and for the date range in question. Look for transactions with a source other than Payables. This can quickly pinpoint any transactions incorrectly charged to the account. Make sure that you have not made manual
journal entries to your liability account in General Ledger.When you identify the accounts you go back to AP and do a query on the account to find the invoices out of balance.
The last step is to create a journal entry in GL to balance the account or accounts that is out of balance.
Q: How is the as-of-date used in the “Accounts Payable Trial Balance” report?
A: The as-of-date is used to determine which invoices and payments should be included on the report. Any invoices or payments with an accounting date AFTER the entered as-of-date will not be displayed on this report.
Posted in Interview Questions, Oracle AP Functional, Oracle Functional, Oracle Payables Technical
Tagged 11i, account payables, ap to gl, gl to ap, posted invoice register, posted payment register, r12, reconciliation, trial balance
What is the Functionality of the Documents Tab on the Navigator
If you have a document, such as a particular purchase order, invoice, or sales order that you want to access later, you can create a link to the document using the Navigator’s Document feature.
The Navigator’s Document feature allows you to create as many links as you want and save them in the Documents region of the Navigator window. The links can be represented as icons in the window or may be viewed as a list. Documents are defined as "real–world” documents such as those listed above, but may also include such documents as employees or plans. When you use a link to open a document, Oracle Applications opens the document in the appropriate form window. You can access the Document region using the tab control.
Adding new Documents to the Navigator
1. Forms that support adding documents to the Navigator enable the Place on Navigator menu item in the File menu. Use this menu item to add your document to the Navigator.
Opening the Navigator’s Document Region
1. Choose Documents from the tab control in the Navigation window.
Once you create a link to a document, the Document region will open by default when you log on.
To open a form from the Document Region
1. Select the document link you want to open.
2. Choose Open or double–click it.
Renaming Documents in the Navigator
1. Select the document link you want to rename.
2. Choose the Rename… button, or double–click the label.
3. Enter the new name, then press OK.
Note: There is a limit of 80 characters for document names.
Removing Documents from the Navigator
1. Select the document link to be discarded.
2. Choose Remove.
Removing the document link from the Navigator has no effect on the actual document. However, if a record such as a purchase order is deleted in the ”Enter Purchase Orders” form, the link in our Navigator displays a message letting you know that your link is now invalid.
for more info – do refer — following extract from "Oracle Applications User Guide" –Using the Navigator’s Documents Region – Page 1 – 18
Template Form in Oracle Apps This document provides an overview of the template form. This form derives its importance from the fact that this form is the starting point of all development involving forms. The document highlights the importance of … Continue reading
Hello Friends, here is the second set of Questions on Application Developers , more of general questions, i am not digging in particular areas , only trying to put question which i normally ask with candidates. If you want help … Continue reading
Back-to-Back Order is very useful functionality in Oracle Applications.
Key Business Drivers
Lower inventory cycle time
Lower inventory cost
Link supply to specific demand
Can offer a variety of product to customer
Used heavily in contract manufacturing environment where the product is standardized and the company plans to focus more on product design rather than manufacturing
Many times business suffers a loss when data is transferred between quotations, orders, purchase orders or invoices?
Damage to any business due to data loss or corruption is always very high. This can be due to a simple user error or data corruption. During the manual transfer of data, the input of incorrect information or staff errors are very real risks. This can have a profound impact as your business grows and staff are under more pressure to process orders in a market where the client expectation is no longer to have their order processed in days or hours but in real-time.
Back to Back order process allows you to process information and orders in very logical manner ensuring a simplistic and efficient process. The integration between quotations, order processing and stock management means that all orders can be processed in real time and you are no longer dependant on a manual process to be run.
e.g. When the PO is received, reservation gets applied automatically against the Sales Order. This prevents allocating material to some other demand.
The key behind the integration of a system is the ability to seamlessly integrate different pieces of information, this leads us to back-to-back order processing.
The key areas that are focused on as part of the back to back process are:-
Back to back order processing provides an integrated seamless link from the quotation stage, through to the purchasing of stock (or services), to dispatching, delivering and invoicing your client and the receipt and payment of invoices. It is also extended to invoicing (against PO/receipt) and payment to your supplier. All this process is done using Oracle Work-Flow, standard work flow is given by Oracle but if you want you can modify the same to fulfill business needs. Approval processes are also taken care by Work-Flow.
The entire process can be performed in the minimal amount of time without any redundancy. Each document has reference of some other document so it doesn’t get lost in between. Below are the steps in Back to Back order.
Quotations are created and sent to the client.
The client places the order and all required acknowledgements are sent.
Requisitions / Purchase Orders are automatically created for the required stock.
Management of awaiting stock from suppliers.
Tracking and managing supplier and customer communication.
Receiving of stock and handling of part deliveries.
Dispatching the order to your customer with management of delivery locations and methods.
Some of the important documents that gets created automatically through the different stages in this cycle include (automatic creation of document/s depends on setup).
Quotations, Order Acknowledgements and confirmations, Invoices and Proforma Invoices, Purchase Orders, Stock Receipt Slips, Stock Transfer Slips, Dispatch Notes, Packing to name a few.
For demo please visit two links given below:
Posted in Oracle AR Functional, Oracle Functional, Oracle Receivables Technical, SME Contributions
Tagged 11i, back to bacck order, disptach notes, dropship, invoices, oracle process flow, oracle purchasing, order, order acknowledgements, order management, packing slip, procure to pay, proforma invoices, purchase order, quotations, r12, receive po, requisition, sales order cycle, ship order, shipment, shivmohan, stock receipt slips
Friends, here some of quite useful regular sql queries in oracle applications. Query 1: Select responsibility name along with application name SELECT application_short_name , frt.responsibility_id, frt.responsibility_name FROM apps.fnd_responsibility_tl frt , fnd_application fa WHERE fa.application_id = frt.application_id; Query 2: Get … Continue reading