Business One Profit and Loss Statement Budget Report Subtotals not Working

[former_member581418]

We are running Business One 9.0

The Budget profit and loss report appears to be badly written. Rather than having the budget data in the same line as the actual, the report creates extra lines for the budgets AND adds more data to the actuals column. Very confusing. Why not just have the budget and actual in the same row?

Also when you click on the block for subtotals, the subtotals only appear for the actual column, not the budget column. Why is that? Is there as problem with out setup perhaps?

[kothandaraman_nagarajan]

Hi,

If you decrease level to 1, then report shows single line with actual value.

Thanks & Regards,

Nagarajan

[former_member581418]

That does not help as you often want to see the reasons why there are budget deviations. Hence you need to work at lower levels.

[KennedyT21]

HI John...

It is a standard behavior if you need in different format then customized query report is required for that.

No other option.

Regards,

Kennedy

[Venmani]

Still the subjected issue not resolved in Version 10 also,

Is there any method to enable subtotals in each groups in Business One "Profit and Loss Statement Budget Report" ?

[Former Member]

Hi,

Can you post a screenshot for your report?

Thanks,

Gordon

[former_member581418]

Hi Gordon

Below is an example of the duplication of lines. The line for 6015100 is firstly in blue without a budget and then repeated in pink with a budget. Why is there not only only with both actual and budget?

The next example shows what happens if you tick the Display Subtotals box. The subtotal for 6015100 Marketing appears in the Actual column but not in the Budget column.

This is obviously just and example, it works the same for all other accounts

Regards

John