Re: GLD end 2006-March Sales GJD GJH etc. -- BPCS-L

Thanks for the reminder. Turns out we Ok there, although our environmentincludes multiple cooks. Over the weekend I opened the April period forthe first time, and I know some of the other cooks were not able to get onbecause 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 ormore of the cooks behind in their work due to this condition.

Tonite after Billing, and if no access conflicts, I will double check thisbefore 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