Hi,
.:Should we have separated tables to control account receivables and payables? If so, how can we use the information from this tables to create a "cashflow" report? What is the ERD that does this?
Why? Well, my wife and I own a beauty salon (small business) and we had been using excel to calculate the commissions, to keep track of payments made to the employes (other than commissions), to calculate the gross profit and also to manage the cashflow (present and future payables/receivables).
In order to be able to generate reports (eg. the clients that come more often and the ones that haven`t come to the salon recently) we decided to switch to a database.
So far we managed to create the invoicing (the table is named "Comandas") and a way to control the payments of each invoice (table "Recebimentos").
We created a separate table "Pagamentos" to control payments made to the employes ("Atendentes").
The problem is that we haven`t found a way to use the information stored on AccountsReceivable (Recebimentos) and AccountsPayable(Pagamentos) to generate a cash flow report (to show incomes and payments grouped by date).
All help is welcome.
Our database is attached Beauty Salon.fmp12.zip
ty
Robzz & Taty
