Some of our customers have net 21 terms with us and wish for us to process their credit automatically after 21 days. Is there anyway for Adagio Receivables to remind us to do this?

Gridview would do it.

Create a View based on the AR Transactions table. Select all the relevant fields that you need (ie. cust number, amount, description, etc).

Create a filter along the lines of:

AND(
{Trx Type} = "IN",
{Terms Description} ="NET 21",
QUERYDATE("Enter Transaction Date")<={Trx Date}
)

The Querydate command will allow you to input a date, say 1 month prior to today, to limit your results to the most current transactions. There's likely a way to automate this further by using a "Today's date - 30 days" tpye of formula, but I can't recall it at the moment.

You can then sort the grid by transaction date. Run this GV daily, or weekly and print it off to provide a reminder for your AR people to process the payment.

Hello Susan:

I don't see a way in Receivables but you could do it easily using GridView.

-Filter to Invoices based on Due Date and still unpaid
-Include 21 days plus 22, 23, 24 (in case of weekends and days that get missed)
-If you want, you can automate the View so that it runs overnight and is waiting for you as an Excel file.

Thanks. Anyone know if there's a way to make this line work?

{Due Date} <= TODAY

Is there a way to say TODAY in a way that GV will understand?

TODAY()

Susan:

Ryan included an important criterion that I missed: You do need to include the terms in your Filter, otherwise you will get extraneous invoices.

Thanks. TODAY() works great. Another problem solved! :-)