PO Line Ordered Quantity

  • PO Line Ordered Quantity

    Posted by DSC Communities on February 14, 2017 at 4:29 pm
    • Jim Czerniak

      Member

      February 14, 2017 at 4:29 PM


      I have a PO line in AX and I’m trying to figure out how I can cancel the “Ordered” quantity.  If you see the screen shot below it is showing 1.00 “Ordered”.  

      ——————————
      Jim Czerniak
      Applications Developer
      CMC Group
      Bowling Green OH
      ——————————

    • Sherry Moran

      Member

      February 15, 2017 at 9:36 AM

      Jim,

      We see this regularly, it seems to happen if the buyer reduces the order quantity after the PO line has been partially received in our case.  We’re 2012 R2 cu7.  Have you tried on the line level Update Line –> Deliver Remainder –> Cancel Quantity?  If you have like we have you may find that errors.  In that event what we’ve found is there is a hanging “Ordered” line in the InventTrans table.  As Administrator/DB I go through the AOT to the InventTrans table, find the “Ordered” transaction that is still there for the PO Line and I delete it (alt F9).  This won’t change the status of your line so if your line isn’t status “Invoiced”  you’ll need to address that as well.

      Sherry

      ——————————
      Sherry Moran
      SR Business Systems Analyst
      Key Technology, Inc
      Walla Walla WA
      ——————————
      ——————————————-

    • Amanda Harris

      Member

      April 26, 2017 at 11:33 AM

      Hi-

      We just upgraded from AX 2012 R3 CU8 to CU11 and we are unable to cancel the deliver remainder on a line, either by closing the line when posting the product receipt, or by choosing the option to update / cancel deliver remainder on the PO line. This appears to be a universal problem for us now any time a PO is delivered short. The buyers are not editing the POs, so I don’t think that’s what is causing the problem. Every time we try the transaction though we get the error message that “Quantity ordered cannot be reduced because there are not enough open inventory transactions with the ordered status.” I’ve looked at the inventory transactions for the item though, and it all looks to be in order. We didn’t have this problem before upgrading to CU11. Any ideas?

      ——————————
      Amanda Creedon
      IT Business Analyst
      Kayem Foods Inc.
      Chelsea MA
      ——————————
      ——————————————-

    • geoff mcmaster

      Member

      February 15, 2017 at 1:38 AM

      Sorry, spotted a slight error…now corrected

       

      Hi Jim

       

      There are two options to do what I believe you want, through the AX Client (and these work on both Sales Orders and Purchase Orders):

       

      1. Change the ‘Quantity’ on the line, in your scenario, from ‘2’ to ‘1’, and save the line, that will:
      2. Set the line to fully delivered
      3. Show 0 as qty still on order
      4. And make the line look like you first ordered 1 (and not 2)
      5. Use the function under ‘Update Line / Update / Deliver Remainder’:
      6. Select that line and choose as above
      7. Two options here:
      8.                                                                i.      Set field ‘Deliver remainder’, which has value 1 (1 still on order) to zero, then click OK
        or

                                                                     ii.      Click on ‘Cancel quantity’

      1. In your scenario, both of above options will have the same result:

                                                                     i.      The Quantity ordered will still show as 2

                                                                   ii.      But the PO Line status will again show fully delivered

                                                                 iii.      And show 0 as Qty still on order

       

      The main difference between the two options is what the field ‘Quantity’ shows… in option 1 it gets changed to 1, in option 2 it still shows 2 were ordered, one received and you won’t get the other remaining piece delivered.

       

      Let me know if you can’t get the above to work.

       

       

      Best regards

      Geoff McMaster

       

      ——Original Message——

      I have a PO line in AX and I’m trying to figure out how I can cancel the “Ordered” quantity.  If you see the screen shot below it is showing 1.00 “Ordered”.  

      ——————————
      Jim Czerniak
      Applications Developer
      CMC Group
      Bowling Green OH
      ——————————

    • Corey Chesney

      Member

      February 16, 2017 at 12:40 PM

      Option 2 is the best as that would meet your auditory requirements, amending purchase orders could cause suspicious fraudulent behavior by the auditors
      That’s based on our security requirements at my place of work

      ——————————
      Corey Chesney
      Warehouse Supervisor
      Ports of Auckland Ltd
      Auckland
      ——————————
      ——————————————-

    • Paul Martin

      Member

      February 16, 2017 at 8:09 AM

      additionally on the PO receipt you can click the close on the line level and it will cancel the remainder for you

      ——————————
      Paul Martin
      Expert ERP Analyst
      TempurSealy Inc.
      Trinity NC
      ——————————
      ——————————————-

    • geoff mcmaster

      Member

      February 15, 2017 at 1:33 AM

      Hi Jim

       

      There are two options to do what I believe you want, through the AX Client (and these work on both Sales Orders and Purchase Orders):

       

      1. Change the ‘Quantity’ on the line, in your scenario, from ‘2’ to ‘1’, and save the line, that will:
      2. Set the line to fully delivered
      3. Show 0 as qty still on order
      4. And make the line look like you first ordered 1 (and not 2)

      5. Use the function under ‘Update Line / Update / Deliver Remainder’:
      6. Select that line and choose as above
      7. Two options here:
      8.                                                                i.      Set field ‘Deliver remainder’, which has value 1 (1 still on order) to zero, then click OK
        or

                                                                     ii.      Click on ‘Cancel remainder

      1. In your scenario, both of above options will have the same result:

                                                                     i.      The Quantity ordered will still show as 2

                                                                   ii.      But the PO Line status will again show fully delivered

                                                                 iii.      And show 0 as Qty still on order

       

      The main difference between the two options is what the field ‘Quantity’ shows… in option 1 it gets changed to 1, in option 2 it still shows 2 were ordered, one received and you won’t get the other remaining piece delivered.

       

      Let me know if you can’t get the above to work.

       

       

      Best regards

      Geoff McMaster

       

      Geoff McMaster, Premier Field Engineer – Dynamics AX
      Customer Service and Support, Microsoft Services

      P: +617 3218 7049

      gmcmast@microsoft.comhttp://www.microsoft.com/microsoftservices

      image003.png@01D03BD6.CADAA030

       

       

       

      ——Original Message——

      I have a PO line in AX and I’m trying to figure out how I can cancel the “Ordered” quantity.  If you see the screen shot below it is showing 1.00 “Ordered”.  

      ——————————
      Jim Czerniak
      Applications Developer
      CMC Group
      Bowling Green OH
      ——————————

    DSC Communities replied 8 years, 6 months ago 1 Member · 0 Replies
  • 0 Replies

Sorry, there were no replies found.

The discussion ‘PO Line Ordered Quantity’ is closed to new replies.

Start of Discussion
0 of 0 replies June 2018
Now

Welcome to our new site!

Here you will find a wealth of information created for peopleĀ  that are on a mission to redefine business models with cloud techinologies, AI, automation, low code / no code applications, data, security & more to compete in the Acceleration Economy!