Skip to Content

Need to create simple Query

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

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

3 Answers

  • Best Answer
    Posted on Jan 12, 2016 at 10:53 PM

    Hi,

    Please refer this thread for changed quantity:

    Query to find the Changes made in PO | SCN

    Thanks

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Jan 12, 2016 at 10:56 AM

    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

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Jan 12, 2016 at 04:11 PM

    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

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.