Re: GLD end 2006-March Sales GJD GJH etc. (Al Mac)

Al,

Have you tried running the G/L Posting Program?  The program name is
GLD510...

Hope this helps.....


-----Original Message-----
From: bpcs-l-bounces+mhastings=hbpi.net@xxxxxxxxxxxx
[mailto:bpcs-l-bounces+mhastings=hbpi.net@xxxxxxxxxxxx] On Behalf Of
bpcs-l-request@xxxxxxxxxxxx
Sent: Tuesday, April 04, 2006 12:00 PM
To: bpcs-l@xxxxxxxxxxxx
Subject: BPCS-L Digest, Vol 4, Issue 78

Send BPCS-L mailing list submissions to
        bpcs-l@xxxxxxxxxxxx

To subscribe or unsubscribe via the World Wide Web, visit
        http://lists.midrange.com/mailman/listinfo/bpcs-l
or, via email, send a message with subject or body 'help' to
        bpcs-l-request@xxxxxxxxxxxx

You can reach the person managing the list at
        bpcs-l-owner@xxxxxxxxxxxx

When replying, please edit your Subject line so it is more specific
than "Re: Contents of BPCS-L digest..."


*** NOTE: When replying to this digest message, PLEASE remove all text
unrelated to your reply and change the subject line so it is meaningful.

Today's Topics:

   1. Re: GLD end 2006-March Sales GJD GJH etc. (Al Mac)
   2. Re: GLD end 2006-March Sales GJD GJH etc. (Al Mac)
   3. Re: GLD end 2006-March Sales GJD GJH etc.
      (vincent.byrne@xxxxxxxxxxxx)


----------------------------------------------------------------------

message: 1
date: Tue, 04 Apr 2006 10:31:49 -0500
from: Al Mac <macwheel99@xxxxxxxxxxx>
subject: Re: [BPCS-L] GLD end 2006-March Sales GJD GJH etc.

OOPS ... I forgot to mention

We are BPCS version 405 CD thru release 02 with the Y2K BMR package
and OS/400 V5R1 on a model 170 AS/400

in which 95% of the personnel doing the BPCS job are not the same people 
who got the BPCS education, due to turn-over of personnel and other reasons.

We are not on OSG and try to exhaust all possibilities before resort to 
calling tech support.

-
Al Macintyre 




------------------------------

message: 2
date: Tue, 04 Apr 2006 10:56:22 -0500
from: Al Mac <macwheel99@xxxxxxxxxxx>
subject: Re: [BPCS-L] GLD end 2006-March Sales GJD GJH etc.

Thanks for the reminder.  Turns out we Ok there, although our environment 
includes multiple cooks.  Over the weekend I opened the April period for 
the first time, and I know some of the other cooks were not able to get on 
because over the weekend we had a condition known as "T1 line down again 
*swearword *swearword."  In fact a hypothesis I had earlier was that one or 
more of the cooks behind in their work due to this condition.

Tonite after Billing, and if no access conflicts, I will double check this 
before once again doing GLD540 for April and March.

    Fiscal Year 06

   Period    Start Date    End Date   Pd Open Y / N
      1        1/01/06      2/04/06       Y
      2        2/05/06      3/04/06       Y
      3        3/05/06      4/01/06       Y
      4        4/02/06      4/29/06       Y
      5        4/30/06      5/27/06       N
      6        5/28/06      6/24/06       N

>Al,
>
>Have you checked to assure that the fiscal period of March is open.  If
>the period is closed then the JE would remain unposted.
>
>Dan Sweeney
>
>Senior Technical Consultant
>
>PHOENIX Business Consulting, Inc.
>
>Tel: 724.836.4446 x7, Cell:  860.490.6712,
>
>E-Fax: 832-550-5144
>
>www.phoenixbcinc.com
>
>SSA GLOBAL Recognized Services Provider
>
>
>-----Original Message-----
>From: bpcs-l-bounces+dsweeney=phoenixbcinc.com@xxxxxxxxxxxx
>[mailto:bpcs-l-bounces+dsweeney=phoenixbcinc.com@xxxxxxxxxxxx] On Behalf
>Of Al Mac
>Sent: Tuesday, April 04, 2006 11:19 AM
>To: BPCS_L discussion
>Subject: [BPCS-L] GLD end 2006-March Sales GJD GJH etc.
>
>This problem
>==========
>Approx $ 150,000.00 worth of Sales data is in files GJD and GJH with
>status
>code JU (unposted) for fiscal 2006 March and this weekend was end-month
>fiscal 2006 March.  We need to figure out what needs to be done to get
>that
>posted to the GL.  This is top priority right now.
>
>There was some shipping / billing / other transactions posted Monday
>April
>3 and that ALSO is in the same unposted condition.
>
>In other words, the data has left GJW file, is now in GJH GJD with
>record
>id 'JU' and needs to move to GGM then change to 'JP'  How do we
>accomplish
>that?
>
>I am not a GLD expert.  There are many gaps in my G/L know-how..  But I
>need to get this resolved.  I am the local BPCS Guru.
>
>The assumption at the moment is that
>* We are doing something wrong or incomplete that needs to be figured
>out
>* This is not a case of a BPCS bug or something crashed
>
>Our process
>=========
>* late nite when everyone off of updating BPCS, AlMac runs INV920 then
>GLD540 for current fiscal period.  Some nites AlMac not run this, either
>if
>other people real busy late into evening, or AlMac busier than usual
>with
>some software project or whatever.
>
>Sometimes there are errors, which AlMac leave on DianeAccountingLady
>desk
>(or on printer where she knows where to find) and she does her thing to
>resolve those errors, and get the associated GL batches to a
>conclusion.  AlMac did this several nites recently, including last
>Thurs,
>last Fri, there was no one updating stuff on our system on Saturday, as
>far
>as AlMac could tell, but after this problem was brought to AlMac
>attention,
>Mon nite after completion of all shipping and billing for the day, AlMac
>
>ran INV920 again, also GLD540 for both March and April.  (There was
>stuff
>there for April but nothing for March.)
>
>* DianeAccountingLady is caught up on resolving errors from GLD540
>reports.  AlMac not know the precise GLD programs she uses for this ...
>AlMac have never needed to know before, because everything was running
>hunky dory
>
>* After AlMac announce to management that I got done with EOM (which I
>worked on from Fri nite thru Sunday afternoon, with several in between
>naps) other people run with the derived data.
>
>* DaveTheBoss discovered an approx $150,000.00 discrepancy between total
>
>sales reports and what the G/L had for total sales for 2006 March
>
>* While trying to resolve this, AlMac found approx $ 10,000.00
>discrepancy
>between different ways of looking at sales for the month, which AlMac
>believe are related to RMAs, Discounts (Terms), and Freight charges
>
>Other clues
>=========
>RMAs get entered to our system the DATE the stuff comes back from
>customer,
>but it may be a month or so later before everything resolved, and the
>Billing finalized (credit the customer HOW MUCH, actually get the
>problem
>repaired) ... let's suppose it came back December, and was resolved
>March
>... the stuff gets "posted" in December, even though it is finalized in
>March.  Let's suppose by this time we have closed year 2005 fiscal.
>Well
>in that case we just *censored ourselves.
>
>-
>Al Macintyre
>http://en.wikipedia.org/wiki/User:AlMac
>http://www.ryze.com/go/Al9Mac
>BPCS/400 Computer Janitor ... see
>http://radio.weblogs.com/0107846/stories/2002/11/08/bpcsDocSources.html
>--
>This is the SSA's BPCS ERP System (BPCS-L) mailing list
>To post a message email: BPCS-L@xxxxxxxxxxxx
>To subscribe, unsubscribe, or change list options,
>visit: http://lists.midrange.com/mailman/listinfo/bpcs-l
>or email: BPCS-L-request@xxxxxxxxxxxx
>Before posting, please take a moment to review the archives
>at http://archive.midrange.com/bpcs-l.
>
>Delivered-To: dsweeney@xxxxxxxxxxxxxxxx
>
>--
>This is the SSA's BPCS ERP System (BPCS-L) mailing list
>To post a message email: BPCS-L@xxxxxxxxxxxx
>To subscribe, unsubscribe, or change list options,
>visit: http://lists.midrange.com/mailman/listinfo/bpcs-l
>or email: BPCS-L-request@xxxxxxxxxxxx
>Before posting, please take a moment to review the archives
>at http://archive.midrange.com/bpcs-l.
>
>Delivered-To: macwheel99@xxxxxxxxxxx




------------------------------

message: 3
date: Tue, 4 Apr 2006 17:40:57 +0100
from: vincent.byrne@xxxxxxxxxxxx
subject: Re: [BPCS-L] GLD end 2006-March Sales GJD GJH etc.

GLD End of Period Routines
After all postings completed:-
GLD310 to list journals with status Error or Unposted (if any)
GLD500 to view and correct any journal with status Error as indicated in 
previous step. Status then changes to Unposted
GLD510 to post all Unposted.
GLD310 again to unsure there are no remaining Journals with status Error 
or Unposted
GLD200 Report should also be zero
GLD105 Close Period


Vincent







Al Mac <macwheel99@xxxxxxxxxxx>
Sent by: bpcs-l-bounces+vincent.byrne=novartis.com@xxxxxxxxxxxx
04/04/2006 16:19
Please respond to "SSA's BPCS ERP System"

 
        To:     "BPCS_L discussion" <bpcs-l@xxxxxxxxxxxx>
        cc:     (bcc: Vincent Byrne/AH/Novartis)
        Subject:        [BPCS-L] GLD end 2006-March Sales GJD GJH etc.


This problem
==========
Approx $ 150,000.00 worth of Sales data is in files GJD and GJH with 
status 
code JU (unposted) for fiscal 2006 March and this weekend was end-month 
fiscal 2006 March.  We need to figure out what needs to be done to get 
that 
posted to the GL.  This is top priority right now.

There was some shipping / billing / other transactions posted Monday April 

3 and that ALSO is in the same unposted condition.

In other words, the data has left GJW file, is now in GJH GJD with record 
id 'JU' and needs to move to GGM then change to 'JP'  How do we accomplish 

that?

I am not a GLD expert.  There are many gaps in my G/L know-how..  But I 
need to get this resolved.  I am the local BPCS Guru.

The assumption at the moment is that
* We are doing something wrong or incomplete that needs to be figured out
* This is not a case of a BPCS bug or something crashed

Our process
=========
* late nite when everyone off of updating BPCS, AlMac runs INV920 then 
GLD540 for current fiscal period.  Some nites AlMac not run this, either 
if 
other people real busy late into evening, or AlMac busier than usual with 
some software project or whatever.

Sometimes there are errors, which AlMac leave on DianeAccountingLady desk 
(or on printer where she knows where to find) and she does her thing to 
resolve those errors, and get the associated GL batches to a 
conclusion.  AlMac did this several nites recently, including last Thurs, 
last Fri, there was no one updating stuff on our system on Saturday, as 
far 
as AlMac could tell, but after this problem was brought to AlMac 
attention, 
Mon nite after completion of all shipping and billing for the day, AlMac 
ran INV920 again, also GLD540 for both March and April.  (There was stuff 
there for April but nothing for March.)

* DianeAccountingLady is caught up on resolving errors from GLD540 
reports.  AlMac not know the precise GLD programs she uses for this ... 
AlMac have never needed to know before, because everything was running 
hunky dory

* After AlMac announce to management that I got done with EOM (which I 
worked on from Fri nite thru Sunday afternoon, with several in between 
naps) other people run with the derived data.

* DaveTheBoss discovered an approx $150,000.00 discrepancy between total 
sales reports and what the G/L had for total sales for 2006 March

* While trying to resolve this, AlMac found approx $ 10,000.00 discrepancy 

between different ways of looking at sales for the month, which AlMac 
believe are related to RMAs, Discounts (Terms), and Freight charges

Other clues
=========
RMAs get entered to our system the DATE the stuff comes back from 
customer, 
but it may be a month or so later before everything resolved, and the 
Billing finalized (credit the customer HOW MUCH, actually get the problem 
repaired) ... let's suppose it came back December, and was resolved March 
... the stuff gets "posted" in December, even though it is finalized in 
March.  Let's suppose by this time we have closed year 2005 fiscal.  Well 
in that case we just *censored ourselves.

-
Al Macintyre
http://en.wikipedia.org/wiki/User:AlMac
http://www.ryze.com/go/Al9Mac
BPCS/400 Computer Janitor ... see
http://radio.weblogs.com/0107846/stories/2002/11/08/bpcsDocSources.html