Unanswered

Finance manager / account statements moudle in Power Apps

(0) Share

Report

Posted on by TYO

Hi
I am in the process of planing an app for my business , which would gather all sales, inventory movements, and money transactions.
I am looking around to see if PowerApps / AppSheet is the solution for me .
I have not found or saw any example or something similar that can show me that it can be done with Power Apps .
My main concern is the database structure , how to handle each transaction in 2 tables .
For example :
Customer1 pays for hes order to the bank account.
I need to update the customer table , to reflect hes balance, and on the same time , I need to update this transaction on the bank account table to reflect the balance.

So my question is , is it something Power Apps would be able to perform in a smooth / efficient way ?
And maybe someone can show me a similar module so I can know how to plan it correctly ?

Thanks

Categories:

Building Power Apps

I have the same question (0)

All responses (2)

Answers (0)

Sort by

mdevaney 29,991 Moderator on at

Like
a
(0)

Report
Copy link

Link copied!

@TYO
I love PowerApps as much as anyone, but as an Accountant, I would say the best way to solve all of your problems here is to purchase a subscription to some accounting software. What you are trying by making tables for sales, inventory, bank accounts, etc. has already been done by all accounting software programs. Plus you have built in record keeping for financial statements and taxes.

Do not recreate accounting software in PowerApps that you can buy cheaply. Buy the accounting software and use the hours saved to grow your business!

---
Please click "Accept as Solution" if my post answered your question so that others may find it more quickly. If you found this post helpful consider giving it a "Thumbs Up."

Was this reply helpful? Yes No
TYO 2 on at

Like
a
(0)

Report
Copy link

Link copied!

@mdevaney

Thank you for your reply .

Actually I want to modify it abit, add columns that my business requires , and have users to submit data with my forms.

For that reason I want to go with Powerapps / appsheet .

Do you have a basic program that integrates easily with Powerapps ?
Maybe Ill start from there , and add my futures to collect additional data from users.

Was this reply helpful? Yes No