Skip to main content

P&L Statement more than 12 months

Setup

  1. GL > Profit and Loss Statement

    1

  2. Right Click on SQL Icon > go 800 x 600 to smaller SQL Screen

    2

  3. Click on the report name “This year-2 Column” > click and drag it to desktop

    3

  4. Click on the report from desktop and drag it back into SQL

    4

  5. After drag in will prompt dialog above > click on OK

    5

  6. Double click on the report name “ this year-2Column” (in blue colour font)

    6

    1. You can enter a report name

    2. Change the period class to Fixed Date

    3. Param 1 : Date From

      Param 2 : Date to

    4. Click on OK

    7

info

Apply the report as usual, the result will captured based on Param 1 & 2 set.

Repeat the same step on GL > Print Balance Sheet Statement