How to get the Base Price of an Item from the Price List corresponding to the Customer Ship to Site — Cloud Customer Connect
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

How to get the Base Price of an Item from the Price List corresponding to the Customer Ship to Site

in Reporting and Analytics for SCM

Summary:

Hello All,

Could you please help me to get the base price of an item from the Price List corresponding to the Customer Ship to Site. And I have prepare an query, but it is giving me the multiple base price of an single Item.

Navigation : Order Management→ Pricing Administration → Manage Pricing Strategy→ Search the Name of Pricing Strategy→ Go to Segment Price List → click on name → Price List Line → Select Line Type as Buy → Select the Item Name → Go to the Base Price of an Item


SELECT HCA.ACCOUNT_NAME Customer_Name,
HCA.ACCOUNT_NUMBER Customer_Account,
HCSU.LOCATION Ship_To_Site,

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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