Hi All,
I have a task that is quite complicated, not technically but more like
not having whole data.
I have to make a report for account’s activities of the customers on
daily basis. I use ACCT.ACTIVITY table. In ACCT.ACTIVITY, Turnover
Credit and Turnover Debit are the sums I use, but in the report it is
not necessary to be taken the transactions’ amounts with transaction
codes as follows:
420 - Payment of Principal
401 - New Deposit
424 - Payment of Interest
At same time I don’t have information for the time (the date) when
those transactions (with codes 420 401 424) had been committed in the
system, in order to subtract them from the summary credit/debit
amounts for the selected day.
Any other tables, ways or suggestions to overpass this?
Thanks in advance
Igor
--~--~---------~--~----~------------~-------~--~----~
Please read the posting guidelines at:
http://groups.google.com/group/jBASE/web/Posting%20Guidelines
IMPORTANT: Type T24: at the start of the subject line for questions specific to
Globus/T24
To post, send email to [email protected]
To unsubscribe, send email to [email protected]
For more options, visit this group at http://groups.google.com/group/jBASE?hl=en
-~----------~----~----~----~------~----~------~--~---
