Creating Journals using Spreadsheet in Fusion application

Step 1: Login to Fusion Applications

 

Step 2: Click on Navigator à Click on the Journals under General Accounting

 

Step 3: On the right hand side,Click on the Tasks icon and then click on Create Journal in Spreadsheet

Step 4: Save the file.

   

Step 5: Open the Spreadsheet ,click on Enable Editing . Click Yes to connect to the Application and then enter the login Credentials.

 

Step 6: Fill the Journal Entries into the sheet and then Click on Submit

 

Note:
•    The Total Entered Debit and Total Entered Credit must be equal.
•    Make sure to fill in all the Mandatory fields( i.e. * marked fields)

The following screen appears:

Based on the requirement ,select any suitable options and click on Submit.( In this test case we have selected Submit Journal Import)

 

**If the rows have been submitted ,the Row Status is shown as Row Inserted Successfully.

 

Step7: A Confirmation Message is displayed. Click OK

 

View the Journals in Applications:

Click on the Navigator--> Click on the Journals under General Accounting .

 

Search for the Journals Created using the appropriate fields.

The journals can be viewed in the rows below