I'm not sure if my title makes sense, but I have an assignment and need some guidance on how to approach this.
It's an Accounts Receivable program for ABC Hardware Company. I have a Master file with cust numbers, cust name and balance due. I also have a Transaction file with cust number, transaction type(Payment or Order), item ordered, quantity and total amount. If the transaction is a Payment I subtract from the customer balance due. If its an order I add it. There should be more than one transaction record for each master record.
I am having a tough time figuring out how to first approach this without confusing myself. I have a structure and created the two files but I'm not sure in which order I should do things. I appreciate any advice you can give that will put me in the right direction.
Thank you in advance.
My output should have:
[B]Customer Name Customer Number
Previous Balance $
Transaction# Item Ordered Order Amount $
Transaction# Payment Payment Amount $
Balance Due $
[/B]