AP Checks in Alpha Order

  • Ashley Rupp

    Member
    June 12, 2023 at 3:00 pm
    Up
    0
    Down
    ::

    This is out of the box functionality now. Before cutting checks you can use any columns to sort so you can sort the column you want and then print them

  • Eric Mielke

    Member
    June 12, 2023 at 3:19 pm
    Up
    0
    Down
    ::

    In testing that I have done, you can sort the list but the checks will always print in the order of the line number that is assigned to each line. You need to add the lines to the payment journal in alphabetical order if you want to print in that order. I’m not aware of any way to tell the system to print in alphabetical order after the lines have been added to the payment journal.

  • David Wiser

    Member
    June 14, 2023 at 10:53 am
    Up
    0
    Down
    ::

    After testing, I found that if you reorder the payment journal by description (which holds the vendor number) and then add sequential document numbers, the checks will print in alpha order. The journal appears to first look at sorting by document number and then line number. The system will replace the manually added document number with the check number after printing (which is line number order), but the print job should be in alpha order.

    Don’t use the “Renumber Document Numbers” function as that numbers then in line number order. You need to manually enter document numbers in the print order. Painful if there are lots of checks, but it works.

    • Eric Mielke

      Member
      June 14, 2023 at 12:14 pm
      Up
      0
      Down
      ::

      Thanks for the update David, I was able to replicate that on my end as well. Definitely a pain for large check batches, but still a great tip.

The discussion ‘AP Checks in Alpha Order’ is closed to new replies.

Start of Discussion
0 of 0 replies June 2018
Now

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!