You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

List Price is coming from different fields of the same table QP_MATRIX_RULES

edited Jul 11, 2024 6:50AM in Pricing 2 comments

Summary:

We need a report displaying Price lists, Base Price, List Price & Customer details.

We have observed that List Price is coming from different fields of the same table QP_MATRIX_RULES for different price lists . Similarly, Customer id is also pointing to different fields. We have used BI Publisher data model to build report but as the column for List Price/ Customer id is not consistent , our report is not returning expected/correct results. Can you please help how to handle this or suggest any alternative approach.

For example :

For Price List_1
Column holding Adjusted Price Value = value_number2

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!