AnsweredAssumed Answered

Transactions and Payments

Question asked by TKnTexas on Apr 26, 2014
Latest reply on Apr 28, 2014 by philmodjunk


Transactions and Payments


     I have two tables Customers and Transactions.  Transactions is very simplified, charges and payments.  If I am posting a payment, and put in the customer number, I want the unpaid transactions to populate a portal.  


     I have a TO for the posting of the charges.  I am not sure how to define the second TO.  Suggestions?

     The SeqNum in the Customer table is the customer number which is the secondary key (sKey) in the transaction file.  I am thinking populating the TranCode (PAY) and the Customer Number would populate a portal with transactions for the customer with a balance due greater than 0.00.