automatic credit hold for overdue transactions
  • JeffGrant
    Posts:32
    Joined:Thu Sep 20, 2018 3:38 pm
    Location:Sydney Australia
    automatic credit hold for overdue transactions

    by JeffGrant » Thu Jan 17, 2019 1:25 pm

    I want to run the R-COPEN script to automatically place a customer on hold if transactions are over due. When I open the Invoice table and look for open transactions, I only need the oldest transaction to check the date against. How can I restrict the search to finding only this transaction or is it faster just to check every transaction?

    Thanks in advance
  • COBS Tech Support
    Posts:683
    Joined:Fri Sep 09, 2005 8:23 am

    Re: automatic credit hold for overdue transactions

    by COBS Tech Support » Wed Jan 23, 2019 10:15 am

    You can experiment with the "AALLOC" ordering, which will only list unpaid transactions by account. This will make your check of the database much faster.

    I.e.,

    Code: Select all

    INVOICE->(Find(cAccount, "AALLOC"))

Who is online

Users browsing this forum: No registered users and 4 guests