You are here: Ajera Help (A-Z) > Financial Statement Designer > About custom date properties

About custom date properties

You create a custom date property in the Financial Statement Designer if the standard Activity, Balance, or Cash Flow properties do not provide the time period you want. For example, the Activity property in the properties area provides information by month, quarter, or year to date, but you want information by week.

A custom date property consists of a description, beginning date, ending date, and any cash-flow options that may apply. For account balances, leave the beginning date blank. Custom account balances will not include all previous closing entries. Ajera saves custom date properties to its database, making them available in all your financial statement designs.

About other reporting dates

Custom date properties work in conjunction with the actual date entered in the Month-End Date field on the Workbook Properties sheet and with the reporting period in statement groups:

  • If the ending date of the custom date property falls before the date entered in the Month-End Date field, Ajera overrides this field and uses the custom ending date. Example

You enter October 17, 2011, as the Month-End Date, and October 10, 2011, as the custom ending date. The custom date property provides information through October 10.

  • If the ending date of the custom date property falls after the date entered in the Month-End Date field, Ajera overrides the custom ending date and uses the actual date entered in the Month-End Date field. Example

You enter October 17, 2011, as the Month-End Date, and October 24, 2011, as the custom ending date. The custom date property provides information through October 17.

  • If the ending date of the custom date property falls after the reporting period in a statement group, Ajera overrides the month-end date and provides information from the custom beginning date through the last day of the reporting period. Example

You enter October 17, 2011, as the Month-End Date; September 24, 2011, and October 24, 2011, as the custom beginning and ending dates, respectively; and September 2011 as the reporting period for the statement group. The custom date property provides information for September 24-30, 2011.

About importing

When you import a design from another database, the label for any custom date property appears in the worksheet but the beginning date, ending date, and cash-flow options are not included in the design. You must re-create the property using the same description, dates, and cash-flow options.

 

 

© 2015 Deltek Inc. All rights reserved.