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: 678
    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 1 guest