Fiscal Periods List View
- Tom Williams
A Fiscal Year is a one-year period that companies use for financial reporting and budgeting. A Fiscal Year is most commonly used for accounting purposes to prepare financial statements. Fiscal Years often start on January 1st and end on December 31st. However, not all Fiscal Years correspond with the calendar year. For example, a company may run their Fiscal Year from May 1st - April 30th. Once a Fiscal Year has been determined, it is unlikely to ever change outside of a company sale and/or merger.
Fiscal Periods represent budgetary or accounting periods that fall within Fiscal Years. These often match the calendar where there are 12 periods, matching the calendar months. In organization where the fiscal year does not match the calendar year, Fiscal Periods may or may not match the number of days in a calendar month. Every transaction that posts to the general ledger contains a 'GL Date' and that date identifies both the Fiscal Year and Fiscal Period the transaction was posted to the general ledger in.
The purpose of this page is to show all the Fiscal Years that have been setup and allow users to drill down to the the Fiscal Periods that belong to a Fiscal Year. From here, users can open a Fiscal Year to update which Fiscal Periods are open and can run or reverse a Year-End Close.
Software Version: 2019.09.03 and newer
Page Header
| Toolbar Icons | Description |
|---|---|
| Delete | Deletes the selected record(s). When clicked, users will be prompted with: "Are you sure you want to delete the selected records?". Click "OK" to confirm, or "Cancel" to return without deleting. WARNING: Records cannot be recovered once they are deleted!
|
| Edit | Opens the selected record for editing. If a record is not selected, the page will not open. |
| Excel |  Clicking the Excel toolbar icon exports the current contents of the grid to an Excel file that is automatically downloaded. The contents that export are only those currently visible. If the grid is filtered, only the filtered contents will be exported. |
| Favorites |   Clicking on the star icon when it is an outline, adds the page to the 'My Shortcuts' tab and fills in the star. Clicking on the star icon when it is filled in (solid color), removes the page from the 'My Shortcuts' tab and returns the icon to an outline.
|
| Grid Layout | Opens the Saved Grid Layout menu that allows the user to select another saved layout, create a new layout, save changes to a layout, or assign a saved layout as the default for the page. Once changes are made to a grid, such as columns are added or removed, the user can click the Saved Grid Layout icon and save the changes to the grid layout and name the new layout. The new layout can also be set as the default, instead of the System View. This is useful for creating specific views to separate master files or transaction types (i.e. Invoice specific vs. Credit Memo specific).
|
| Help | Opens the online WIKI help page for the current page.
|
| New | Opens a new blank record for data entry. |
| Opens the Print dialog window, where transaction and/or analysis reports can be downloaded, printed and/or emailed. | |
| Fields | Description |
| # Open Periods | A label to show the count of all the Fiscal Periods within each year that have at least one series that is still open for posting. |
| # Periods | A label to show the count of periods within each Fiscal Year. This typically does not change from one year to the next unless the company has made an accounting change. Linked Database Field: ERPx_MFFiscalYear.NumberOfPeriods |
| End Date | The date that each Fiscal Year starts. Linked Database Field: ERPx_MFFiscalYear.FiscalYearEndDate |
| Fiscal Year | The unique identifier of the Fiscal Year. This defaults to 1 + the newest fiscal year, is required, must be unique, and must be <= 10 characters. Clicking on this hyperlink opens the Fiscal Period Record View for the year selected. Linked Database Field: ERPx_MFFiscalYear.FiscalYear |
| Start Date | The date that each Fiscal Year begins. Linked Database Field: ERPx_MFFiscalYear.FiscalYearStartDate |
| Posting Type | A label to show the status of each Fiscal Year. This value is auto-assigned each time a Year-End Close is run or reversed and each time a Fiscal Year is deleted. The potential values include:
Linked Database Field: ERPx_MFFiscalYear.FiscalYearPostingTypeEN. This lookup contains all the values in the MFFiscalYearPostingType Enumeration Class. |
You can only delete the most recent Fiscal Year.