Re: Problem transferring account balances for new year

[ANTHONY_JACKSON@xxxxxxxxxxxxxx]

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

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

TONY JACKSON
BPCS Support
DCS Industry Solutions
Caledonia  House,          Office  :         +44  (0) 113 2043300        Email :
         ANTHONY_JACKSON@dcsgroup.co.uk
Lawnswood  Business  Park,  Facsimile  :    +44  (0)  113 2043333     Web Site :
www.dcsgroup.co.uk
Leeds, LS16 6QY          Mobile :
United Kingdom.
The information contained in this electronic mail message is confidential. It is
intended  solely for the use of the individual or entity to whom it is addressed
and  others  authorised  to receive it. If the reader of this message is not the
intended recipient, you are hereby notified that any use, copying, dissemination
or disclosure of this information is strictly prohibited.

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