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 thread ...


Follow On AppleNews
Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2026 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].

Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.