× The internal search function is temporarily non-functional. The current search engine is no longer viable and we are researching alternatives.
As a stop gap measure, we are using Google's custom search engine service.
If you know of an easy to use, open source, search engine ... please contact support@midrange.com.



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



As an Amazon Associate we earn from qualifying purchases.

This thread ...


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

This mailing list archive is Copyright 1997-2024 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.