Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

AR Invoice Unit price/Discount change

Hi Experts,

I need your help regarding this....

In Sales A/R process of SAP B1 8.82, we first do sales order then copy to AR Invoice to process the invoice.

At some time users do the sales order and then copy to AR invoice and modify either unit price or discount as per the customer's requirement.

I need a query to get all these type of invoices where there is a either unit price change or discount change.

I found that any AR invoice update goes to ADOC and ADO1 table, but this table populates only when the AR invoice is saved once and then opened again and modify. but if the unit price or discount has been changed at first and saved then these table does not populate.

So how can I get this changes log, from which table so that I can frame the query.

Your assistance is highly appreciated.

Rgds

Suman

Former Member replied

Hi Suman,

Try:

SELECT T0.[CardCode], T0.[CardName], T3.[DocNum] as 'Sales Order No', T3.[DocDate] as 'Sales Order Date',

T0.[DocNum]as 'Invoice No',T0.[DocDate] as 'Invoice Date', T1.ItemCode, T1.[Price] 'Price from order', T2.Price 'Price from invoice',  T1.[DiscPrcnt] 'Discount from order row',T2.[DiscPrcnt] 'Discount from Invoice row' ,T0.[DiscPrcnt] 'Discount from order', T3.[DiscPrcnt] 'Discount from Invoice'

FROM OINV T0

INNER JOIN INV1 T1 ON T0.DocEntry = T1.DocEntry

INNER JOIN RDR1 T2 ON T1.[BaseEntry]= T2.[DocEntry] and T2.[TargetType] =13 AND T1.BaseLine=T2.LineNum

INNER JOIN ORDR T3 ON T2.DocEntry = T3.DocEntry

WHERE T1.[Price] <> T2.[Price]  AND T0.CardName Like '%[%0]%'

Thanks,

Gordon

0 View this answer in context
Not what you were looking for? View more on this topic or Ask a question