Your Amazon Purchase Today

Saturday, 30 October 2021

How to search payable Invoice Journal in Oracle general ledger

How to search payable Invoice Journal in oracle general Ledger


How to search a payable Invoice Journal entry in oracle general ledger

In this post we will see how to search a payable Invoice journal entry in general ledger for a specific AP invoice.

For this let us assume we have a invoice in AP which is accounted and posted to general ledger.


Steps on how to find/search the payable invoice journal entry in oracle


There are two ways to search the invoice journal entry in general ledger


1st

In the AP module, on invoice we can see the accounting entry and the journal batch name and query that batch in general ledger directly.


2nd

You query the with Payables journal source for a specific period in general ledger.


Let us see the both ways to find the payable invoice journal entry in oracle general ledger


Method 1;

1. Open the invoice in AP module 

    Search for the invoice for which you want to see the accounting 


How to search payable Invoice Journal in Oracle general ledger

How to search payable Invoice Journal in Oracle GL


2. Open the invoice and click on Validated>Accounting, you can see the accounting entry of the       invoice. click on the side arrow of any of the line and note down the journal batch and journal name.


How to search payable Invoice Journal in Oracle general ledger

How to find payable Invoice Journal in Oracle GL


How to search payable Invoice Journal in Oracle general ledger



3. Open general ledger and navigate to search journal page 

    Search for the particular journal obtained in the step 2

    you can the the journal entry for the invoice in GL


How to find payable Invoice Journal in Oracle
How to search payable Invoice Journal in Oracle


2nd way to see the invoice journal entry in oracle


1. Open general ledger and navigate to search journal page 

    In the search criteria 

    Under period : enter the period for which you want to see the invoice journals

    Under Source : select Payables

    Under Category : Select Purchase Invoices 

    click on search 

    You will see all the invoice journal entries for that particular period.


How to find payable Invoice Journal in Oracle


How to find the payable journal in oracle general ledger|| How to search payable journal entry in oracle general ledger

No comments:

Post a Comment

Popular Posts