Need to create simple Query

[former_member269992]

Hello All,

I want to create an Query to generate PO Items in which we have cancelled the qty or changed the qty.

DocNo.,   Item,  Qty , CancelledQty or Changed Qty.

Please help to create this query.

Thanks & regards,

Hitul

[kothandaraman_nagarajan · Accepted solution]

Hi,

Please refer this thread for changed quantity:

Query to find the Changes made in PO | SCN

Thanks

[frank_wang6]

to be honest, this is not a simple query, basically you will have to look up all history table and find those POs and self join them with each loginstance (history copy) and find out if the quantity are changed.

Considering some POs might be changed many times, such as 10 times, in order to find out if the quantity has been changed in one of them, it will be painful.

Anyway, you might use store procedure to implement, the logic there might be too hard to use a query, but no matter what, it will be a very complicated one.

Frank

[Rafaee_Mustafa]

Dear Hitul,

Did you create any UDF for cancel or change QTY ?? Because SBO dont have such facility or you can check if it record in history table.

- Rafaee M