PO Line Ordered Quantity
-
PO Line Ordered Quantity
Posted by DSC Communities on February 14, 2017 at 4:29 pm-
Jim Czerniak
MemberFebruary 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
—————————— -
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
MemberApril 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
MemberFebruary 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):
- Change the ‘Quantity’ on the line, in your scenario, from ‘2’ to ‘1’, and save the line, that will:
- Set the line to fully delivered
- Show 0 as qty still on order
- And make the line look like you first ordered 1 (and not 2)
- Use the function under ‘Update Line / Update / Deliver Remainder’:
- Select that line and choose as above
- Two options here:
i. Set field ‘Deliver remainder’, which has value 1 (1 still on order) to zero, then click OK
orii. Click on ‘Cancel quantity’
- 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
—————————— - Change the ‘Quantity’ on the line, in your scenario, from ‘2’ to ‘1’, and save the line, that will:
-
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
——————————
——————————————- -
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
MemberFebruary 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):
- Change the ‘Quantity’ on the line, in your scenario, from ‘2’ to ‘1’, and save the line, that will:
- Set the line to fully delivered
- Show 0 as qty still on order
- And make the line look like you first ordered 1 (and not 2)
- Use the function under ‘Update Line / Update / Deliver Remainder’:
- Select that line and choose as above
- Two options here:
i. Set field ‘Deliver remainder’, which has value 1 (1 still on order) to zero, then click OK
orii. Click on ‘Cancel remainder
- 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 ServicesP: +617 3218 7049
gmcmast@microsoft.com | http://www.microsoft.com/microsoftservices
——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
—————————— - Change the ‘Quantity’ on the line, in your scenario, from ‘2’ to ‘1’, and save the line, that will:
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.