Reply To: Smartlist – Customer Statement past due invoices

  • Pamela Stephenson

    Member
    January 17, 2024 at 5:01 pm
    Up
    0
    Down
    ::

    Christine,

    I have used smartlist to generate an AR balance. I have it search for transactions that don’t have a zero balance on the current trx amount field. I am sure you can add some date field to the search criteria to for example, get items older than the prior month. You just have to know that returns, credit memos and payments will show as positive figure in Excel, and adjust for that. (Or include only invoices).

    Hope that helps.

Welcome to our new site!

Here you will find a wealth of information created for people  that are on a mission to redefine business models with cloud techinologies, AI, automation, low code / no code applications, data, security & more to compete in the Acceleration Economy!