I'm having a bit of trouble building a simple ranged Income Statement that falls outside of the standard accounting periods.
I created the report as a copy of the default Income Statement. Under criteria, I unselected "Use Accounting Periods (field: period)". I then checked the Range option so that I could enter a ranged date as criteria instead of having to choose an accounting period.
This is the error I received when running the report:
Code:
Trace information for debug purposes. Phreedom release 3.4, generated 2012-08-02 14:45:28.
GET Vars = Array ( [module] => phreeform [page] => popup_gen [rID] => 78 [todo] => open )
POST Vars = Array ( [todo] => exp_html [title] => TriLibrium - Income Statement [delivery_method] => I [from_name] => [from_email] => francis@bridgesense.com [to_name] => [to_email] => [cc_name] => [cc_email] => [message_subject] => TriLibrium - Income Statement From BRIDGESENSE [message_body] => Attached is your TriLibrium - Income Statement from BRIDGESENSE
To view the attachment, you must have pdf reader software installed on your computer. [rID] => 78 [datedefault] => b [date_from] => 07/01/2012 [date_to] => 08/02/2012 [defgroup] => 0 [defsort] => 0 [deftrunc] => 0 [defcritsel0] => ALL [fromvalue0] => [tovalue0] => [fld_fld] => Array ( [0] => description [1] => current [2] => current_ytd ) [fld_desc] => Array ( [0] => Account [1] => Current Period [2] => Year to Date ) [fld_brk] => Array ( [0] => 1 [1] => 1 [2] => 1 ) [fld_clmn] => Array ( [0] => 75 [1] => 60 [2] => 60 ) [fld_vis] => Array ( [0] => 1 [1] => 1 [2] => 1 ) [fld_proc] => Array ( [0] => [1] => def_cur [2] => def_cur ) [fld_tot] => Array ( [0] => 0 [1] => 1 [2] => 1 ) [fld_algn] => Array ( [0] => L [1] => R [2] => R ) [papersize] => Letter:216:282 [paperorientation] => P [margintop] => 10 [marginbottom] => 10 [marginleft] => 10 [marginright] => 10 [coynameshow] => 1 [coynamefont] => helvetica [coynamesize] => 12 [coynamecolor] => 0:0:255 [coynamealign] => C [title1desc] => %reportname% [title1show] => 1 [title1font] => helvetica [title1size] => 10 [title1color] => 255:0:0 [title1align] => C [title2desc] => Report Generated on %date% [title2show] => 1 [title2font] => helvetica [title2size] => 10 [title2color] => 0:0:0 [title2align] => C [filterfont] => helvetica [filtersize] => 8 [filtercolor] => 0:0:0 [filteralign] => L [datafont] => helvetica [datasize] => 10 [datacolor] => 0:0:0 [dataalign] => C [totalsfont] => helvetica [totalssize] => 10 [totalscolor] => 0:0:0 [totalsalign] => L )
Time: 59 ms, 3 SQLs 1 ms =>
The failing sql was: select period from accounting_periods where fiscal_year = order by period limit 1
Time: 59 ms, 3 SQLs 1 ms =>
mySQL returned: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'order by period limit 1' at line 1
Page trace stats: Execution Time: 59 ms, 3 queries taking 1 ms
I tried to do this in the latest demo you have online and received the same error. All I want to do is print an income statement based off of a ranged date rather than on a specific period.
Under Field Setup, I'm locked into a specific displays: Account, Current Month, YTD, etc. There doesn't seem to be a field specifically for a ranged print-out outside of those parameters. I believe this may be my problem. Any advice?
Thanks!
