B
BL
Dear all,
I have designed a database with a Receivable Table and a Payment Table to
keep track on the rental income and receivable. The Receivable Table is with
the following fields
AutoField
PeriodID
RentalID
Amount
Payment Table has the following fields
AutoField
PeriodID
RentalID
AmountPaid
I have created a monthly job to create receivable per rental agreement (we
have tenancy agreement without expiry, there is no point to create all the
receivables for next 2-3 years). Since tenants can make prepayment, thus,
there may be period in the payment table without corresponding record in
Receivable table yet. On the other hand, there may be rent outstanding, that
is there may be no corresponding record in Payment Table for every record in
the Receivable table.
I would like to write a report to show the receivable and amount
paid/prepaid per RentalID and PeriodID, please give me your advise in linking
up these data together?
Many many thanks
BL
I have designed a database with a Receivable Table and a Payment Table to
keep track on the rental income and receivable. The Receivable Table is with
the following fields
AutoField
PeriodID
RentalID
Amount
Payment Table has the following fields
AutoField
PeriodID
RentalID
AmountPaid
I have created a monthly job to create receivable per rental agreement (we
have tenancy agreement without expiry, there is no point to create all the
receivables for next 2-3 years). Since tenants can make prepayment, thus,
there may be period in the payment table without corresponding record in
Receivable table yet. On the other hand, there may be rent outstanding, that
is there may be no corresponding record in Payment Table for every record in
the Receivable table.
I would like to write a report to show the receivable and amount
paid/prepaid per RentalID and PeriodID, please give me your advise in linking
up these data together?
Many many thanks
BL