cancel
Showing results for 
Search instead for 
Did you mean: 

Query Specific For Accounts With BP Property Selected

Former Member
0 Kudos

Hello -

Can someone help us with a query that pulls only accounts that have BP Properties selected and then shows the Total 2012 Monthly Sales (Invoices) for each of those accounts?

Thanks,

Mike

Accepted Solutions (0)

Answers (1)

Answers (1)

Former Member
0 Kudos

Hi Mike,

BP Properties are 64 individual fields. You can only select a fixed property such as BP Property 2 instead of a free selection.

Thanks,

Gordon

Former Member
0 Kudos

Sorry - I meant I want to show only those accounts that have BP Property #2 selected "Y" with each 2012 Month Sales (Invoices) for each of those accounts?

Thanks,

Mike

Former Member
0 Kudos

Hi Mike,

You can use the standard sales analysis report for this. Choose the BP property '2', and select the option to run the report by months. Ensure you have a date range from the beginning to the end of 2012 as your date range.

Regards,

Kiran

Former Member
0 Kudos

You just need to add condition QryGroup2 = 'Y' to the current query.

Former Member
0 Kudos

What current query?

Mike

Former Member
0 Kudos

The query that I gave you long times ago.

Former Member
0 Kudos

Gordon - I don't think we have a query that gives monthly sales based on BP property selection. There are some for monthly sales but not by BP Property.

Thanks,

Mike

Former Member
0 Kudos

There is only a simple change to add a where clause under the same report.