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 find payable Invoice Journal in Oracle GL

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 the payable journal in oracle general ledger|| How to search payable journal entry in oracle general ledger

How to do Customer conversion in oracle cloud receivables

How to do customer conversion in oracle cloud receivables complete Process

Oracle Cloud Receivables includes following conversion activities

Open Invoice conversion
Unapplied/Open receipts conversion
Customer Conversion

In this post we are going to see how to do customer conversion in oracle cloud receivables

Pre-requisite for customer conversion in oracle cloud

For this activity we will need the complete customer data from the client's legacy system
Only Active customer conversion is done ( recommended )

Step on " How to do customer conversion in Oracle cloud Receivables"

Step 1: Navigate to Oracle cloud Receivables> Navigate to billing area and then select "Upload customer from spreadsheet task"-> Select "Download customer Spreadsheet Template"

How to do Customer conversion in oracle cloud receivables

Customer conversion in oracle cloud receivables

Step 2 : A spread sheet will be downloaded in the system. Open that spread sheet , fill the * marked data in that sheet for the customer (The for the column "Source system" , the source system must be created first under the task "Manage Trading Community Source Systems" in the system.)

Fill the data in the worksheets wherever required and create the Zip file by clicking on " Generate CSV" from the Instruction worksheet.

Step 3: Click on Upload customer from spreadsheet>Upload customer from spreadsheet

How to do Customer conversion in oracle cloud receivables

Step 4 : Give the batch name and select the zip file created from the excel template and click submit

How to do Customer conversion in oracle cloud receivables

Customer bulk upload program will be submitted in the backend.

Step 5 : Refresh the Screen. If there are no errors then the a green check mark will appear and customer will be loaded successfully. If there are nay errors in the data file it will appear under "Unsuccessful record" . Click on those errors , review them and follow the same process again.