Query for which sales order lines has the discount or price been adjusted

[jeroenw]

Hi,

We are a company with a total of 10 branches. All branches work with sales orders. The employees at the branches have total control over sales orders. They can manually adjust discounts and prices on the customer order. This is also necessary and I therefore do not want to block it.

However, I would like to check the order lines that have been manually adjusted. This mainly concerns the price and the discount percentage. So I am looking for a query that shows me at line level which prices and discounts have been adjusted compared to the standard data entered in price lists, discount groups and special prices for business partners.

For example, an employee checks out a bag of apples. SAP automatically fills in the 20% discount percentage entered for item groups as standard. The employee adjusts the discount percentage to 30%.

Is something so simple to do? Or is this going to be a complicated query?

Thanks

[MKreitlein]

Hello @jeroenw.

I have no clue about Business One, but if you have also tables like CDHDR and CDPOS I would first check here if those changes can be found at all.

If yes, then you could work with those records. Otherwise... no idea 😉

BR, Martin

[SonTran · Accepted solution]

Hi,

System can detects any changes on price that is different to Price List Policy you set in the system

You can try this:

select T0.DocEntry, T0.DocNum, T1.ItemCode, T1.Dscription, T1.Quantity, T1.LineTotal 
from ORDR T0 join RDR1 T1 on T0.DocEntry=T1.DocEntry where SpecPrice='N'

Hope this helps,

Son Tran

[jeroenw · Accepted solution]

This is exactly what I was looking for! Thank you!

[jeroenw]

Unfortunatly SAP doesn't have these tables. Hope someone else can help me. Thanks anyway!