Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Dynamics 365 Community / Forums / Microsoft Dynamics AX (Archived) / Reduce picked quantity...
Microsoft Dynamics AX (Archived)

Reduce picked quantity - Sales and transfer orders

(1) ShareShare
ReportReport
Posted on by Community Member Microsoft Employee

Hi all,

I have met with an issue which I couldn't solved. I'm working on a customer, a user has released to warehouse a sales order, manually assigned it to a wave, proccessed and released it, complete the work created through the mobile device (the web emulator), confirm the shipment but somehow the quantities picked aren't at baydoor location. Instead they are on the user-location without being reserved. Quantity isn't updated to "picked" status so it's not possible to post packing slip using the "Picked" option. It's not possible to post the Invoice neither.

I thought at first that someone has used the "Reduce picked quantity" button on shipments without checking the "Remove unpicked quantity" check box:

Captura01.JPG

Is there anyway to "Remove unpicked quantity" from the shipment after someone has used that functionallity without checking that check box?

I'm stuck on a situation right now where I can't delete Shipments or Load lines because work has been created; I can't quit the reservation on the sales order beacuse work has been created; if I tried to reduce picked quantity I got an error message telling me that quantities have already been reversed.

I'm getting the same behaviour on transfer orders (not all of them, just a few).

If somebody has any idea of what could have happened, please tell me.

*This post is locked for comments

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Reduce picked quantity - Sales and transfer orders

    Hi Qaisar.

    The first solution I can tell you is to upgrade at least to CU10 or CU11 version because many of these are bugs that have already been solved.

    The "Quantity is not valid" message you are receiving I think is due to a wrong entry of data.

    You need to access first to an "Inventory movement" menu item. Then I would advice you to insert the LP related to the items on your user location. Press enter. If there are more than one item, then you will need to insert the item code. Press enter.

    Always press enter before any data you insert so AX can suggest the rest.

    If you have changed the "user location profile" on the Warehouse Management parameters then change it back so the location profile there is the same for your user location.

    Another alternative you can try is to manually edit your transfer orders so it matches the shipment quantities to delete reservation (you can also use the "Deliver remainder" function to remove reservation and get your TO to "Shipped" status). By deleting reservations, you could adjust the quantities. I'm not sure if you can do and adjustment on a user location but you can easily check that.

    Hope that helps.

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Reduce picked quantity - Sales and transfer orders

    Hi Nick Holden,

    Thanks for your help it's really helpful.

    As you asked about AX version I am  using on CU8.

    However I would like to share some of my findings with you.

    As you mentioned, I am follow all the steps to post the confirm shipment leading to post the transfer order shipments. After confirm shipment system ship the transfer order quantity except the work line quantity which status is still " Physical Reserved" and my transfer order status is also open. Now I am transfer the quantity from user location to another location for again shipment through warehouse movement or adjustment process but getting the error " Quantity is not valid" I also have changed user location profile in warehouse parameters but no luck. Could you please suggest the steps how transfer the quantity from user location to another or make inventory adjustments to release the inventory from user location.

    Please also suggest is there any solution to get rid of the " Insufficient Inventory Transaction with status on order reserved order and reserved Physical Issue" while post confirm shipment.

    Looking forward for your reply.

    Thanks

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Reduce picked quantity - Sales and transfer orders

    Hi Qaisar Khan,

    Just to know, which AX version are you working on? I think that to avoid it to keep on happening you need to reproduce it on a test environment to report it to Microsoft, because I'm almost sure (according to what you say) that it could be a bug.

    However, for the shipment and work that are "stucked", I can tell you how I fixed them. First you need to check on a "Transactions" inquiry if you see a "Physical reserved" transaction related to the transfer order work on the user location. If that is the case, and your work status is "Closed", then it means that the transactions were incorrectly updated after the work was closed.

    You can access (through the AOT) to the WHSWorkTable and manually update the "WorkStatus" field from "Closed" to "Open". Close the AOT, and then go to "Warehouse Management -> Common -> Work -> All work". There you look for your work and clic the "Cancel work" button. By doing that, AX itself will clean the remaining transactions and your items will be "free" again. Later you need to manually (through a Mobile Device inventory movement menu item) moved them from your user location to any other location. Then create a new transfer order. Be careful because if it happened once, it could happen again, that's why I consider important to reproduce the error on a test environment to see why it is being incorrectly updated.

    Of course I cannot guarantee that what I have done is correct, it's just a "trick" I found to avoid deleting records from a lot of tables. However I can tell you that I haven't had any problem with that. Obviously, I strongly recommend you to check this first on a test environment.

    If you want you can post pictures of your setups (Location directives, Work templates, Warehouses, Locations and Items) to see if I can see anything wrong.

    Hope that helps.

    Regards.

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Reduce picked quantity - Sales and transfer orders

    Hi Nick, Thanks for your reply!

    I have replied on the behalf of Muhammad. In our scenario we haven't enabled batch, however my transfer order work is also being closed and when I am going to confirm shipment then system generate the error "Insufficient inventory transaction with status on order, reserved order and reserved Physical and then Picked" and then at the same time I'm unable to short Pick or cancel the deliver remaining quantities because of still my work is not in shipped status.

    Thanks,

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Reduce picked quantity - Sales and transfer orders

    Hi Muhammad. It was a bug from AX when you have to pick the same batch id from different locations (and your item has batch above location on the reservation hierarchy).

    Microsoft released a KB, however (as far as I can remember) the problem can be solved using the "Delivery remainder" from sales or transfer orders.

    Hope this helps.

  • Muhammad umer Profile Picture
    Muhammad umer on at
    RE: Reduce picked quantity - Sales and transfer orders

    any luck on this issue?

  • Suggested answer
    Facundo Costabile Profile Picture
    Facundo Costabile 345 on at
    RE: Reduce picked quantity - Sales and transfer orders

    People, I found a KB that solve this error. I'm working with AX2012 R3 CU10. I installed it and it woks fine! The solution is the KB 3197775 Not able to reduce picked quantity on load to a non-license plate controlled location.

    Hope you work too!

  • Facundo Costabile Profile Picture
    Facundo Costabile 345 on at
    RE: Reduce picked quantity - Sales and transfer orders

    Hi everybody! I'm having a similar behavior... I have a shipment whose status is Loaded. The work is closed, and the Baydoor location is LP controlled location. I want to reduce the picked quantity. If i select a location with non LP controlled in the Move to location field, I receive the message "License plate specified on a non-license plate controlled location", and if I select a LP controlled location I receive the message  "You cannot move inventory to a license plate controlled location."

    I'm stuck in this step and I cannot make this functionality works... Do you have any idea? Am I missing some configuration?

    As always, thank you for your help!! 

    Regards!

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Reduce picked quantity - Sales and transfer orders

    Hi BethT, for any reason shipment / load can't be assinged to the wave. They don't appear in the list.

    The shipment remains at "In process" status.

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Reduce picked quantity - Sales and transfer orders

    I thought maybe the Reverse Work option could have been what caused your problem to begin with.

    If the quantities are reserved, can you just re-wave your shipment and start again?  

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Congratulations 2024 Spotlight Honorees

Kudos to all of our 2024 community stars! 🎉

Meet the Top 10 leaders for December

Congratulations to our December super stars! 🥳

Start Your Super User Journey

Join the ranks of our community heros! 🦹

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,703 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,433 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans