Payments Received or Closed Transactions
  • JeffG
    Posts: 91
    Joined: Sat Aug 31, 2013 6:50 pm
    Location: Sydney

    Payments Received or Closed Transactions

    by JeffG » 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
  • COBS Tech Support
    Posts: 678
    Joined: Fri Sep 09, 2005 8:23 am

    by COBS Tech Support » 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 )

Who is online

Users browsing this forum: No registered users and 1 guest