Re: Unexplained Trial Balance Values

Dave:



One more interesting observation. Bob Kohlndorfer did a test and found that
on V4, the Period Master Maintenance does in fact create the situation that
you report where Year 2013 has incorrect Period Offset Arrays. I just tried
it too on a BPCS V4.02 system and got the same results.

I selected F15=Copy from 2012 to 2013.



Rcd Co Fisc Pd Start End Prd Arry

Id Year Date Date Opn Off.

PM 1 2013 1 2013/01/01 2013/01/31 Y 1

PM 1 2013 2 2013/02/01 2013/02/28 Y 2

PM 1 2013 3 2013/03/01 2013/03/31 N 3

PM 1 2013 4 2013/04/01 2013/04/30 N 4

PM 1 2013 5 2013/05/01 2013/05/31 N 5

PM 1 2013 6 2013/06/01 2013/06/30 N 6

PM 1 2013 7 2013/07/01 2013/07/31 N 7

PM 1 2013 8 2013/08/01 2013/08/31 N 8

PM 1 2013 9 2013/09/01 2013/09/30 N 9

PM 1 2013 10 2013/10/01 2013/10/31 N 10

PM 1 2013 11 2013/11/01 2013/11/30 N 11

PM 1 2013 12 2013/12/01 2013/12/31 N 12



So, the Period Master Maintenance actually allowed Year 2013 to be used for
the Copy function, it created the GPM records for 2013, and it incorrectly
set the Period Offset Array values to equal the Period Numbers as shown
above.



This situation does not explain the data problems that you are reporting,
but it does explain how the incorrect Year 2013 was created.

Someone created it using the maintenance program. To me, this is a program
problem that you may wish to prevent from happening with a modification.

Otherwise, you will just have to procedurally handle it. That is, don't
create a future Fiscal Year in the Period Master.



Please let me know if you have any questions.



Thanks.



Les Mittman

847-858-5235

BPCS Consultant with over 20 years experience