> > Thank you for your response. We are electronically pushed information on > collection accounts from our client - such as the name of the debtor, > address, etc. in a file called ACCOUNT. ACCOUNT does not contain a history > of payments, which is very important to us. We are also pushed > transaction information in a separate file called TRANS, described above. > TRANS contains payment information (along with a lot of irrelevant noise > such as account adjustments and incremental interest), but those payments > are split to different "buckets" across accounts. For example, a $100 > payment may be split $50 to principal, $25 to interest and $25 to > collection costs. I am trying to reassemble these split transactions to > identify the $100 payment using a dictionary item, by taking each account > number and adding the actual payments (marked by a "3" in attribute 9) for > each date together in a sum. >
What you're asking for is actually pretty easy to get in a report format without any new dictionary items. Try the following, correcting any errors I've made in the dict names I've used. SORT TRANS WITH SOURCE = "3" BY ACCOUNT BY DATE BREAK-ON ACCOUNT BREAK-ON DATE TOTAL TRAN.AMT That should give you a detailed list of TRANS items with Source = "3", sorted and subtotalled by Account and Date. If you just want the totals without the detail, add the clause ID-SUPP to the end of the above query statement If you need any information from the ACCOUNT file, such as client name, you can add the appropriate dictionary item to the TRANS file to pull the client name from the Account file. e.g. Adding a dict item to TRANS to pull client name from ACCOUNT Assuming the following: In TRANS file, the Account # is in attribute # 1 In ACCOUNT file the Client name is in attribute # 2 01 S 02 01 03 Client Name 04 05 06 07 08 TACCOUNT;X;02;02 09 L 10 25 -- Kevin Powick -- -- IMPORTANT: T24/Globus posts are no longer accepted on this forum. 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 --- You received this message because you are subscribed to the Google Groups "jBASE" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. For more options, visit https://groups.google.com/d/optout.
