Used to select one or more Fiscal Periods, as configured in the Fiscal Periods master file. This is a multi-select standard lookup that is not required to return results. It defaults as blank.

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 lookup contains a list of all Fiscal Periods.

Used to select one or more Fiscal Years. This is a multi-select standard lookup that is not required to return results. It defaults as the current year.

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.

The lookup contains a list of all Fiscal Years.

Used to select a single GL Date or GL Date range. For a single GL Date, all GL Dates occurring on or before the specified date will be included. This is a date range editor that is not required to return results. It defaults as blank.

Identifies the date the transaction posted (or will post) to the general ledger. 

A non-required text box that defaults to blank and is used to search across multiple fields. When the page is 'Refreshed', the data returned will be limited by what was included in the Search box (in addition to any other Search Options). 

Refer to this FAQ for advanced search options.

The Search field can be used to search across the following fields: 

• Journal ID. Search for all or part of a Journal ID.
• Journal ID Range. Search for a range of Journal IDs (e.g. "25130:25150” to return all Journal Entries between "25130" and "25150").

Displays the saved searches lookup and related icons. This tool allows users to select previously saved search options, create a new set of search options, save changes to existing search options, forget/delete saved search options and/or assign a saved search option as the default for the page. Once changes are made to the search options, the user can click the Save Options icon and save the changes. Saving search options will also save the preferences for 'Auto Refresh on Open' and 'Auto Hide Filters'. The new search option can also be set as the default.  Default searches can be removed by clicking the 'Set as Default' button again when the current default search is selected.  

Refer to this FAQ for advanced search options.

 Displays a drop down menu of related actions. The list of options includes:

• RV: Journal. Opens the Journal Entry Record View.
• RV: Source Transaction. Opens the Record View of the Source Transaction.
• Reverse/Correct. Opens the Reverse/Correct page and allows the user to either Reverse or Reverse & Correct a journal entry.

 Re-queries the contents of the grid/page based on the Search Options or the default values for grids that do not support Search Options. 

 This ONLY re-queries the contents of columns that are currently visible, if you add a new column the contents will be empty until you click 'Refresh' again.

Identifies the Period on a Fiscal Calendar. This can be edited from the 'Period Name' field on the Fiscal Periods master file.

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. 

Database Field: ERPx_MFFiscalPeriod.PeriodName

Identifies the Year on a Fiscal Calendar. This is a system assigned value and cannot be edited.

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.

Database Field: ERPx_MFFiscalYear.FiscalYear

Identifies the Functional Area where the Journal ID originated.

Functional Areas represent the collection of Transactions, Master Files, Inquires, and Reports that pertain to unique areas of operations within the software. The Functional Areas include: 

• Software Application Functional Areas:
  • CO - Company
  • SY - System
• Core Functional Areas:
  • GL - General Ledger / Financial
  • A/P - Accounts Payable & Purchase Order
  • A/R - Accounts Receivable / Sales Order
  • IN - Inventory

• Specialty Functional Areas: 
  • FA - Fisherman Accounting
  • GA - Grower Accounting
  • LM - Load Management
  • PR - Payroll
  • PT - Portal
  • SP - Sales Programs (Brokerage, Rebate, Off Invoice)

Identifies the Transaction Type of the transaction that created the Journal Entry. 

Transaction Types are used to differentiate unique types transactions within the system. Transactions with the same Transaction Type share the same record view pages and business rules. Transaction Types can be further classified using Transaction Classes. Every transaction in the system is assigned a Transaction Type.

Database Field: ERPx_GLJournalHeader.SourceTransactionTypeName