[JMUnderwood]

How do I Create a Customer Budget vs Actual Report??

I do not want to see any accounts. I just want to see actual customer sales vs budgeted income for that customer.

I have create a budget for FY2008 for several customers. I entered an amount for each month for a single income account.

When I display the built-in Budget vs Actual report, it shows the correct actual and budget numbers.

When I customize the report to add a customer (Income Statement folder > Entity folder > Name) and remove the Section Name and Account, then the Budget Amount shows zero ($0.00) for all rows (all customers).

How do I make this work properly?
This is a cached copy. Click here to see the original post.

[JMUnderwood]

RE: How to Create Customer Budget vs Actual Report??

This is a DEFECT and should be treated as such.

After two lengthy phone calls to Support, it was confirmed that it is not possible to create a report of Customer Actual vs Budget.

The official response is to treat it as an enhancement:

Enhancement 96772: – Reports > Banking/Budgeting > Budget vs. Actual: Report budgets by customer

The 2nd Support Rep agreed that since the Budget record allows you to enter a budget for each customer, and the Budget vs Actual Report allows you to add Customer as a column, it should work. But it doesn’t.

Evan, if you happen to see this, here is yet another example of a design flaw.

[steve.ratcliffe]

RE: How to Create Customer Budget vs Actual Report??

JMU – We had a defect recognised and I am told was fixed in May this year which related to a similar set of circumstances I think:

Defect 141693

Case number 677921

RE: Defect 141693 – Reporting > Budget vs Actual filtered by Customer/Job/Department/Location/etc doesn’t display any data when account has a custom transaction column field with Type = List/Record and List/Record = Customer/Department/Location/etc

We are pleased to report that a fix has been implemented for this issue and you should no longer be experiencing this issue in your account.

Please reply to this e-mail if you have any further questions or difficulties with this issue

Steve Ratcliffe

[JMUnderwood]

RE: How to Create Customer Budget vs Actual Report??

Originally posted by steve.ratcliffe

RE: Defect 141693 – Reporting > Budget vs Actual filtered by Customer/Job/Department/Location/etc doesn’t display any data when account has a custom transaction column field with Type = List/Record and List/Record = Customer/Department/Location/etc

Steve,

Thanks for sharing this info. While it is related, I believe it is significantly different. I was not trying to filter by Customer, but to display just a list of Customers with Actual Sales and Income Budget.

[BK0001]

I just dug into this and can’t make it work either. You can specify a customer/job column from the Budget folder, and you can specify an Entity Name from the Income Statement folder, but there doesn’t seem to be any way to have these two fields correlate to each other such that you can get a line with a customer and an actual amount (= income statement entity name) vs. a Budget amount (= budget customer/job).

This should be a basic built in report. Alternatively, we should be able to select a field in report builder that makes this work.

Basic limitations like this seriously undermine the value of the “Advanced Financials” module. Ugh…

[BK0001]

In the Filter section of the basic Budget vs. Actual report, there is a standard line that is:

Report Component – Customer/Job

Field – Customer/Job: Name

… which, if you select a specific customer job at the bottom of the report, DOES line up the GL accounts correctly for budget and actual for that given customer.

So perhaps there is a way to identify that same field and use it in the Edit Columns section so that we can get a list of customers and, nest them under each GL account, and on the same line next to each customer, list budget and actuals.

But then again…

[Theresa]

RE: How to Create Customer Budget vs Actual Report??

I was playing with this as well, and did this:

1. Customized the Actual vs. Budget report

2. Added two columns:

—–Budget Folder > Customer/Job

—–Income Statement Folder > Entity Name

3. I then moved both to the 3rd report position (under Section and Account), and made sure they both had the “group” box checked.

Result: A report by account, that lists each customer’s actual transaction amounts and the budget for that customer.

I then realized your original posting said you don’t need accounts – so I removed accounts from the columns – it still works, but because the original report was based on accounts it gives separate lines for the transactions for each account.

I found that leaving Section and Account columns, but moving them underneath the Entity fields worked best. It shows each customer, then each account, transactions and budget entered for that customer.

Theresa

[JMUnderwood]

RE: How to Create Customer Budget vs Actual Report??

Originally posted by Theresa

I was playing with this as well, and did this:

. . .

Result: A report by account, that lists each customer’s actual transaction amounts and the budget for that customer.

. . .

I found that leaving Section and Account columns, but moving them underneath the Entity fields worked best. It shows each customer, then each account, transactions and budget entered for that customer.

Theresa

Theresa,

You are a genius!

Thank you so much!! You have solved a very hard problem, and provided my client with a very, very important report/metric. I will make sure they know your name.

[rrennie]

Hey Guys,

Anyone using or thinking about moving to One World, you will need to vote for this enhancement before you are able to use the BvA reporting if you have more than one currency/sub… which is the whole point of One World. Not sure how they missed this one in the requirements gathering…

Enhancement #140755

[cmccown]

RE: How to Create Customer Budget vs Actual Report??

Originally posted by Theresa

I was playing with this as well, and did this:

1. Customized the Actual vs. Budget report

2. Added two columns:

—–Budget Folder > Customer/Job

—–Income Statement Folder > Entity Name

3. I then moved both to the 3rd report position (under Section and Account), and made sure they both had the “group” box checked.

Result: A report by account, that lists each customer’s actual transaction amounts and the budget for that customer.

I then realized your original posting said you don’t need accounts – so I removed accounts from the columns – it still works, but because the original report was based on accounts it gives separate lines for the transactions for each account.

I found that leaving Section and Account columns, but moving them underneath the Entity fields worked best. It shows each customer, then each account, transactions and budget entered for that customer.

Theresa

Hello,

I have been trying to create a Budget vs. Actual by Customer report and the new financial report builder does not have the Customer/Job field in the Budget Folder. Is there a way to create this report with the new report builder?

Thanks,

Cathy McCown

[mhuffman]

Version 2009 release 2 supports Customer/Job and Item with the addition of a new combined Budget and Financial Component. This can also be used in Filters to filter both budget and financial amount columns by any field/records that can be assigned to budgets (or fields on those records, like a custom field on your customer record.)

[nzwyhun]

RE: How to Create Customer Budget vs Actual Report??

thank you!

we are in the process of doing our customer plans for 2010 and this was a big issue until now. tested it and it seems to work.

yeah!

[Author]

Posts