Error: Post Date must be in a valid fiscal period. (RE Gift ID: #######) - when posting to a closed fiscal period

When posting or running the pre-post report from The Raiser's Edge to a soft-closed fiscal period in Financial Edge, users may receive the following error:

Post Date must be in a valid fiscal period. (RE Gift ID: #######).

Then the batch validation report and exception report are blank. 

The error is caused by an Adjustment or Reversal that is attempting to post to a closed fiscal period. 

To find the gift causing the error: 
  1. Go to Query> New Query
  2. In the Type field, select Gift. Format: Dynamic. Click OK. 
  3. On the Criteria tab, select: Gift Information> System Record ID equals XXXX 
  • The error that appears when posting lists the RE Gift ID.  this is the System Record ID, not the Gift ID.
  1. On the Output tab, select Constituent> Name 
  2. Click Run Now
The results in the query will give the gift/adjustment causing the error.  If no gift exits, a Posted gift was deleted from RE with a gift date in a closed fiscal period.  If a gift appears, open the gift record and select the Adjustment tab to view the adjustment causing the error.

If the Gift Date of the gift identified from the query is in a closed fiscal period and the Adjustment Date is in the open fiscal period, resolve by:
  1. Login to Financial Edge and navigate to Config> Fiscal Years to open the soft-closed period for the date range in which the Gift Date falls
  2. Go to Config> Post to the General Ledger and attempt to post the gifts once again
OR
  1. Open the Adjustment on the gift record 
  2. Mark the checkbox Use adjustment GL post date for the reversal GL post date
  3. Save and Close the Adjustment
  4. Go to Config> Post to the General Ledger and attempt to post the gifts once again
If the errors still continue, but there is no gift found in the query results:
  1. Remove the integration between Raiser's Edge and Financial Edge
  2. Run the post for the gifts posting to the closed fiscal periods
  3. Manually enter gifts in a Journal Entry batch as needed
  4. Re-establish the integration between Raiser's Edge and Financial Edge

Environment

 Raiser's Edge
 7.92
 Patch 9

Was this article helpful?