AnsweredAssumed Answered

How do i enter info into a sub summary?

Question asked by Kirk_1 on Mar 26, 2013
Latest reply on Mar 26, 2013 by philmodjunk


How do i enter info into a sub summary?


     Here is the background.

     I'm working on invoices. Some of my customers ask for one statement on all of the transactions per day. These same customers have multiple locations to add to the mix.

     I've created an "order" table, so i can put the order ID into the transactions to tie them together.

     It works,  i create some of the transactions during the day and put the order ID's into each transaction.

     Other transactions come in EDI/import and i need to put order ID's in the EDI transactions.

     I've created a sub summary that will produce my found set based on posting the transaction that day, sorting by the bill to customer ID numbers.

     I will use a set varable and set field,  to put the order ID into the transaction, once i get if figured out.

     The sub summary is doing it's job, they are sorted by the bill to ID's and I've put a count in so i know how many invoices per customer... 

     I can't figure out how to work my way through the list and distinguish between the several bill to ID's, and enter the order ID for that customer.

     With that order ID i can receive my customers check for the statement and not the transactions.

     Any ideas?