Microsoft KB Archive Search

Notice: This website is an unofficial Microsoft Knowledge Base (hereinafter KB) archive and is intended to provide a reliable access to deleted content from Microsoft KB. All KB articles are owned by Microsoft Corporation. Read full disclaimer for more details.

  1. Home
  2. Issue where purchase order was received but should not have been in Microsoft Dynamics GP

Issue where purchase order was received but should not have been in Microsoft Dynamics GP

View products that this article applies to.

Symptom
 


You entered a receipt for a purchase order but it should not have been received. You need to be able to return the quantities but you do not want to use Purchase Order Returns in Microsoft Dynamics GP.


RESOLUTION

Return a shipment ("Return" transaction type in Purchase Order Returns) 

To return a shipment manually, you must enter a negative adjustment in inventory. However, a negative adjustment always pulls the unit cost based on the valuation method of the item. Therefore, you may have to perform the Adjust Costs procedure before you can enter the negative adjustment. The following steps assume that you will be returning the whole receipt line.
1. Create a batch and validate the current unit cost for the negative adjustment. To do this, follow these steps:
a. On the Transactions menu, point to Inventory , and then click Batches .
b. In the Batch ID box, type the Batch ID that you want to use.
c. From the Origin list, click Transaction Entry .
d. Click to select the Post to General Ledger check box, and then click Transactions .
e. In the Item Number box, type the item number that you must return.
f. In the Quantity box, type the number of parts that you must return as a negative number.
Note The Unit Cost box will display a default value that is based on your valuation method. If the unit cost is the same value as the unit cost of the purchase receipt, go to step 3d.
g. Click Delete . When you are prompted to delete the transaction, click Delete again.
h. Close the Item Transaction Entry window.
2. Adjust the cost of the current inventory layer to reflect the unit cost of the purchase receipt that you must return. To make this adjustment, follow these steps:
a. In Microsoft Dynamics GP 10.0 and later versions, point to  Tools on the Microsoft Dynamics GP menu, point to Utilities , point to Inventory , and then click Adjust Costs .

In Microsoft Dynamics GP 9.0 and in earlier versions, point to Utilities on the Tools menu, point to Inventory , and then click Adjust Costs .
b. In the Item Number box, type the item number that you must return.
c. In the Site ID box, type the site that you will be returning the item from.
d. Locate the next available layer based on your valuation method.
e. Note the current values of the Unit Cost box and of the Quantity Sold box.
f. Change the Unit Cost box for that layer to the unit cost that was used on the original purchase receipt.
g. Click Process .
3. Enter the negative adjustment. To do this, follow these steps:
a. On the Transactions menu, point to Inventory , and then click Transaction Entry .
b. In the Batch ID box, type the Batch ID that you created in step 2.
c. In the Item Number box, type the item number that you must return.
d. In the Quantity box, type the number of parts that you must return as a negative number.
e. Click Distributions . Change the Inventory Offset box to apply to your accrued purchases account, and then click OK .
f. Click Save , and then close the Item Transaction Entry dialog box.
g. On the Transactions menu, point to Inventory , and then click Series Post .
h. Click to select the check box for the batch that you created in step 1, and then click Post .
i. If you adjusted costs in step 2, go to step 4. Otherwise, the return of the inventory is completed.
4. Adjust costs again to guarantee that your inventory account matches your purchase receipts reports. To do this, follow these steps:
a. In Microsoft Dynamics GP 10.0 and later versions, point to  Tools on the Microsoft Dynamics GP menu, point to Utilities , point to Inventory , and then click Adjust Costs .

In Microsoft Dynamics GP 9.0 and in earlier versions, point to Utilities on the Tools menu, point to Inventory , and then click Adjust Costs .
b. In the Item Number box, type the item number that you returned.
c. In the Site ID box, type the site that you returned the item from.
d. Locate the layer on which you adjusted costs in step 2. If the value in the Quantity Sold box is not zero, return the value in the Unit Cost box to its original amount from before you adjusted costs in step 2.
e. Change the value inthe Unit Cost box for the receipt that you returned. Return the value to match the original value of the Unit Cost box of the layer that you adjusted in step 2.
Return a shipment/invoice ("Return w/Credit" transaction type in Purchase Order Returns)


The shipment part of the receipt can be backed out as outlined in the "Returning a shipment (Return)" section. To back out the invoice, you must issue a return in Payables Management.
 
1. On the Transactions menu, point to Purchasing , and then click Transaction Entry .
2. From the Document Type list, click Return .
3. In the Vendor ID box, type the vendor ID to which you are returning the items.
4. In the Document Number box, type the return number that you received from the vendor.
5. In the Returns box, type the credit that you are receiving from your vendor for the returned inventory.
6. Click Distributions .
7. Change the PURCH type account to your inventory account, and then click OK .
8. Click Apply .
9. Click to select the check box for the original invoice of the item, and then click OK .
10. Click Post .
Close the purchase order.

After you have returned the items, you can close the purchase order and move the purchase order to history. To do this, follow these steps:
1. On the Transactions menu, point to Purchasing , and then click Edit Purchase Orders .
2. In the PO Number box, type the purchase order number that you want to close.
3. On the Purchase Order Status drop-down list, click Closed , and then click Process .
4. In Microsoft Dynamics GP 10.0 and later versions, point to  Tools on the Microsoft Dynamics GP menu, point to Routines , point to Purchasing , and then click Remove Completed Purchase Orders .

In Microsoft Dynamics GP 9.0 and in earlier versions, point to Utilities on the Tools menu, point to Routines , point to Purchasing , and then click Remove Completed Purchase Orders .
5. In the From and To boxes, type the purchase order number that you want to move to history, and then click Insert .

↑ Back to the top

APPLIES TO
• Microsoft Dynamics GP 2010
• Microsoft Dynamics GP 10.0
• Microsoft Dynamics GP 9.0
• Microsoft Business Solutions–Great Plains 8.0
• Microsoft Business Solutions–Great Plains 7.5, when used with:
  Purchase Order Processing

↑ Back to the top

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. 

-------------------------------------------------------------------

↑ Back to the top

Keywords: kb, kbnosurvey, kbhowto, kbMBSPartner, kbMBSMigrate, BemisKB871923, kbMBSgp10, kbFreshness2007

↑ Back to the top

Article Info
Article ID : 871923
Revision : 5
Created on : 4/4/2017
Published on : 4/4/2017
Exists online : False
Views : 183