Custom Report

1

Hi Folks,

I’m trying to generate what I thought would be a simple report - see pics below.

WhatIWant

All I want is the date, Customer and credit amount

WhatIGet

What I get is Date, Customer, Credit Amount, new line with Date and Customer

WhatIExpected

This is what I’m hoping for. (Made possible through photoshop.)

What am I missing here? Or is this normal?

Thanks in advance.

2

This is normal.

Manager follows the standard double entry accounting rules where each transaction has a debit entry and a corresponding credit entry.

Your report shows both entries but obviously for the debit entry no amount is shown as you have not selected the debit column but only the credit column.

You need to use the where clause to select one of the transactions but not both.

3

Writing reports without context of how the software sees your data, is always hard. Which is why during custom report development I always also show (Select … in Manager terminology) extra information such as:

  • General ledger account → name (& code)

See this post for more details Custom Report Not Returning Transaction Type Properly - #12 by Patch

4

Thanks @Joe91 and @Patch ,

I was able to get the report to just show Credits or Debits using the Where clause, but I do need to get a better handle on how/why Manager does things so I’ll check out the post linked.

Thanks

5

You should also learn more about basic accounting so that you can better understand the principles behind Manager

Try www.accountingcoach.com

6

It was more the fact that when I deleted the debit line from the custom report - it still showed up in the report, just without the amount.

7

You didn’t delete the debit line, you did not display the debit column

At least that’s what the edit screen of your custom report is showing.

Maybe you have changed it since but as we cannot see what you have in your database, we can only go on the screens you have shown