Custom reports - General Ledger Account Name

Hello everyone,
I am trying to make two reports using the Custom reports template, one for Annual payments, the other for Annual receipts.
I also need to show the Profit and Loss Statement code so I added the General Ledger Account - code but the results are not correct to me.

I need a transaction on each row with the following fields:

  • Date
  • Profit and loss statement code
  • Document reference (if any)
  • Payee
  • Amount

Could somebody please suggest me how to set it up correctly?

Can you be more specific in what way the results are not correct? It saves time so I know where exactly to look at.

I cannot upload the real report here, I’ll try to recreate the issue in the northwind DB.

What do you mean by “Profit and Loss Statement code?” There is nothing in Manager by that name. Are you referring to account codes?

Post screen shots of your custom report definition and the resulting report.