Report by account and class

Anthony_10861832
Anthony_10861832 Member Posts: 15 Reckoner Reckoner

Hi. Is there a way of extracting a report (either p&l or trial balance) by account and class combination. Ideally this would be in two separate fields/columns, with the balance of the combination of that account and class shown in a separate column.

Screenshot 2021-08-24 105252.png


Answers

  • Bruce
    Bruce Member Posts: 447 Professional Partner Professional Partner
    edited August 2021

    Run your P&L as per normal but modify the report by displaying classes

    Capture.PNG


  • Anthony_10861832
    Anthony_10861832 Member Posts: 15 Reckoner Reckoner

    Thanks for the reply Bruce. This doesn't quite meet my requirement, I am looking for a single column listing the class ID, not a column per class. I am looking to expand the use of class that would make the report many pages wide if I ran it by class.

    Do you know if there is a way of doing this (per my screenshot in my original post)?

  • PhuongDo
    PhuongDo Reckon Developer Partner Posts: 333 Reckon Hall of Famer Reckon Hall of Famer

    Hi Anthony,

    A custom solution would help. Let me know if you want to learn more about it.


    Phuong Do / Reckon Developer Partner

    phuong@cactussoftware.com.au

    https://www.youtube.com/watch?v=O61SfV2bte8

  • Anthony_10861832
    Anthony_10861832 Member Posts: 15 Reckoner Reckoner

    Thank Phuong. I can get a custom transaction detail report, where you can add the class column, which might work. Thanks for responding.

  • GerryWinter
    GerryWinter Accredited Partner Posts: 1,576 Accredited Partner Accredited Partner

    I think think PhuongDo would write a custom report for you, so get in touch with him.

    Gerry id 6376

    Gerhard Winter

    Ph. 0418907140

    Reckon Store Next Door

    "Always at your Service"

    Email: gwinter0808@gmail.com