AnsweredAssumed Answered

Transactions and Payments

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

Title

Transactions and Payments

Post

     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.

Screen_Shot_2014-04-26_at_12.36.33_AM.png

Outcomes