D365 Finance & Operations and Dynamics AX Forum

Expand all | Collapse all

Cannot "deliver remainder" on TO lines

  • 1.  Cannot "deliver remainder" on TO lines

    Posted Jan 03, 2020 01:34 PM
    Hi everyone

    We are having an issue when we are attempting to cancel the ship remain of a TO.  We are on AX 2012 CU11 and this is an intermittent issue that we cannot determine the issue behind it.

    The scenario is that the TO has been released to the warehouse and then has been short picked (using an RF or GUI) all the lines have been closed on the work and the TO has been shipped (using the confirm shipment on the work)

    When we attempt to remove the under picked to release the reservation that this TO has on the inventory using functions deliver remainder, cancel quantity we receive the following error

    Reservations cannot be removed because there is work created which relies on the reservations.

    There were other lines on this TO that we were able to use this function and remove these remainder amounts.

    The TO can be shipped and received at the other warehouse locations, but we would like to have the reservation removed and then the status of the TO changed to be Received.  Currently they stay in Created status.







    ------------------------------
    Todd
    ------------------------------
    The first step toward cloud success. - Migrate from AX to D365 with expert guidance from Microsoft. I'm Ready


  • 2.  RE: Cannot "deliver remainder" on TO lines

    Posted Jan 03, 2020 01:46 PM
    I have attempted to "reduce Picked Quantity" on the Load, and also delete the line on the shipment.  None of the options on the AX client seem to work for me.

    ------------------------------
    Todd Bartlem
    Saje Natural Wellness
    Vancouver BC
    ------------------------------

    The first step toward cloud success. - Migrate from AX to D365 with expert guidance from Microsoft. I'm Ready


  • 3.  RE: Cannot "deliver remainder" on TO lines

    Posted Jan 06, 2020 07:33 AM
    Just throwing out options here... Have you tried going to Inventory > Reservations on your transfer order to take the remainder back to 0. This should take the reservation off. I'm assuming it didn't create the work ID's for the remainder you are trying to cancel.

    ------------------------------
    Kathy Hance
    ERP Support/MFG Steward
    Bush Brothers & Company
    Knoxville TN
    ------------------------------

    The first step toward cloud success. - Migrate from AX to D365 with expert guidance from Microsoft. I'm Ready


  • 4.  RE: Cannot "deliver remainder" on TO lines

    D365UG/AXUG ALL STAR
    Posted Jan 06, 2020 08:03 AM
    Before you ship it, you should cancel any lines not picked, then on the transfer order lines do a cancel on the delivery remainder. then ship. This should work, the other option is to do exactly as suggested and once you ship it, remove the reservation to clear the delivery reservation.

    ------------------------------
    Paul Martin
    Production Program Manager
    Elite Comfort Solutions, LLC
    Rutherfordton NC
    ------------------------------

    The first step toward cloud success. - Migrate from AX to D365 with expert guidance from Microsoft. I'm Ready


  • 5.  RE: Cannot "deliver remainder" on TO lines

    Posted Jan 06, 2020 11:10 AM
    Hy Kathy

    Yeah, I have attempted to remove the reservation, it gives me the error

    Reservations cannot be removed because there is work created which relies on the reservations.

    But still there is no work

    ------------------------------
    Todd Bartlem
    Saje Natural Wellness
    Vancouver BC
    ------------------------------

    The first step toward cloud success. - Migrate from AX to D365 with expert guidance from Microsoft. I'm Ready


  • 6.  RE: Cannot "deliver remainder" on TO lines

    SILVER CONTRIBUTOR
    Posted Jan 06, 2020 08:50 AM
    Good morning,

    we've experienced similar behaviour from load lines linked to sales orders on AX 2012 R3 CU12 and it seems like there is a bug when you reverse picking on those lines.  Look at the WHSLoadLine table in the AOT and compare all quantity related fields for that specific line.  They must match what's really been picked and if they don't, you'll get that same error message when trying to cancel the deliver remainder on the lines.  I've started looking for a hotfix in CU13 but haven't confirmed if this is fixed yet. So far, my resolution is always manual when this situation occurs.

    Hope this helps,


    ------------------------------
    Yvan Charbonneau
    Senior Director of Information Systems and Supply Chain
    Laboratoire Riva Inc
    Blainville QC Canada
    ------------------------------

    The first step toward cloud success. - Migrate from AX to D365 with expert guidance from Microsoft. I'm Ready


  • 7.  RE: Cannot "deliver remainder" on TO lines

    Posted Jan 06, 2020 11:13 AM
    Hi Yvan

    What to you do manually to fix this?  I cannot seem to update any of those QTY fields in the AOT.

    Thanks for the help

    ------------------------------
    Todd Bartlem
    Saje Natural Wellness
    Vancouver BC
    ------------------------------

    The first step toward cloud success. - Migrate from AX to D365 with expert guidance from Microsoft. I'm Ready


  • 8.  RE: Cannot "deliver remainder" on TO lines

    SILVER CONTRIBUTOR
    Posted Jan 06, 2020 11:28 AM
    Hi Todd,

    I usually just execute an update_recordset statement to fix the quantity fields directly from the table browser window.  Not too convenient for it to be resolved by a regular user, needs AOT access, but it doesn't happen often so it hasn't been a real nuisance yet.  I hope to find a hotfix for this though, but I don't have much hope with D365 being the latest version and AX 2012 support coming to an end relatively soon.  If I don't find an official fix, we'll have to do a customization to prevent this from happening.

    Best regards,


    ------------------------------
    Yvan Charbonneau
    Senior Director of Information Systems and Supply Chain
    Laboratoire Riva Inc
    Blainville QC Canada
    ------------------------------

    The first step toward cloud success. - Migrate from AX to D365 with expert guidance from Microsoft. I'm Ready


If you've found this thread useful, dive deeper into User Group community content by role