1. Get rid of all advertisements and get unlimited access to documents by upgrading to Premium Membership. Upgrade to Premium Now and also get a Premium Badge!

Quantity cannot be greater than original ordered quantity

Discussion in 'Oracle CRM' started by Bharat, Jun 25, 2012.

  1. Bharat

    Bharat Community Moderator Forum Guru

    Messages:
    1,747
    Likes Received:
    147
    Trophy Points:
    1,805
    Location:
    Vijayawada, India
    Hi all,

    While we are trying to book the sales order which is of Warranty Replacement Order type that order is not getting booked and getting error message as shown below:

    quantity cannot be greater than original ordered quantity

    We are having 8 lines with same item with different quantity. Error message is showing only for 1st and 7th lines. The order is fulfilled and closed at lines and headers level also.

    Can anyone help in this.
     
  2. Ramji

    Ramji Forum Guru

    Messages:
    525
    Likes Received:
    177
    Trophy Points:
    1,505
    Location:
    Nomad
    Bharathappa,

    Try this. define over return tolerance at item master level .
    cheers
    Ramji
     
  3. Bharat

    Bharat Community Moderator Forum Guru

    Messages:
    1,747
    Likes Received:
    147
    Trophy Points:
    1,805
    Location:
    Vijayawada, India
    Hi ramji,

    I have closed order with quantity of 10 for one item. Now Iam trying to return 12 quantity as giving reference of that sales order which is having 10 quantity. So I have changed over Return tolerance to 50 and as well changed at profile option (OM: Over Return Tolerance = 50). But its showing same error as "Quantity cannot be greater than original ordered quantity."
     
  4. Ramji

    Ramji Forum Guru

    Messages:
    525
    Likes Received:
    177
    Trophy Points:
    1,505
    Location:
    Nomad
    Bharatappa,

    Thats two down , one to go. Org parameters uncheck overpicking and retry.
    cheers
    Ramji
     
  5. Bharat

    Bharat Community Moderator Forum Guru

    Messages:
    1,747
    Likes Received:
    147
    Trophy Points:
    1,805
    Location:
    Vijayawada, India
    Hi ramji,

    I have unchecked for overpicking for transfer orders enabled option at master level and child organization level also. But its not working and again pushing same error.
     
  6. Ramji

    Ramji Forum Guru

    Messages:
    525
    Likes Received:
    177
    Trophy Points:
    1,505
    Location:
    Nomad
    Bharat,

    Return Item Mismatch profile value , can you see what it is?
    cheers
    Ramji
     
  7. Ramji

    Ramji Forum Guru

    Messages:
    525
    Likes Received:
    177
    Trophy Points:
    1,505
    Location:
    Nomad
    Dear Bharat,

    I believe the split lines is causing this issue. Change the return reference and try. Give it a go. This was an old bug. Not sure if they fixed it in R12.1
    cheers
    Ramji
     
  8. Bharat

    Bharat Community Moderator Forum Guru

    Messages:
    1,747
    Likes Received:
    147
    Trophy Points:
    1,805
    Location:
    Vijayawada, India
    That was set to "allow" value.
     
  9. Bharat

    Bharat Community Moderator Forum Guru

    Messages:
    1,747
    Likes Received:
    147
    Trophy Points:
    1,805
    Location:
    Vijayawada, India
    Okay Ramji, I will check in that scenario.
     
  10. Bharat

    Bharat Community Moderator Forum Guru

    Messages:
    1,747
    Likes Received:
    147
    Trophy Points:
    1,805
    Location:
    Vijayawada, India
    Hi ramji,

    Scenario1: -My actual scenario was, Iam doing sales order with 5 quantity for 1 item and shipped with 5 quantity and closed the sales order. Now I have created return sales order for this order with 7 quantity to return. Is it possible to do.

    Scenario2: -As we discussed so far I came know that if we set over shipment tolerance and over return tolerance for an item, it's possible to ship more than the ordered quantity and we can return that amount which we was shipped. I got working this one.

    Actual my scenario was as stated above scenario1. Please guide me to do that if possible.
     
  11. Ramji

    Ramji Forum Guru

    Messages:
    525
    Likes Received:
    177
    Trophy Points:
    1,505
    Location:
    Nomad
    Dear Bharat,

    Logically when you reference a Line and return more than what was shipped it wil not be possible to do the return of 7 against 5 originally shipped.

    The only bug I had come across when multiple shipments existed for the 5 originally shipped and then you were referencing a return to one of those lines and returning 7 and the same error was encountered.

    So basically the work around will be to split the 7 into 5 and 2 and process your returns. Logically too if you think deeper your transactions should be ipsofacto and not notional. How can you return 7 against a shipment of 5 when actually you have shipped 5. Will any business define an over return tolerance for the sake of it. You sold a dozen eggs and just for processing a return you define a tolerance and accept 22 eggs in return against the 12 you shipped? Give me a business scenario to justify such a transaction. I think absurd isnt it?
    cheers
    Ramji
     
  12. Bharat

    Bharat Community Moderator Forum Guru

    Messages:
    1,747
    Likes Received:
    147
    Trophy Points:
    1,805
    Location:
    Vijayawada, India
    Thank you ramji, Now its clear for me about these over shipment/return tolerances concept.
     
    Ramji likes this.
  13. Bharat

    Bharat Community Moderator Forum Guru

    Messages:
    1,747
    Likes Received:
    147
    Trophy Points:
    1,805
    Location:
    Vijayawada, India
    Hi ramji,

    I have followed the entire process and identified that if we ship more than ordered quantity just like I ordered 5 and shipped 8 but in inventory its reducing only 5. Can I know whats happening here. What is the concept of over shipment tolerance and how its working here in my scenario.
     
  14. Ramji

    Ramji Forum Guru

    Messages:
    525
    Likes Received:
    177
    Trophy Points:
    1,505
    Location:
    Nomad
    Dear Bharat,

    When you shipped 8 how much was the tolerance set at?
    cheers
    Ramji
     
  15. Bharat

    Bharat Community Moderator Forum Guru

    Messages:
    1,747
    Likes Received:
    147
    Trophy Points:
    1,805
    Location:
    Vijayawada, India
    Tolerance was set at 100 for that item at master level.
     
  16. Ramji

    Ramji Forum Guru

    Messages:
    525
    Likes Received:
    177
    Trophy Points:
    1,505
    Location:
    Nomad
    Bharatappa,

    I believe your parameters need to be checked. There is a new feature in R12
    In R12 Retain Unstaged Quantity during Over shipment or Under shipment is a new feature. Check Step 5 last parameter. What did you use?

    For Overshipment
    1. Order Qty 100 (tol set at 20%)
    2. Book order
    3.Query in Shipping transaction Frm
    4.Manually split delivery into 90 and 10
    5.Pick Release with (A Alloc=y , A pk cfrm =y and auto create del=n) you want to do the move order manually
    6.In Move transact order go to the line with 90 u and update to 105 and press transact
    7.staging will take place with 105 and the other line will not be cancelled even though the 20% tolerance has been met. In 11i
    the 10 u line will get cancelled.
    8.ship confirm and run interface trip stop and you will have the line with 10 u.
    cheers
    Ramji
     
  17. Bharat

    Bharat Community Moderator Forum Guru

    Messages:
    1,747
    Likes Received:
    147
    Trophy Points:
    1,805
    Location:
    Vijayawada, India
    What I did is:

    For item set over shipment tolerance to 100 and saved the item and assigned to sub-organization

    Now booked the order with that item and Qty taken is 5.
    picked the sales order using pick release form (Release sales order)
    Then went to shipping transactions form and then entered shipping Qty to 8 and went to delivery tab and shipped the order.
    By this order is shipped.

    After that I have checked in onhand Qty for that item. In that Qty is reduced by 5 itself. That was I have faced problem.
     
  18. Ramji

    Ramji Forum Guru

    Messages:
    525
    Likes Received:
    177
    Trophy Points:
    1,505
    Location:
    Nomad
    Ok will check and let you know.
    cheers
    Ramji
     
  19. Bharat

    Bharat Community Moderator Forum Guru

    Messages:
    1,747
    Likes Received:
    147
    Trophy Points:
    1,805
    Location:
    Vijayawada, India
    Okay bhayya, Thanks for that.. I will try your explanation in instance tomorrow.
     
  20. Ramji

    Ramji Forum Guru

    Messages:
    525
    Likes Received:
    177
    Trophy Points:
    1,505
    Location:
    Nomad
    I remember a check box somewhere, let me see if I can figure it out.
    cheers
    Ramji