Incorrect Date Pattern consequences
We are a company that uses AR / AP / GL and Distribution in JDE 8.10.
We have come across a fairly interesting problem. Below you will find our problem and a patch work solution we are calling it. I would appreciate any comments from JDE folks to understand if our approach is sound.
Problem: Date Patterns month end for June was setup incorrectly as 6/03/2010 instead of 7/03/2010
Information: May ends on 05/29/2010, June ends on 07/03/2010, July ends on 07/31/2010
Consequence: On June 4th, Period Number fields reflect 7 instead of 6 because of the setup problem
Solution:
Part 1 - Correct Date Patterns
Part 2 - Correct via SQL, F0911, F03B11, F03B13, F03B14, F0411, F0413, F0414 using SQL Update statement on database for Fiscal Year 10, where Period # is NOT 6 and GL Date range is between 05/29/2010 and 07/03/2010
We have come across a fairly interesting problem. Below you will find our problem and a patch work solution we are calling it. I would appreciate any comments from JDE folks to understand if our approach is sound.
Problem: Date Patterns month end for June was setup incorrectly as 6/03/2010 instead of 7/03/2010
Information: May ends on 05/29/2010, June ends on 07/03/2010, July ends on 07/31/2010
Consequence: On June 4th, Period Number fields reflect 7 instead of 6 because of the setup problem
Solution:
Part 1 - Correct Date Patterns
Part 2 - Correct via SQL, F0911, F03B11, F03B13, F03B14, F0411, F0413, F0414 using SQL Update statement on database for Fiscal Year 10, where Period # is NOT 6 and GL Date range is between 05/29/2010 and 07/03/2010
0