Error message when you move back order quantities to invoiced quantities for a sales order linked to a purchase order in Microsoft Dynamics GP: “You can’t change the Qty to Backorder because quantities for this line item are committed to a purchase or...


RAPID PUBLISHING

RAPID PUBLISHING ARTICLES PROVIDE INFORMATION DIRECTLY FROM WITHIN THE MICROSOFT SUPPORT ORGANIZATION. THE INFORMATION THAT IS CONTAINED HEREIN IS CREATED IN RESPONSE TO EMERGING OR UNIQUE TOPICS, OR IS INTENDED TO SUPPLEMENT OTHER KNOWLEDGE BASE INFORMATION.

SYMPTOMS

Note Before you follow the instructions in this article, make sure that you have a complete backup copy of the database that you can restore if a problem occurs. When you move back order quantities to invoiced quantities on a sales order that is linked to a purchase order, you receive the following error message:

You can’t change the Qty to Backorder because quantities for this line item are committed to a purchase order.

This behavior occurs if the following conditions are true:

• The purchase order shipment receipt was posted.
• The purchase order items have been fully received for the sales order linked to the purchase order commitment.
• The values in the Qty to Back Order field are not transferred to the Qty to Invoice field.
• The sales order that has the purchase order commitment was not transferred.



     

CAUSE

This problem may occur for one of the following reasons:

• When the purchase order was received, the Sales Transaction Entry window was open with the associated sales order selected.
• An interruption in processing occurred where the sales order did not update with the correct quantities in the Qty to Invoice field and the Qty Fulfilled field.



     

RESOLUTION

To resolve this problem, follow these steps:
1. Verify that the purchase order is updated with the correct quantities and amounts
a. Log on to Microsoft Dynamics GP 10.0 or Microsoft Dynamics GP 9.0 as the sa user.
b.

Follow the appropriate step:

• In Microsoft Dynamics GP 10.0, on the Microsoft Dynamics GP menu, point to Tools , point to Utilities , point to Purchasing , and then click Reconcile Purchasing Documents .
• In Microsoft Dynamics GP 9.0, on the Tools menu, point to Utilities , point to Purchasing , and then click Reconcile Purchasing Documents .



     
c. In the From field and in the To field, type the purchase order that is linked to the sales order.
d. Click Reconcile and Print Report .
e. Click Process .
2. Verify that the sales order is updated with the correct quantities and amounts
a. Follow the appropriate step: • In Microsoft Dynamics GP 10.0, on the Microsoft Dynamics GP menu, point to Tools , point to Utilities , point to Sales , and then click Reconcile - Remove Documents .
• In Microsoft Dynamics GP 9.0, on the Tools menu, point to Utilities , point to Sales , and then click Reconcile – Remove Documents .


     
b. In the From field and in the To field, type the sales that is linked to the purchase order.
c. Click Reconcile Sales Documents .
d. Click Process . If the problem continues to occur, contact Technical Support for more information about how to update tables. To contact Technical Support for Microsoft Dynamics and related products, you can log on to the Technical Support site for Microsoft Dynamics and related products and create a new support request. To do this, visit the following Microsoft Web site:

https://mbs.microsoft.com/support/newstart.aspx

You can also contact Technical Support for Microsoft Dynamics and related products by telephone by calling (888) 477-7877.

DISCLAIMER

MICROSOFT AND/OR ITS SUPPLIERS MAKE NO REPRESENTATIONS OR WARRANTIES ABOUT THE SUITABILITY, THE RELIABILITY OR THE ACCURACY OF THE INFORMATION THAT IS CONTAINED IN THE DOCUMENTS AND THE RELATED GRAPHICS PUBLISHED ON THIS WEB SITE (THE “MATERIALS”) FOR ANY PURPOSE.

THE MATERIALS MAY INCLUDE TECHNICAL INACCURACIES OR TYPOGRAPHICAL ERRORS AND MAY BE REVISED AT ANY TIME WITHOUT NOTICE. TO THE MAXIMUM EXTENT PERMITTED BY APPLICABLE LAW, MICROSOFT AND/OR ITS SUPPLIERS DISCLAIM AND EXCLUDE ALL REPRESENTATIONS, WARRANTIES, AND CONDITIONS WHETHER EXPRESS, IMPLIED OR STATUTORY, INCLUDING BUT NOT LIMITED TO REPRESENTATIONS, WARRANTIES, OR CONDITIONS OF TITLE, NON-INFRINGEMENT, SATISFACTORY CONDITION OR QUALITY, MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE, WITH RESPECT TO THE MATERIALS.

APPLIES TO


Microsoft Dynamics GP 10.0
Microsoft Dynamics GP 9.0
Purchase Order Commitments
Purchase Order Processing
Sales Order Processing