AR Invoice Unit price/Discount change
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.
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]%'