This Alert notifies the user when a price is put onto a Sales Order that is different than what is in the price list for the customer.
Purpose of the Alert:
The purpose of this alert is to monitor users that have the ability to override a price. If users have that ability, then they can change prices as they wish, use the wrong, price, etc. The alert will help this issue by notifying the recipient of any sales orders with a price that is different than what is in the price list for the customer.
It is recommended to run this report each morning to see all the sales orders from the previous day.
Example Results / Scenario:
Here's a great example we hear a lot that this alert will help with:
"In our old system, we did orders on a spreadsheet, so our sales entry people had to go lookup the price and put it into the sheet. We had many sheets and they were always being updated all the time, so our users got in the habit of always going to look for the price and updating it. Now that we are in Orchestrated and we have centralized price lists, we want our users to not ever update the price on a sales order."
The Alert will help with the above scenario, because it will notify the recipient anytime a user changes the price on a sales order to something that is different than what is on the price list.
This Alert Displays Sales Orders that have a Document Price that
Than the Price list
the Business Partner
It will show documents that have been updated
-- Here you can set the number of days prior to today that
-- will display in the alert
-- Replace this value (original value is 7)
-- These are the columns that will be displayed
'Price List Price'
, (T1.[Price] - T3.[Price])
-- Here are the tables the data comes from
T1.[DocEntry] = T0.[DocEntry]
T2.[CardCode] = T0.[CardCode]
T3.[ItemCode] = T1.[ItemCode]
T3.[PriceList] = T2.[ListNum]
T0.[UserSign] = T4.[USERID]
T0.[UserSign2] = T5.[USERID]
T1.[Price] <> T3.[Price]
,T0.[UpdateDate] , GETDATE()) <= @NumDays