Dates and Periods

You can specify how the system selects records by date. For all of the date options, if you do not specify the through period and year, the system uses the current period and year of the company. If the job extends over multiple companies, then the system uses the current period and year of the first company that the system locates.

You can specify one of these options:

  • Inception to Date

    Select the Inception to Date option to view job or project accounts through the period and year or date that you specify. When you select this option, the system includes the balance forward amount from the previous year.

    Select the Period/Date check box to use full periods for the thru date. When you select the Period/Date check box, you can specify the ending period and year in the Thru Period, and Thru Fiscal Year fields. The system retrieves balances for the period and year that you specify, and then accumulates period balances for period 1 through the period and year that you specify, and adds the balance forward amount from the previous year.

    Clear the Period/Date check box to use a specific date. When you clear the check box, you can specify the ending date in the Thru Date field. The system retrieves balances for the date that you specify, and then accumulates the amounts from the beginning balances and prior year-end net posting fields through the date that you specify. The specific date applies to only the AA and AU ledgers. All other ledger amounts are retrieved for the full period.

    The Inception to Date option is the default option.

  • Year to Date

    Select the Year to Date option to view job or project accounts through the period and year or date that you specify.

    Select the Period/Date check box to use full periods for the thru date. When you select the Period/Date check box, you can specify the ending period and year in the Thru Period and Fiscal Year fields. The system retrieves balances for the period and fiscal year that you specify, and then accumulates period balances for period 1 through the thru period and year that you specify.

    Clear the Period/Date check box to use a specific date. When you clear the check box, you can specify the ending date in the Thru Date field. The system retrieves balances for the date that you specify, and then accumulates period balances for period 1 through the date that you specify. The specific date applies to only the AA and AU ledgers. All other ledger amounts are retrieved for the full period.

  • Period

    Select the Period option to view records for the date range that you specify. You can use this option to specify a time period that extends over multiple years.

    Select the Period/Date check box to use full periods for the beginning and ending dates. When you select the Period/Date check box, you can specify the beginning and ending periods and years by completing the From Period, From Fiscal Year, Thru Period and Thru Fiscal Year fields. The system retrieves balances from the beginning period and year that you specify through the ending period and year that you specify.

    Clear the Period/Date check box to use specific dates. When you clear the Period/Date check box, you can complete the From Date and Thru Date fields. The system retrieves balances beginning with the date in the From Date field through the date in the Thru Data field. The specific date applies to only the AA and AU ledgers. All other ledger amounts are retrieved for the full period.

Note: For accounts in ledger types AA (actual amounts) and AU (actual units) only, the system uses the value in the G/L Posted Code field along with the values in the date fields to determine which records to include in the data selection. See G/L Posted Code.