Re: Unexplained Trial Balance Values

Ignore what I said, where in any way it conflict with Les Mittman comments,
which are vastly superior to mine.
I had not yet seen his post, when I shot off my mouth.

I agree that it makes sense for sequencing:
1. delete fiscal year 2013
2. close fiscal year 2011
3. recreate fiscal year 2013
4. and at each step, do some checking, and consider backups.

Do you have a modification standard such that you can tell which programs
are:
* Vanilla BPCS
* Y2K modified, by whatever means
* In-house, or 3rd party, modified
* Added, which did not come with BPCS
-
Al Mac


-----Original Message-----
From: bpcs-l-bounces@xxxxxxxxxxxx [mailto:bpcs-l-bounces@xxxxxxxxxxxx] On
Behalf Of Al
Sent: Sunday, February 12, 2012 1:01 PM
To: 'BPCS ERP System'
Subject: Re: [BPCS-L] Unexplained Trial Balance Values

Not all GPM records are valid at the same time.

Until 2011 gets final close, the valid records are: all periods of 2011
(more than are shown), and first 6 periods of 2012.

Once 2011 has been final closed, the valid records will become: all periods
of 2012, and first 6 periods of 2013.

GPM should NOT be changed, except thru BPCS programs. In fact this is true
of BPCS files in general ... none of them should be changed by anyone who
does not have a good understanding of what is supposed to be happening.

-
Al Mac

-----Original Message-----
From: bpcs-l-bounces@xxxxxxxxxxxx [mailto:bpcs-l-bounces@xxxxxxxxxxxx] On
Behalf Of Peter Lunde
Sent: Sunday, February 12, 2012 10:16 AM
To: BPCS List
Subject: [BPCS-L] Unexplained Trial Balance Values


There are two things I don't understand about this thread:

1. How can there be 36 records in the Period Master (GPM) when there are
only 34 buckets in the G/L Master (GGM)?

2. Why is it OK to have 2 GPM records pointing to the same GGM bucket?
Wouldn't we want to fix these problems before doing the final close? Isn't
it dangerous to do a final close with these to problems in the database?
That is, in the GPM, I would change 2012 7 thru 2012 12 to point to 19 thru
24 and delete 2013. Your comments please. Regards, Peter Lunde, BASC, MBAIT
ManagerWellSpring Pharmaceutical400 Iroquois Shore RdOakville ONCanada
L6H1M5plunde at WellSpringPharm dot CABPCS 4.05 CD >
----------------------------------------------------------------------

message: 1
date: Fri, 10 Feb 2012 15:18:27 -0500
from: daparnin@xxxxxxxxxxxxxx
subject: Re: [BPCS-L] Unexplained Trial Balance Values

There don't appear to be any. We have done inquiries for the account
listed on the trial balance report and it says that there are no
transactions. I'm thinking that the debit and credit values are leftovers

in the GGM becuase we haven't done the final close of 2011 yet. Accounting

says that we can wait until it is closed to see if that takes care of
things.

PM 1 2,011 1 20,110,101 20,110,131 N 7
PM 1 2,011 2 20,110,201 20,110,228 N 8
PM 1 2,011 3 20,110,301 20,110,331 N 9
PM 1 2,011 4 20,110,401 20,110,430 N 10
PM 1 2,011 5 20,110,501 20,110,531 N 11
PM 1 2,011 6 20,110,601 20,110,630 N 12
PM 1 2,011 7 20,110,701 20,110,731 N 13
PM 1 2,011 8 20,110,801 20,110,831 N 14
PM 1 2,011 9 20,110,901 20,110,930 N 15
PM 1 2,011 10 20,111,001 20,111,031 N 16
PM 1 2,011 11 20,111,101 20,111,130 N 17
PM 1 2,011 12 20,111,201 20,111,231 N 18
PM 1 2,012 1 20,120,101 20,120,131 N 1
PM 1 2,012 2 20,120,201 20,120,229 Y 2
PM 1 2,012 3 20,120,301 20,120,331 N 3
PM 1 2,012 4 20,120,401 20,120,430 N 4
PM 1 2,012 5 20,120,501 20,120,531 N 5
PM 1 2,012 6 20,120,601 20,120,630 N 6
PM 1 2,012 7 20,120,701 20,120,731 N
PM 1 2,012 8 20,120,801 20,120,831 N
PM 1 2,012 9 20,120,901 20,120,930 N
PM 1 2,012 10 20,121,001 20,121,031 N
PM 1 2,012 11 20,121,101 20,121,130 N
PM 1 2,012 12 20,121,201 20,121,231 N
PM 1 2,013 1 20,130,101 20,130,131 N 1
PM 1 2,013 2 20,130,201 20,130,228 N 2
PM 1 2,013 3 20,130,301 20,130,331 N 3
PM 1 2,013 4 20,130,401 20,130,430 N 4
PM 1 2,013 5 20,130,501 20,130,531 N 5
PM 1 2,013 6 20,130,601 20,130,630 N 6
PM 1 2,013 7 20,130,701 20,130,731 N 7
PM 1 2,013 8 20,130,801 20,130,831 N 8
PM 1 2,013 9 20,130,901 20,130,930 N 9
PM 1 2,013 10 20,131,001 20,131,031 N 10
PM 1 2,013 11 20,131,101 20,131,130 N 11
PM 1 2,013 12 20,131,201 20,131,231 N 12

Dave Parnin