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

Wednesday 13 October 2021

How to do Customer conversion in oracle cloud receivables

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

How to do Customer conversion in oracle cloud receivables



Customer conversion in oracle cloud receivables

Customer conversion in oracle cloud receivables


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.)



How to do Customer conversion in oracle cloud receivables


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


Customer conversion in oracle cloud receivables
How to do Customer conversion in oracle cloud receivables


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


Customer conversion in oracle cloud receivables

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.


How to do Customer conversion in oracle cloud receivables


Customer Conversion || Customer conversion in oracle cloud || How to do customer conversion in oracle cloud receivables