Hi, There is one more solution. Check the files ACCT.STMT.PRINT and STMT.PRINTED.
Just select ACCT.STMT.PRINT file and you get multi value of STMT.DATE/BAL. Form id STMT.PRINTED (Its account number - STMT.DATE from ACCT.STMT.PRINT) so you get list of STMT.ENTRY ids on that particular day. Here you can put your selection to remove your specified trnasaction details. Regards Santosh On Thu, May 7, 2009 at 2:49 PM, Igor Micev <[email protected]> wrote: > > 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 > > > > -- Mobile: 973-39406098 "Nobody can go back and start a new beginning, but anyone can start today and make a new ending" --~--~---------~--~----~------------~-------~--~----~ 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 -~----------~----~----~----~------~----~------~--~---
