Issue in Pricing Report Creation - V/LA

[Former Member]

Dear All,

I have created a new pricing report in V/LA.

Details:

3 condition tables in the pricing configuration.

1-SO / DC / Customer / Sales district / Material

2-SO / DC / Customer / Material

3-SO / DC / Material

During report creation I select only "Material" field from the field selection screen & proceed with "AND" option.

From Table selection screen, I select all those 3 condition tables.

Now at executing of this report (In V/LD), I enter only "Customer" field (say customer 1000) in the selection criteria. (because I want to see all condition records exists for that customer 1000?

When I execute the report it shows below 3 sections.

1-SO / DC / Customer / Sales district / Material - All condition records exists for that customer/Sales District combination

2-SO / DC / Customer / Material - All All condition records exists for that customer

3-SO / DC / Material - All condition records maintained for Material level.

But as per my selection criteria, system should show only 1 & 2 sections.

How can I omit appearing sections 3 in my pricing report. ( Because I want to see condition records relevant to that customer only)

Highly appreciate all your suggestions !!

Thanks in advance !

Edited by: Anupa Wijesinghe on Sep 24, 2009 8:32 AM

Edited by: Anupa Wijesinghe on Sep 24, 2009 8:33 AM

[Former Member]

Since there is no other solutions, I'm closing this issue.

Thanks Matthew & all others for the support given !

[Former Member]

Your selection criteria of Customer is not relevant to table 3 and therefore you are getting all entries in Table 3. You can't filter out only that customers price records from this table since customer is not part of the key. This subsequently results in all entries in this table getting returned. If this is not your desired result I would create a seperate report for material pricing only that is not customer specific.

[Former Member]

Dear Matthew,

As per suggestion, I have to create 2 reports for the above requirement.

1- with only Customer tables to see customer level prices. (For this I have to add only below 2 tables)

- SO / DC / Customer / Sales district / Material

- SO / DC / Customer / Material

2- Other report to see material level prices. For that I have add all 3 tables.

- SO / DC / Customer / Sales district / Material

- SO / DC / Customer / Material

- SO / DC / Material

So with this when user want to see price by customer, he has to select FIRST report & when he want to select price by Material, he has to select SECOND Report.

It's not very user friendly, But yes, I can suggest it as a solution.

Thanks for your reply !

Really helpful !

[Former Member]

Hi

In the first screen in V/LD if you select 28 - conditions by customer, and in second selection screen if you give customer number only. You can get your required report

try and revert

[Former Member]

Thanks Yadav for the reply !,

This cannot be done as I'm using different set of condition tables & Report 28 is using different condition tables.