Help Please - Receipts and Payments A/c

  • Thread starter Thread starter SAI
  • Start date Start date
S

SAI

I would like to develope an accounts package for
maintaining CASH BOOK for our office. Kindly give few tips
how to start with, how to relate with receipts and
payments table and for generating report - Receips and
Payments account.
Thanks in advance
sai
 
TblTransaction
TransactionID
TransactionDate
ReceiptOrPayment
TransactionAmount

On your form, include TransactionDate and TransactionAmount twice. Label one
TransactionAmount as Receipt and the other TransactionAmount Payment. Put
the following code in the Receipt TransactionAmount AfterUpdate event:
Me!ReceiptOrPayment = 1
Put the following code in the Payment TransactionAmount AfterUpdate event:
Me!ReceiptOrPayment = -1

Receipts will be recorded as positive transactions and payments will be
recorded as negative tranasctions by taking ReceiptOrPayment *
TransactionAmount.
 
Thanks for your reply. I would like know one thing only
one table is enough. Kindly advise. Thanks in advance.
Sai
-----Original Message-----
TblTransaction
TransactionID
TransactionDate
ReceiptOrPayment
TransactionAmount

On your form, include TransactionDate and
Click to expand...
TransactionAmount twice. Label one
 
NO!! The Transaction table merely records your receipts and payments. You
need probably two more tables for your Chart of accounts, one or more tables
for who you receive receipts from and one or more tables for who you pay.
You don't mention what your business but if it is some type of products, you
need tables for that too. Then there is all your other accounting needs.
 
Back
Top