Share
Report
11Good Morning,
I am hoping that someone can help me with a personal project I am working on. I recently created a Solution and have worked on building Tables, Forms, etc. inside the solution in an attempt to create a rudimentary Double Entry Accounting application that my wife and I can use to track expenses (with document attachments) and budgeting for personal items as well as a small business we own. Think a more streamlined QuickBooks.
I have 2 tables:
1. Transactions - This table holds the Total Transaction amount and the Source Account that the transaction comes from/goes to (balance sheet account like the bank account, credit card, etc.)
2. Transaction Details - This table holds the split line items. For example if I spend $1,000 at the store and $500 was for groceries but $500 was office supplies these would be 2 separate records with values for memo, destination account, and amount. The total of the line items should equal the amount of the related item in the "Transactions" table.
I need help with the following:
1. A way to (in a Canvas App or Model Driven App) add the transaction split details and save these as records to the Transaction Details Table. This has to be variable as the transaction could have 1 split item or 30 depending on what it is. I am hoping to create a recurring transactions table in the future that will allow me to automate booking transactions like our pay checks and showing gross income and all appropriate taxes. The best way I can picture this is an editable table below the primary transaction information is input.
2. A way to take the information for the source account and amount from the Transaction Table and add it to the transaction details table without showing it in the editable table mentioned above (since it'll be edited in the main transaction information above.
3. A way to handle things like Journal Entries. I think once I have a way to handle items 1&2 I can figure out a way to do this.
Any help you fine folks can provide on creating something like an editable table in PowerApps (Model or Canvas) would be EXTREMELY APPRECIATED!!!
Attaching an image of a Quickbooks Check input screen for reference as this is kind of what I'm going for. Not laid out like a check obviously but something similar.
All responses (
Answers (
