|
Dave: You certainly have a challenge. The Debits should equal the Credits within each Period and within each Journal Number that has been posted. If they balanced at some point in the past, then they ought to balance now. As DeeDee pointed out, the GGM Buckets of GPDx and GPCx are positional and are tied to specific Periods in Next Year, This Year, and Last Year. The other thing to look at is the Period Master (GPM) File. This file maintains the relationship between Fiscal Year/Period and the corresponding GGM Bucket into which the Journal Dollar Amount is to be posted. There is a hidden field (so use Query to look at the file) that contains the Bucket Number (1-6, 7-20, or 21-34) for each Fiscal Year/Period. You want to confirm that these values are set correctly. The calculation of these Bucket Numbers is based on the Current Fiscal Year in the Company Master File. That is, if someone goes into the Company Master and manually changes the value of the Current Fiscal Year, the GPM Bucket Values will be recalculated which in turn would post Journal Dollars into a different Bucket. The way I would approach this problem is as follows: 1. Check the Company Master for the value of Current Fiscal Year 2. Check the Period Master (GPM) and verify that the hidden Bucket Number is pointing to the correct GGM Bucket Number. 3. You said that the Trial Balance is out-of-balance for specific Periods. So, within each of these Periods, create a Query to sort/summarize the G/L Dollar Value by Journal Number. You are looking for specific Journals where the Total of the Dollars are not equal to 0. This process should help you narrow down which specific Journals are out-of-balance. 4. Once you identify the Journal Numbers, then you can try to tie them back to the sub-systems that produced these Journals. 5. I would also check the GJW File to see if there are any remaining unposted Transactions for these out-of-balance Journals. 6. You may also want to look for G/L Accounts that do not equal the corresponding Journal Detail (GJD) values. To do this, you can write a Query to sort/summarize the GJD File by Year/Period/Co/PC/Account, but you will need to separate the amounts by Debit (i.e. >0) and Credit (<0). From these workfiles, compare the Total to the corresponding GGM Bucket for the Year/Period/Co/PC/Account. The Debits should equal the GPDx value and the Credits should equal the GPCx value. I would expect that the process that I have outlined above should help you identify where the problems are. Based on what you find, there will be other things that you will then need to investigate. Figuring out these types of problems can be quite puzzling and time-consuming, but they usually can be figured out. Over the years, I have had to do this several times for various clients. I hope that these suggestions will help you. Should you need other suggestions or help, please feel free to contact me off-line. Good Luck! Les Mittman lmittman@xxxxxxxxxxxxx ----- Original Message ----- From: <daparnin@xxxxxxxxxxxxxx> To: "SSA's BPCS ERP System" <bpcs-l@xxxxxxxxxxxx> Sent: Wednesday, March 22, 2006 1:42 PM Subject: Re: [BPCS-L] G/L Master fields? > Thanks DeeDee. I never would have guessed it on my own. I'm trying to > help the accounting people figure out why debits don't equal credits on the > Trial Balance report for several months from last year (which hasn't been > closed yet) when they did a couple of months ago. It looks like that > report is getting it's totals from these fields but nothing was matching > and I couldn't figure it out. I still don't see anything that matches but > hopefully this will get us a little closer. > > Dave Parnin > -- > Nishikawa Standard Company > Topeka, IN 46571 > daparnin@xxxxxxxxxxxxxx > > "DeeDee Virgei" > > <DeeDee.Virgei@xxxxxxxxxxxxxx> To: > "SSA's BPCS ERP System" <bpcs-l@xxxxxxxxxxxx> > Sent by: cc: > > bpcs-l-bounces+daparnin=niscoseals.com@m Subject: > Re: [BPCS-L] G/L Master fields? > idrange.com > > 03/22/2006 02:15 PM > > Please respond to "SSA's BPCS ERP > > System" > > Where on 4.05CD, but I believe this works the same for all other > releases... > > 1-6 is next fiscal year (GPD1, GPD2,... GPC1, GPC2,...) > 7-20 is current fiscal year > 21-34 is last fiscal year > > Regards, > > DeeDee Virgei > Project Leader > > Nelson Stud Welding, Inc. > > -----Original Message----- > From: bpcs-l-bounces+deedee.virgei=nelsonstud.com@xxxxxxxxxxxx > [mailto:bpcs-l-bounces+deedee.virgei=nelsonstud.com@xxxxxxxxxxxx] On > Behalf Of daparnin@xxxxxxxxxxxxxx > Sent: Wednesday, March 22, 2006 2:08 PM > To: bpcs-l@xxxxxxxxxxxx > Subject: [BPCS-L] G/L Master fields? > > BPCS Version 4.02 > > Can anybody explain to me how the "period" fields in the G/L Master file > (GGM) work? Specifically, the GPDx and GPCx debit and credit fields. > There are 34 of each. We operate on 12 fiscal periods per year yet > there is data in pretty much all 34 of them. Is it a rolling 12 months? > We are currently in period 3 of 2005 but if I wanted to find the debit > and credit balances of period 8 (August) of 2005 would that be in > GPD8/GPC8 or somewhere else? So far I can't make sense of them. > Thanks. > > > Dave Parnin > -- > Nishikawa Standard Company > Topeka, IN 46571 > daparnin@xxxxxxxxxxxxxx >
As an Amazon Associate we earn from qualifying purchases.
This mailing list archive is Copyright 1997-2024 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].
Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.
midrange.com
