IBM Support

Financial Transactions Require an Active Financial Period.

Question & Answer


Question

Is there a reason I get the error "the date is not within a valid financial period"?

Answer

Currently in Maximo version 6 and version 7 excluding 7.1.1.6, the financial period start and period end have a current Maxtype of date. This field is defined as a date field which means that as soon the end date is reached the financial period would no longer be active. An example of this would be a period from 04/01/10 to 04/30/10. With the end date being the 30th, you would be unable to enter financial transactions as the period is now closed.

In some cases it may be necessary to add a specific time for the period close, such as 12:00 AM on the end period end date. To configure the financial period end at a specific time on the end date, you would need to change the Maxtype from a "Date" type to a "DateTime" type. This change will require an update to the database directly as the fields in question can not be changed via the Data Base Configuration application. Here's an example of the SQL query that can be used to make the needed change:




          1. update maxattributecfg set changed='Y',maxtype='DATETIME' where objectname='FINANCIALPERIODS' and maxtype='DATE' and (attributename='PERIODSTART' or attributename='PERIODEND');


                  update maxobjectcfg set changed='A' where objectname='FINANCIALPERIODS';

          2. Run a database configuration for the changes to be applied to the necessary tables.

Now go back to the Financial Period and set the date / time for the period to end. For example 04/01/10 (start time here) to 04/30/10 (end time here).

[{"Product":{"code":"SSLKT6","label":"IBM Maximo Asset Management"},"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Component":"Chart of Accounts","Platform":[{"code":"PF002","label":"AIX"},{"code":"PF016","label":"Linux"},{"code":"PF027","label":"Solaris"},{"code":"PF033","label":"Windows"}],"Version":"Version Independent","Edition":"All Editions","Line of Business":{"code":"LOB59","label":"Sustainability Software"}}]

Document Information

Modified date:
17 June 2018

UID

swg21429746

Page Feedback