FrontAccounting forum — Budget reporting

Re: Budget reporting

null@example.com (huotg01) — Tue, 20 Jul 2010 03:05:49 +0000

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

null@example.com (huotg01) — Mon, 19 Jul 2010 22:51:18 +0000

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

null@example.com (huotg01) — Mon, 19 Jul 2010 21:33:49 +0000

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

null@example.com (huotg01) — Mon, 19 Jul 2010 11:26:43 +0000

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

null@example.com (joe) — Mon, 19 Jul 2010 07:24:22 +0000

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

/Joe

Re: Budget reporting

null@example.com (huotg01) — Mon, 19 Jul 2010 02:24:50 +0000

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

null@example.com (joe) — Mon, 19 Jul 2010 00:36:44 +0000

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

/Joe

Re: Budget reporting

null@example.com (huotg01) — Sun, 18 Jul 2010 15:56:24 +0000

Joe

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

Something to check out ?

Gaston

Re: Budget reporting

null@example.com (joe) — Sun, 18 Jul 2010 07:44:51 +0000

No, the Report Profit and Loss Statement.

/Joe

Re: Budget reporting

null@example.com (huotg01) — Sat, 17 Jul 2010 22:27:12 +0000

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

null@example.com (joe) — Sat, 17 Jul 2010 21:08:13 +0000

You can compare the profit and loss statement against Budget.

/Joe

Budget reporting

null@example.com (huotg01) — Sat, 17 Jul 2010 20:16:54 +0000

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