Novice Question (accounts payables and receivables x cash flow) what is the ERD?

[robzz7]

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

[Matthew F]

It looks like you're getting close!

 

I noticed that you have a subsummary which sorts by date.  Do you really want day-by-day tallies of expenses?   Probably you want a longer interval such, such as a month.  To accomplish this create a calculated field that calculates the month of the year. Then include this in your sort order (e.g. month; then date) and key the subsummary on this field.