GP2013 R2-Needing to cancel a PO qty created off a Requisition

(0) Share

Report

Posted on by Community Member

Hi Folks. I'm on GP2013 R2. I'm not using workflow. I'm not using the POP and SOP commitment functionality. I've created a requisition and have converted that to a Purchase Order. In the PO, I would now like to cancel the qty ordered but I receive a message saying that the line can't be cancelled as the remaining qty does not satisfy the commitmens for this line item. Does anyone know how I can cancel the qty in the PO please?

Many thanks

*This post is locked for comments

I have the same question (0)

All responses (18)

Answers (1)

Suggested answer

Mahmoud Saadi 32,738 on at

Like (0)

Report

I believe this has nothing to do with the Purchase Order Commitment, this might be committed to Sales Order. Is the "Allow Document Commitment " option is checked on the PO ?

Your feedback is highly appreciated,

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Hi Mahmoud. Thank you for your interest. I have unticked that option on the PO screen but that screen was built up by the system when the Requisition was converted to a PO. What I have noticed is that there is Sales Commitment link indicator on the line but when I drill down on that it takes me to the Requisition. It is almost as if the system is using the code for the POP/SOP link functionality to actually build a link back to the Requisition.

Was this reply helpful? Yes No
soma 24,410 on at

Like (0)

Report

Select the line item on the PO entry window, and click the paper clip icon to delete the committed sales document and then change your ordered quantity.

Hope this helps!!!

Was this reply helpful? Yes No
Mahmoud Saadi 32,738 on at

Like (0)

Report

Marmeduke

The allow sales document commitment is something different than the link between a requisition and a purchase order. As you said, when you go through the window, you find the original requisition from which the PO has been generated.

The "Delete Sales Doc" is not allowed for requisitions, you will not be able to break the link defaulted from requisitions.

For the mean time, you may consider voiding the PO, until further testing leads us to how cancelling line items on PO originating from a requisition is applicable.

Keep us posted,

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Hi Guys. You cannot delete or void the PO either - you will receive the same message. As there is no SOP document linked to my PO line, there is no link for me to break. The only link that the line has is to the Requisition.

This seems quite broken to me.

Any further suggestions would be appreciated.

Was this reply helpful? Yes No
Mahmoud Saadi 32,738 on at

Like (0)

Report

I have already mentioned that you can not break the link, it is not allowed for requisition and this suggestion will not work

Do you have too many line items on the Purchase Orders ? Are you looking to cancel one line and keeping others on the PO ?

Was this reply helpful? Yes No
Community Member on at

Like (1)

Report

Hi Mahmoud. Fortunately I am in my test environment where I have to test the new functionality for my clients before we can do any upgrades. I'm doing a Requisition for a qty of 3 and only after I have converted it to a PO do I need to reduce the qty by 1. That is where I've now discovered that it doesn't work.

Thank you

Was this reply helpful? Yes No
Suggested answer

Mahmoud Saadi 32,738 on at

Like (0)

Report
You may consider a work around to update the field on the database level, here is my testing sceanrio:

Created a requisition for item (XXX),

Quantity Requisitioned: 12

Generated a purchase order from the original requisition

Quantity Ordered: 12

Quantity Canceled: 0

Cancelling the quantity is not applicable for requisition, (I currently do not have a proper justification for this issue, further testing could help find out the reason). Although, to get this solved, I updated the field

UPDATE dbo.POP10110 SET QTYCANCE = 4 WHERE PONUMBER = 'PO2076' AND ITEMNMBR = '128 SDRAM'

Going back to the requisition and purchase order window, everything looks fine. Then, I proceeded with receiving the purchase order, and the quantity available to be received and invoiced is (Quantity Ordered - Quantity Canceled ) 12-4 = 8 , as expected.

Furthermore, the purchase order reconciliation and check links were run with no issues found out at all.

Your feedback is highly appreciated,

Was this reply helpful? Yes No
Community Member on at

Like (1)

Report

Hi Mahmoud. Many thanks for all your input. What is concerning for me is that I would have expected someone else to have come across this already. This is quite a big difference from the functionality that exists currently in GP2010.

Thanks again

Was this reply helpful? Yes No
Verified answer

Mahmoud Saadi 32,738 on at

Like (0)

Report

Hello again Marmeduke,

The requisition management has been newly built in Dynamics GP 2013 R2, with new workflow engine and complete different design. It is still under testing and several issues arise.

Throughout our testing scenarios, we have found out and reported few issues. We expect to have them settled in the upcoming version of Dynamics GP, it still needs time to get settled.

For the mean time, I would kindly ask you to close the case by verifying the answer if it meets your inquiry.

Your feedback is highly appreciated,

Was this reply helpful? Yes No