Re: Problem transferring account balances for new year

["Tony Jackson" <tony@xxxxxxxxxxxxxxxxxxxx>]

opps....i mean a duplicate ghh record....

Tony Jackson
BPCS/AS400 Support Technician.
Computing Services to Industry.SSA affiliate.(DCS Group)UK.
http://www.jackocsi.karoo.net/tony.htm
http://www.dcsgroup.co.uk/companies/csi.html

-----Original Message-----
From: ANTHONY_JACKSON@dcsgroup.co.uk <ANTHONY_JACKSON@dcsgroup.co.uk>
To: BPCS-L@midrange.com <BPCS-L@midrange.com>
Date: 02 February 2000 17:35
Subject: Re: Problem transferring account balances for new year

WE HAVE DEALT WITH THIS PROBLEM BEFORE.
AND FOUND IT TO BE A DUPLICATE GLH RECORD...QUERY GLH
AND BREAK ON J/ENTRY NUMBER...SET TO SUMMARISE...AND SEND TO D/BASE
FILE....(PLACE A 'COUNT' ON RECORDS)
THEN QUERY D/BASE FILE....FOR ANY J/ENTRIES WITH A COUNT FIELD>1.
DFU THE DUPLICATE RECORD FROM GLH.
(DO NOT ASK HOW THE DUPLICATE RECORD GOT THERE IN THE FIRST PLACE,,BOTHER SSA
WITH THAT ONE).




"Mark Seaton" <maseaton@earthlink.net> on 02022000 14:06:04

Please respond to BPCS-L@midrange.com

To:   BPCS-L@midrange.com
cc:    (bcc: Anthony Jackson/North/CSI)

Subject:  Problem transferring account balances for new year




Dwight wrote:

I sure hope someone can help me out.  We are on BPCS Mixed Mode 6.0.04 on
the AS/400.  We have been live on BPCS for a little over a year now.  I am
attempting to create the beginning balances and make the retained earnings
posting.  The transfer fails and in the process monitor I have a message
that "At least one Segment must contain a value on Journal Line 0007783."
The message ID is UMG3002.  The file/server name is CEA900B.  This message
is all well and good but I cannot find any journal entry to fix.  Where does
this go?  I am in a bit of a pinch and need to get the beginning balances in
there but I cannot find out what the problem is.

Make sure your model has a journal line for each balancing point in your chart
of accounts and that the retained earnings GL natural account is specified on
each line.  Your message does not specify this but I would recommend running
transfer opening balances with the close book not checked.  I have had problems
in 6.04 with this.  I have not been able to find the journal entry in any files
when it bombs in Process Monitor.  It definitely does not hit the GHH and GLH.
No harm in re-running if you find problems in your model.

Mark