Kevin is correct. To give you the right attributes: SORT TRANS WITH 9 EQ "3" BY 1 BY 22.4 BREAK-ON 1 BREAK-ON 22.4 TOTAL SIGNED-TRANS-AMT DET-SUPP.
DICT items exist in TRANS already for attributes as the account name and client name. On Thursday, March 13, 2014 9:05:24 AM UTC-7, Kevin Powick wrote: > > 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.
