CAPITAL Office Business Software

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

Posted: **Mon Oct 13, 2014 9:13 am**

The report you're trying to replicate is reasonably complex but be that as it may the way to determine if an invoice is unpaid partly or fully, or a payment unallocated partly or fully, is as follows -

Code: Select all

IF  Invoice->Invtot) <> Invoice->Tratot .AND. Invoice->Invtot > 0
   // Not fully paid
   Return ( False )
ELSE Invoice->Invtot <> Invoice->Noalloc * -1 .AND. Invoice->Invtot < 0
   // Not fully allocated
   Return ( False )
ENDIF

Return ( TRUE )

CAPITAL Office Business Software

Payments Received or Closed Transactions

Payments Received or Closed Transactions