Fiscal Calendar: Wrong Period Start/End Dates

Epicor ERP 10
1

Today we found that a Fiscal Calendar had the wrong Period Start/End Dates for May, June & July, no idea how it happened but May (period 5) was set to end on 5/30 and then period 6 starts on 5/31.
We restored the DB to a Test environment and did the following:

  1. Deleted period 05/2017 and all future periods (including 2018 year). A warning message stated that we would need to run the Verify Balance Records afterwards.
  2. Regenerated Periods 05-12 of 2017 and 1-12 of 2018. We also use a closing period of 13.
  3. Ran Verify Balance Records process on all three books (this is an EU company so we have a Statutory Book as the main book and then a US book for mapping to US for consolidation)
  4. No errors reported in process log.
  5. When we check an AR invoice posted on 05/31 it shows Journal entries in the 2017/13 period, not the 2017/05 period (before attempting this correction the journal entries showed in the 2017/06 period). We need the 05/31 entries to show in the 2017/05 period.

While I’m glad we tested this in a test environment, but this is still a problem and accounting needs to close out period 05 and so this is very urgent.

Epicor 10.0.700.3

2

I think when you delete the periods, you need to roll back all transactions that happened past 5/30. Anything that happened 5/31 on would have grabbed the old period at the time the transaction happened.

If you don’t want to undo all the transactions, then you could probably run an update query in SQL to fix the offending records.

3

John,
I am not familiar with the Epicor program to roll back the transactions, can you clarify?
This would have affected all transactions since the issue was on the Fiscal Period setup.

4

Test out the Automatic Transaction Reversal under GL. You will need to know the Journal IDs.

5

I will test this, but accounting doesn’t like it and might consider it if we cannot find a better way to correct this.