Creating a Statistical Journal Entry Concept Creating a

Creating a Statistical Journal Entry Concept

Creating a Statistical Journal Entry

Creating a Statistical Journal Entry Step 1 Begin by navigating to the journal Header page. Click the Scroll Down arrow.

Creating a Statistical Journal Entry Step 2 Click the General Ledger menu.

Creating a Statistical Journal Entry Step 3 Click the Journals menu.

Creating a Statistical Journal Entry Step 4 Click the Journal Entry menu.

Creating a Statistical Journal Entry Step 5 Click the Create/Update Journal Entries menu.

Creating a Statistical Journal Entry Step 6 Use the Add a New Value tab of the Create/Update Journal Entries search page to add a new journal entry.

Creating a Statistical Journal Entry Step 7 Enter the desired information into the Business Unit field. Enter "US 005".

Creating a Statistical Journal Entry Step 8 Click in the Journal ID field.

Creating a Statistical Journal Entry Step 9 Enter the desired information into the Journal ID field. Enter "RENTSTATS".

Creating a Statistical Journal Entry Step 10 Click the Add button.

Creating a Statistical Journal Entry Step 11 The Header page displays information that uniquely identifies a journal, such as business unit, journal ID, and journal date.

Creating a Statistical Journal Entry Step 12 Use the Long Description field to specify the purpose of the transaction. You can also explain anomalies, if any, in the transaction. Enter the desired information into the Long Description field. Enter "Department square footage for rent allocation".

Creating a Statistical Journal Entry Step 13 Use the Ledger Group field to specify the ledger group to which you want to post the journal.

Creating a Statistical Journal Entry Step 14 Use the Source field to specify the option for entering and editing journals. The default value is CFO.

Creating a Statistical Journal Entry Step 15 Click the Lines menu.

Creating a Statistical Journal Entry Step 16 Use the Lines page to record transaction detail lines for the journal.

Creating a Statistical Journal Entry Step 17 The Unit field displays the business unit specified on the search page.

Creating a Statistical Journal Entry Step 18 When you create a statistical entry using a statistical account, make sure you use a journal entry template that includes the Stat Amt field. Click the Template List menu.

Creating a Statistical Journal Entry Step 19 Click the Amount menu.

Creating a Statistical Journal Entry Step 20 Deselect the SHORTCOM Template ID because it does not include the Stat Amt field. Click the All option.

Creating a Statistical Journal Entry Step 21 Select the COMMERCIAL Template ID since it includes the Stat Amt field. Click the All option.

Creating a Statistical Journal Entry Step 22 Click the OK button.

Creating a Statistical Journal Entry Step 23 In this example, you will create a statistical entry using the statistical account 999903, which is the Floor Space account. Entering a statistical account code in the Account field will make this a statistical journal. An account is designated as Statistical on the Account page. Click in the Account field.

Creating a Statistical Journal Entry Step 24 Enter the desired information into the Account field. Enter "999903".

Creating a Statistical Journal Entry Step 25 In this example, 11000 is the department code for Information Services. Click in the Dept field.

Creating a Statistical Journal Entry Step 26 Enter the desired information into the Dept field. Enter "11000".

Creating a Statistical Journal Entry Step 27 Click in the Stat Amt field.

Creating a Statistical Journal Entry Step 28 In this example, the Information Services department occupies 10, 000 square feet of area in the building. Enter the desired information into the Stat Amt field. Enter "10000".

Creating a Statistical Journal Entry Step 29 The unit of measure (UOM) in this example is square feet, which is represented by the code SF in the UOM field. When you tab out or add a new line, the system automatically enters the associated unit of measure code for the statistical account.

Creating a Statistical Journal Entry Step 30 Next, enter details for the Public Affairs department. Click the Insert Lines button.

Creating a Statistical Journal Entry Step 31 Enter the statistical account 999903 in the Account field. Enter the desired information into the Account field. Enter "999903".

Creating a Statistical Journal Entry Step 32 Click in the Dept field.

Creating a Statistical Journal Entry Step 33 The department code for Public Affairs is 12000. Enter the desired information into the Dept field. Enter "12000".

Creating a Statistical Journal Entry Step 34 You must enter the square footage occupied by Public Affairs. Click in the Stat Amt field.

Creating a Statistical Journal Entry Step 35 Enter the desired information into the Stat Amt field. Enter "2000".

Creating a Statistical Journal Entry Step 36 Edit and post the statistical journal. Statistical journals do not need to be balanced entries because they are not financial in nature. Click the Process button.

Creating a Statistical Journal Entry Step 37 Click the OK button.

Creating a Statistical Journal Entry Step 38 After verifying that the Journal Status (and the Budget Status if Commitment Control is enabled) is V (valid), you can post the journal.

Creating a Statistical Journal Entry Step 39 Click the Process list.

Creating a Statistical Journal Entry Step 40 Click the Post Journal list item.

Creating a Statistical Journal Entry Step 41 Click the Process button.

Creating a Statistical Journal Entry Step 42 Click the OK button.

Creating a Statistical Journal Entry Step 43 After the Journal Status is P (posted), review the journal that was just created. Click the General Ledger menu.

Creating a Statistical Journal Entry Step 44 Click the Review Financial Information menu.

Creating a Statistical Journal Entry Step 45 Click the Journals menu.

Creating a Statistical Journal Entry Step 46 Click the Add a New Value tab.

Creating a Statistical Journal Entry Step 47 Enter the desired information into the Inquiry Name field. Enter "RENTSTATS".

Creating a Statistical Journal Entry Step 48 Click the Add button.

Creating a Statistical Journal Entry Step 49 Use the Journal Inquiry page to review summary and detail journal information for a specific business unit, ledger, and period.

Creating a Statistical Journal Entry Step 50 Use the Unit field to enter the business unit for which you want to view summary and detail journal information. Enter the desired information into the Unit field. Enter "US 005".

Creating a Statistical Journal Entry Step 51 Use the Ledger field to enter the ledger for which you want to review summary and detail journal information. A ledger is a set of posted balances that represents a set of books for a business unit. Click in the Ledger field.

Creating a Statistical Journal Entry Step 52 Enter the desired information into the Ledger field. Enter "LOCAL".

Creating a Statistical Journal Entry Step 53 Use the Year field to enter the fiscal year for which you want to view summary and detail journal information. Click in the Year field.

Creating a Statistical Journal Entry Step 54 Enter the desired information into the Year field. Enter "2013".

Creating a Statistical Journal Entry Step 55 Use the From Period and To Period fields to enter the period within the fiscal year for which you want to review summary and detail journal information.

Creating a Statistical Journal Entry Step 56 Click in the From Period field.

Creating a Statistical Journal Entry Step 57 Enter the desired information into the From Period field. Enter "1".

Creating a Statistical Journal Entry Step 58 Click in the To Period field.

Creating a Statistical Journal Entry Step 59 Enter the desired information into the To Period field. Enter "12".

Creating a Statistical Journal Entry Step 60 Click the Search button.

Creating a Statistical Journal Entry Step 61 Click the RENTSTATS menu.

Creating a Statistical Journal Entry Step 62 The Journal Inquiry Details page displays header, currency, and line information for the journal.

Creating a Statistical Journal Entry Step 63 Review the Journal Header information.

Creating a Statistical Journal Entry Step 64 Review the Journal Line information. Click the horizontal scrollbar.

Creating a Statistical Journal Entry Step 65 Note the amounts that appear in the Statistic Amount fields.

Creating a Statistical Journal Entry Step 66 You have successfully created a statistical journal. End of Procedure.