FrontAccounting forum — Budget reporting

Re: Budget reporting

2010-07-20T03:05:49Z

Ok I have found the problem when I executed:

SELECT * FROM 1_chart_class WHERE !inactive AND ctype > 3 OR ctype=0 ORDER BY cid

Looking at 1_chart_class, I noticed that all rows where with ctype = 1

That explains why the report was always empty...

This probably comes from an initial bd correction I made earlier !

Anyway, it's now ok. Sorry for bothering you with that.

Gaston

Re: Budget reporting

2010-07-19T22:51:18Z

Joe

These are the sql statements from the sql trail on my test db:

"381","SELECT * FROM 1_company WHERE coy_code=1","1","The company preferences could not be retrieved"
"382","SELECT id, CONCAT(reference,'  ',name) as ref FROM 1_dimensions WHERE (type_=1) ORDER BY reference","1",
"383","SELECT * FROM 1_company WHERE coy_code=1","1","The company preferences could not be retrieved"
"384","SELECT * FROM 1_company WHERE coy_code=1","1","The company preferences could not be retrieved"
"385","SELECT * FROM 1_fiscal_year WHERE id='5'","1","could not get current fiscal year"
"386","SELECT * FROM 1_company WHERE coy_code=1","1","The company preferences could not be retrieved"
"387","SELECT * FROM 1_chart_class WHERE !inactive AND ctype>3 OR ctype=0 ORDER BY cid","1","could not get account classes"
"388","SELECT printer FROM 1_print_profiles WHERE profile='' AND report='707'","1","report printer lookup failed"
"389","SELECT printer FROM 1_print_profiles WHERE profile='' AND report=''","1","default report printer lookup failed"

What do you think ?

Gaston

Re: Budget reporting

2010-07-19T21:33:49Z

The demo shows all the results. No problem there.

I will look at rep707 to try to better understand what I did wrong.

Gaston

Re: Budget reporting

2010-07-19T11:26:43Z

Joe, I'm quite sure that FA is ok and that I am the problem, but I don't know what I'm supposed to expect.

I will go see the demo.

Gaston

Re: Budget reporting

2010-07-19T07:24:22Z

Are you sure you have selected the correct Fiscal Year when selecting the period?
I cannot reproduse this issue.

/Joe

Re: Budget reporting

2010-07-19T02:24:50Z

Joe

There is no account listed, just one line:

Period: 2010/07/01 - 2010/07/31 Page 1
Account Account Name Period Accumulated Achieved %
Calculated Return 0 0 0.000

Anything I should check out ?

Gaston

Re: Budget reporting

2010-07-19T00:36:44Z

The budget is stamped as per first day of the month. So be sure to have this day included.

/Joe

Re: Budget reporting

2010-07-18T15:56:24Z

Joe

Any "Start date" to any "End date" periods always reports zero !

Something to check out ?

Gaston

Re: Budget reporting

2010-07-18T07:44:51Z

No, the Report Profit and Loss Statement.

/Joe

Re: Budget reporting

2010-07-17T22:27:12Z

joe wrote:

You can compare the profit and loss statement against Budget.

Are you referring to Profit & Loss Drilldown ? There is no result .

Gaston

Re: Budget reporting

2010-07-17T21:08:13Z

You can compare the profit and loss statement against Budget.

/Joe

Budget reporting

2010-07-17T20:16:54Z

What are the reports using the Budget information ?

At the beginning of the fiscal year, let`s say that I want a report like:

"GL account" "Budget this year" "Budget last year" "Last year real"

is there anything like that ?

Gaston