Report dates all muddled

tonyt's Avatar

tonyt

26 Mar, 2023 04:34 PM

Hi
Can anyone help me please? A report I have just produced sub totalled by category has the dates all muddled up. How can I get them in order please?
Many thanks...

  1. 1 Posted by mhoggie on 26 Mar, 2023 06:25 PM

    mhoggie's Avatar

    just a user,

    Which report are you using ?

  2. Support Staff 2 Posted by Ethan on 27 Mar, 2023 12:24 AM

    Ethan's Avatar

    And if you could also include a screenshot of the settings window for this report, that would be helpful as well.

    Ethan
    Infinite Kind Support

  3. 3 Posted by tonyt on 27 Mar, 2023 11:41 AM

    tonyt's Avatar

    Hi Both
    Transaction Filter Report used. Settings attached.
    Many thanks...

  4. 4 Posted by tonyt on 28 Mar, 2023 04:50 PM

    tonyt's Avatar

    Can anyone help please, report needed urgently in date order.
    Many thanks and hoping....

  5. 5 Posted by mhoggie on 28 Mar, 2023 06:16 PM

    mhoggie's Avatar

    just a user,

    I'm trying to reproduce your issue, but I have some questions.
    The example report you show does not seem to have all the columns that I get on from my Transactions Filter report. I have 8 columns, Account, Date, Check#, Description, Category, Tags, C, and Amount. You don't seem to have some of those columns in your reports. Also when I look at your example report, I see Account names (in the first column) that also have the exact Category name ( in the third column), and also the 4th column in your example does not show the category subtotal as it does in my report. I also noticed that you are on running the report against the 01-NW Current Joint 7658 account, but the 1st column seems to be showing other accounts. So I'm a bit confused. But I will say that the Transaction Filter report has been known to have some issues in the past and I don't know if they were all resolved. Unfortunately the Transaction Filter report is the only report that will subtotal by Category.

  6. 6 Posted by dwg on 28 Mar, 2023 09:46 PM

    dwg's Avatar

    "Unfortunately the Transaction Filter report is the only report that will subtotal by Category."

    The Income and Expense reports subtotal by category, that is their intent.

  7. 7 Posted by mhoggie on 28 Mar, 2023 10:25 PM

    mhoggie's Avatar

    just a user,

    dwg is correct about the Income and Expense report. It will subtotal by category but shows only subtotals with in the date range. Does not list individual transactions like the Transaction filter does.

  8. 8 Posted by Mark on 28 Mar, 2023 10:43 PM

    Mark's Avatar

    If you need to sort this by date URGENTLY, and can't get the transaction filter report to behave, copy these results to the clipboard and paste it into a spreadsheet program like Excel. You may have to diddle with the delimiters to get it just right. Then sort the spreadsheet.

  9. 9 Posted by dwg on 28 Mar, 2023 10:51 PM

    dwg's Avatar

    I think it probably depend on what sort of detail you are looking for whether the Transaction Filter report or the Income & Expense detailed report works for you.

    The Transaction Filter report has had a number of issues over the years.

  10. 10 Posted by mhoggie on 29 Mar, 2023 02:29 AM

    mhoggie's Avatar

    just a user,

    I was finally able to reproduce the issue you see. It took some time to see it because mostly the report keeps the dates in order. But I ran a large report and looked for date issues and found several places where the dates were out of order. Did not find any issues with the transactions and I found the same problem without the TAG filter, so I must surmise the Transaction Filter report has another problem. Looks like your only solution is to export to a CSV file and fix it with a spreadsheet. I couldn't find another report where the Tag is included in the report.

  11. 11 Posted by tonyt on 29 Mar, 2023 07:56 AM

    tonyt's Avatar

    Hi all
    Thanks for looking into this….

    I see Account names (in the first column) that also have the exact Category name ( in the third column).

    The reason I have the same name is for Mastercard account I have a chk. Drop down for Mastercard, which includes Mastercard, Online, Eft and so on. So if I use my Mastercard in a shop on my Mastercard account, the same name shows in both columns. If I pay online from the Mastercard account the third column would show 'Online'.

    I also noticed that you are on running the report against the 01-NW Current Joint 7658 account, but the 1st column seems to be showing other accounts

    As the account field is not checked I assumed it runs the report on all accounts which is what I want. If I check the account field I guess the report will run on whatever account is selected.

    As i have said in previous posts I wish new features, more just released!, were put on hold and long lasting bugs in some essential areas - like Reporting, were well and truly squashed. But I don't see it happening for whatever reason which is a real shame and detracts from the day to day use of the program.
    There!!!
    Many thanks again and cheers…

Reply to this discussion

Internal reply

Formatting help / Preview (switch to plain text) No formatting (switch to Markdown)

Attaching KB article:

»

Already uploaded files

  • Screenshot_2023-03-26_at_17.32.02.png 251 KB

Attached Files

You can attach files up to 10MB

If you don't have an account yet, we need to confirm you're human and not a machine trying to post spam.

Keyboard shortcuts

Generic

? Show this help
ESC Blurs the current field

Comment Form

r Focus the comment reply box
^ + ↩ Submit the comment

You can use Command ⌘ instead of Control ^ on Mac