Budget Variance Report- department instead of CC

MAoffice · August 22, 2021, 12:40pm

Hello,
My budget was prepared department wise, in the Budget Variance Report only the choice between CC and Project.

How could I choose the department?

V13

Regards
Ahmad

peterg · August 22, 2021, 12:44pm

Have you seen Accounting Dimensions? That’s probably what you’re looking for.

https://docs.erpnext.com/docs/v13/user/manual/en/accounts/accounting-dimensions

MAoffice · August 22, 2021, 12:47pm

Screen Shot 2021-08-22 at 2.31.22 PM

MAoffice · August 22, 2021, 12:48pm

Hi,
As you can see only project of cost centre, How could I choose department?

MAoffice · August 22, 2021, 12:51pm

Screen Shot 2021-08-22 at 2.35.51 PM

I already have a department in the accounting dimensions

peterg · August 22, 2021, 3:00pm

You’re right. There’s a bug in this line of code:

github.com

frappe/erpnext/blob/0ef5247e2f6e9562fe837394243b71642d1d98d6/erpnext/accounts/report/budget_variance_report/budget_variance_report.js#L93


      
          			else if (data[column.fieldname] > 0) {
          				value = "<span style='color:green'>" + value + "</span>";
          			}
          		}
          
          
		return value;
          	}
          }
          
          
erpnext.dimension_filters.forEach((dimension) => {
          	frappe.query_reports["Budget Variance Report"].filters[4].options.push(dimension["document_type"]);
          });

It’s supposed to be adding other dimensions to the dropdown list, but erpnext.dimension_filters doesn’t seem to refer to anything anymore.

MAoffice · August 22, 2021, 3:10pm

Thank you

Fred1 · August 22, 2021, 7:05pm

Make your departments also cost centers

MAoffice · August 25, 2021, 4:04am

Thanks for your comment.
Of course, we can but better to use the accounting dimension.

Regards