Manage and Create Journals in Oralce Fusion Application

Open slcai806 environment with FINUSER1/*********, we will see the welcome page.

Click ‘Navigator‘ button and select ‘General Accounting Dashboard‘ which is under General Accounting, we will go to General Accounting page. In this page, we can do some jobs like manage and create journals, post journals to ledgers, create journals in spreadsheet and so on.

In this page, we can see ‘Data Access Set: Vision Operations(USA)‘ on the top of tables. Data Access Sets controls which ledgers or ledger sets can be accessed by different General Ledger. That means GL needs Data Access Sets to access ledgers. Vision Operations(USA) is a default General Ledger. We can change General Ledger by ‘change‘.

Click ‘Manage Journals‘ link, we will go into manage journals page which we can search related journals by different filter conditions.If we search journals by journal name started with ‘BI‘, we will see all journals which started with BI. We can see some journals can be edited but some of them cannot be. The reason for this is if the journal we selected has been already posted, we will not edit it any more. However, if the journal has just been saved or completed but not posted, we can edit it right row if we want to.

We can click journals‘ name to check their details and status. We can find journal status in the right hand of journal batch table. Approval status is not required means the journal has been posted and approved. If it shows in progress, that means the journal you created has been posted, but not been approved by administrator. The journals with above approval status will not be edited any more. Completion status is completed means the journal has been completed or posted. If we click ‘Complete‘ or ‘Post‘ button after add a journal, this status will be changed to Completed.

Click ‘Create Journal‘ link, we will go to the page of create journals. In this page, it is divided by three parts. ‘Journal Batch‘, ‘Journal‘ and ‘Journal Lines‘. We can create a new journal batch or use a existed batch. If we need to create a new batch, the batch status is unpost right now, we have to wait for approval from administrator. We also can use a existed batch. A batch can contains more than one journals and a journal can contains a numbers of items. After we filled all textfields, we can click ‘Save‘ button to save what we create, or click ‘Complete‘ button to complete journals creation. If we click ‘Post‘, the created journals will be sent to administrator for approval.

Click ‘Create Journal in Spreadsheet‘ link, and download excel. We can manage to create journals by spreadsheet. Open the excel which we download, filling with necessary data. Then select ‘Create Journal‘ tab on the top of page, login with your username and password. Then Click ‘Submit‘ button in the excel table. After you click ‘Submit‘, you need to choose one of three kinds of upload types. ‘Submit to Interface‘, ‘Submit Journal Import‘ and ‘Submit Journal Import and Posting‘. If we choose the last one, the journal you created will be uploaded and posted. After you created journals by spreadsheet, you can validate through ‘Manage Journals‘ link.