Hi, What I understand is you want to know the entries on daily basis for all customer accounts. I think better you can use ACCT.ENT.TODAY. The id of the file is account number. But this file updates even for internal accounts so may be you can just check whether the id is numeric or not. Just consider if its numeric, and the content of the file is Multi value of STMT.ENTRY numbers. If you want to exclude you can make a filter on each STMT.ENTRY by not choosing your specified transaction codes. Now you can calculate turn over of credit / turn over of debit based on AMOUNT.LCY/AMOUNT.FCY of STMT.ENTRY.
If you want to know the future dated transactions or forward entries you can use the ACCT.ENT.FWD. This file structure is similar to ACCT.ENT.TODAY but updates only for future dated transactions. If you want to refer previsou day transacitons ACCT.ENT.LWORK.DAY. This file structure also similar to ACCT.ENT.TODAY and ACCT.ENT.FWD but it will have only transactions of previous working day. Hope this information helps you. 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 -~----------~----~----~----~------~----~------~--~---
