Error message when you click Year and then you click Reconcile in the Reconcile Financial Information window in Microsoft Dynamics GP: "A transaction does not fall within an existing fiscal year"

Symptoms
In Microsoft Dynamics GP or in Microsoft Business Solutions - Great Plains, you click Year and then you click Reconcile in the Reconcile Financial Information window. When you do this, you receive the following error message:

A transaction does not fall within an existing fiscal year. Use the Fiscal Period Setup window to enter consecutive years. Then reconcile again.
Cause
This problem occurs when the date of a General Ledger journal entry falls outside dates that are set up in the Fiscal Period Setup window.
Resolution
To resolve this problem, use one of the following methods.

Method 1

To resolve this problem, follow these steps to verify all the correct fiscal years exist and no dates are skipped: 
  1. Open the Fiscal Periods Setup window. To do this, point to Tools on the Microsoft Dynamics GP menu, point to Setup, point to Company, and then click Fiscal Periods.
  2. In the Fiscal Periods Setup window, verify that consecutive fiscal periods are configured to have no days that are excluded from open fiscal periods or from historical fiscal periods. Verify no dates are skipped between periods for all years.

Method 2

To resolve this problem, follow these steps to identify any transaction dates in which the fiscal year does not exist.

a. Determine whether a transaction date falls outside the configured fiscal years. In SQL Server Management Studio, click New Query, and then run the following script against the company database to find any transaction dates on journal entries that fall outside the existing fiscal year date ranges:
select * from GL30000 a left join SY40101 b on a.HSTYEAR = b.YEAR1 where a.TRXDATE not between b.FSTFSCDY and b.LSTFSCDY and a.SOURCDOC not in ('BBF','P/L')select * from GL20000 a left join SY40101 b on a.OPENYEAR = b.YEAR1 where a.TRXDATE not between b.FSTFSCDY and b.LSTFSCDY and a.SOURCDOC not in ('BBF','P/L')
b. Next, if GL history has been removed, the first historical year may contain a BBF or P/L entry dated the last day of the prior year, and that year no longer exists. This scenario will cause the above message to happen when Reconcile is performed on the historical year. Execute the scripts below to identify the lowest and highest transaction dates in the GL tables, and verify that fiscal years exist that contain the dates returned. 

select MIN(Trxdate) from GL30000select MAX(Trxdate) from GL30000select MIN(Trxdate) from GL20000select MAX(Trxdate) from GL20000


 
c.  Reconfigure the fiscal year dates

If the transaction falls outside the configured fiscal years, perform one of the following actions:
  • Option 1- Create fiscal years for the dates of the transactions.
  • Option 2 - Delete the transactions that fall outside the fiscal years. Then, reenter the transactions together with current fiscal year dates.
For more information about how to create fiscal years or deleting transactions that fall outside the fiscal years, contact Technical Support for Microsoft Dynamics and for related products. You can log on to the Microsoft Dynamics site and create a new support request. To do this, visit the following Microsoft Web site: You can also contact Technical Support for Microsoft Dynamics and related products by telephone at (888) 477-7877.
Properties

Article ID: 943030 - Last Review: 05/27/2016 17:53:00 - Revision: 6.0

Microsoft Dynamics GP 2016, Microsoft Dynamics GP 2015, Microsoft Dynamics GP 2013, Microsoft Dynamics GP 2010, Microsoft Dynamics GP 10.0, Microsoft Dynamics GP 9.0

  • kbnosurvey kberrmsg kbexpertisebeginner kbtshoot kbmbsmigrate kbprb kbexpertiseinter KB943030
Feedback