July 15, 201213 yr Newbies Novice FM user and now am upgrading from 8.5 to 12 because it allows for mobile applications. I want to make use of the Invoice Starter Pack to track invoicing and payments. Currently, this activity is done using EXCEL tables. The Business rules are simple, payments are applied to the oldest unpaid invoices for each account. For each account, the invoices are summed and the payments are summed and the difference is the balance. My thought is to create a RECEIPTS table (mirror of INVOICES) to capture and print the payment data and receipts. The thing I am struggling with is how to have a subset of data from INVOICES and RECEIPTS store in a single table so that I can easy print out reports of transaction history. This is my proposed structure: INVOICE table has fields: INVOICE ID, ACCOUNT, DATE, AMOUNT RECEIPT table has fields: RECEIPT ID, ACCOUNT, DATE, AMOUNT TRANSACTION table has fields: TRANSACTION ID, INVOICE ID, RECEIPT ID, ACCOUNT, DATE, AMOUNT Can any propose a simple change to the starter pack structure to allow this?
Create an account or sign in to comment