Payments Received or Closed Transactions
Posted: Sun Oct 12, 2014 7:01 pm
Hi, I am building a Report in MS Access similar to Sales-006, Commissions: Customers Payments received, however I need to be a bit more selective. What I need to do is:
1) I identify that at transaction is closed. I have opened a number of tables and there does not seem to be a flag that says that a transaction is closed. So I assume that you are using an expression like InvTOT - Payment = 0, then transaction closed???
2) the other thing I need to do is only pay commissions on products from a particular supplier.
Any ideas would be greatly appreciated. Thanks
1) I identify that at transaction is closed. I have opened a number of tables and there does not seem to be a flag that says that a transaction is closed. So I assume that you are using an expression like InvTOT - Payment = 0, then transaction closed???
2) the other thing I need to do is only pay commissions on products from a particular supplier.
Any ideas would be greatly appreciated. Thanks