JBA MLRe: Blank Transaction Type in GL -- SYSTEM21

Gilbert,

I agree that the response you said GEAC gave "...GEAC once responded that this
problem is caused by the network."  is ludicrous...  An obvious attempt to blow
you off and make you go away...  I would not accept that as an answer either...

It would be most helpful if you indicated what Version / Service Pack / PTF
level you are running and whether you have any bespoke mods in the affected
application...

It sounds to me more like an *LDA corruption problem, however, I am not aware of
us ever having that problem...

I would approach GEAC help desk for your region again and see if you get a more
sympathetic response...

Is it possible that you are using some kind of external interface to load your
A/P transactions...  or are you using standard JBA...?

Good luck...









GManoovaloo@ibl.intnet.mu on 08/21/2001 02:22:58 AM

Please respond to jbausers-l@midrange.com



  To:          jbausers-l@midrange.com

  cc:          (bcc: Jeff Klipa/Harvard)



  Subject      JBA MLBlank Transaction Type in GL
  :







We have , ever since we implemented JBA Financials, noted many cases of
blank  'transaction type'  in file
FLP008.  All such cases occur only for 'Transaction source'  = A , i.e
Accounts Payable. We have, for  the current year
identified 330 such cases , in many of the JBA companies we have set up.
We have done a query report showing
among other columns, the G/l session and  G/L ctl account affected by the
source transaction.  In one case , out
of 19 a/p  journal posted in a given session, only the first one in the
generated G/L session has a valid tran type.
The remaining ones have blank tran type.   See below 2 samples of   GL sess
enquiry :
====================================================================
 GL136                    CC - **************        USER JBAMGRT
21/08/01

9:43:02
 Transaction Enquiry
 Session . . . :     869                  Session total . . :
75240.00
 Time & date . : 15:00 - 15:43  5/06/01   Total prime . . . :
141324.32
 User & terminal TOUCCMSO    CCHPC02      Transaction total :
141324.32
     Type Co  Account  Doc.ref.   Period  Doc.date Control total    Cur
     AJL   CC  CCSL6984  JNLMAY01   0105  31/05/01          3960.00
MUR
     A       CC  CCSL0043     JNLMAY02   0105  31/05/01         37794.00
     MUR
     A       CC  CCSL0004     JNLMAY03   0105  31/05/01          1691.00
     MUR
     A       CC  CCSL0137     JNLMAY04   0105  31/05/01          2200.00
     MUR
     A       CC  CCSL0044     JNLMAY05   0105  31/05/01         13653.00
MUR
     A       CC  CCSL1144     JNLMAY06   0105  31/05/01         11000.00
     MUR
     A       CC  CCSL3168     JNLMAY07   0105  31/05/01          3922.69
     MUR
     A       CC  CCISTOGT     JNLMAY08   0105  31/05/01           700.00
     MUR
     A       CC  CCSL8405     JNLMAY09   0105  31/05/01          1347.50
     MUR
     A       CC  CCISTOTS     JNLMAY10   0105  31/05/01          3454.94
     MUR
     A       CC  CCSL1144     JNLMAY11   0105  31/05/01          1500.00
     MUR
     A       CC  CCSL0109     JNLMAY12   0105  31/05/01         20359.25
     MUR
     A      CC  CCSL3766      JNLMAY13   0105  31/05/01          1700.00
     MUR
     A      CC  CCSL9159      JNLMAY20   0105  31/05/01          2904.94
     MUR
     A      CC  CCSL1144      JNLMAY21   0105  31/05/01         12168.00
     MUR
    A      CC  CCSL0004  JNLMAY22   0105  31/05/01          5574.00
MUR
    A      CC  CCSL0123  JNLMAY23   0105  31/05/01          4049.00
MUR
    A      CC  CCSL3766  JNLMAY24   0105  31/05/01          2750.00
MUR
   A       CC  CCSL0004  JMAY14-9     0105  31/05/01         10596.00
MUR
==================================================================
 GL136                       ST - ***********            USER JBAMGRT
21/08/01

10:15:13
 Transaction Enquiry
 Session . . . :   11266                  Session total . . :
64782.00
 Time & date . : 15:13 - 15:57 18/06/01   Total prime . . . :
8177.50
 User & terminal SOSBUFMO    PL02DSP06    Transaction total :
215625.42
     Type Co  Account  Doc.ref.   Period  Doc.date Control total    Cur
     AIN     ST  STSO1103 ST004501   0106  31/05/01          6478.20
USD
     AIN     ST  STSO2077 ST401028   0106  22/05/01         18535.10
EUR
     AIN     ST  STSO1127 ST090407   0106  25/05/01          3655.76
GBP
     AIN     ST  STSO1477 ST210020   0106  20/04/01         13024.86
GBP
     AIN     ST  STSO1477 ST210575   0106  30/04/01         10559.85
GBP
     A         ST  STSO1461 ST033462   0106   2/06/01        130187.70
EUR
     A         ST  STSO1461 ST033497   0106   3/06/01          4234.86
     EUR
     A         ST  STSO1461 ST034102   0106   9/06/01         12286.07
     EUR
     A         ST  STSO1461 ST034128   0106  10/06/01          4376.95
     EUR
     AIN    ST  STSO1461 ST034102   0106   9/06/01         12286.07
     EUR
An analysis of the GL sessions where the anomaly occurs reveals  that, in
most cases , the tran type
(whether  JL, IN or CR)  appears on the first  transactions and then is
blank for the rest of the session.
There are a few cases (like for company ST above) where there are  blank
occurrences in the middle
of valid tran types . Our users are geographically scattered  and work
remotely ( via TCP IP)
I would be happy to receive info on this problem , We fear this may be an
issue at year end .  Running
46/APE shows  imbalance for the given control account, but the figure
cannot be related to the amounts
with blank tran type .
GEAC once reponded that this problem is caused by the network.  This answer
is not satisfactory to us.
Gilbert

_______________________________________________
This is the GEAC/JBA System 21 Users (JBAUSERS-L) mailing list
To post a message email: JBAUSERS-L@midrange.com
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/cgi-bin/listinfo/jbausers-l
or email: JBAUSERS-L-request@midrange.com