'Sort by' feature on supplier open balance

Jodie Vermeer
Jodie Vermeer Member Posts: 18 Reckoner Reckoner
edited April 13 in Accounts Hosted

Hi, I am trying to find out how I can sort transactions in a 'supplier open balance' report by date and then number, however, there doesn't seem to be a way to do that. Can anyone help me with this?

Thanks

Jodie

Best Answer

  • Acctd4
    Acctd4 Accredited Partner Posts: 4,208 Reckon Accounts Hosted Elite Expert Reckon Accounts Hosted Expert
    Answer βœ“

    Hi Jodie

    The sort filters can only be set to one parameter at a time however you may find it more editable if you create your own instead.

    On the Advanced tab in the Find window (under the Edit dropdown menu along the top toolbar) …

    • Select the Account filter & choose/select Accounts Payable
    • Select the Name filter & select/choose your required Supplier
    • Scroll down to Paid Status & select Open

    Click OK then on the Report button

    Drag a column separator to the left, to close any Columns you don't need.

    Click Modify Report (at the top left) & you can now Total by AND Sort by different parameters. You can add/remove Columns here as well as name & Memorise any report to retain your settings for re-use 😊

    Shaz Hughes.png

    Email | Website | Google Reviews | Facebook Reviews

Answers

Categories