In Microsoft Dynamics GP and in Microsoft Business Solutions - Great Plains, the Received/Not Invoiced report shows shipment receipts even though some of the items on the report have been returned. This behavior affects only shipments that were entered without a purchase order number.
Symptoms
To work around this issue, follow these steps:
-
Make sure that you have a restorable backup of the company database, and then test the backup in a TEST database.
-
In Microsoft SQL Query Analyzer, run the following statement against the company database to remove the shipment receipt document number from the Received/Not Invoiced report.
update POP10500 set QTYMATCH = QTYSHPPD where POPRCTNM = '<DocNumber>'
Note <DocNumber> is the shipment receipt document number that you want to remove from the Received/Not Invoiced report.
Workaround
Steps to reproduce the problem
-
Click Transactions, click Purchasing, and then click Receiving Transaction Entry.
-
Enter a shipment receipt without a purchase order number for Item 100XLG, and then enter 10 in the Quantity Shipped field. Use a unit cost of $1.00. Write down the shipment receipt document number that is listed in the Receipt No. field and the date, and then click Post.
-
Click Transactions, click Purchasing, and then click Enter/Match Invoices.
-
Enter an invoice receipt without a purchase order number for Item 100XLG, and then enter 7 in the Quantity Invoiced field. Use a unit cost of $1.00. Note that the shipment receipt document number is what you wrote down in step 2. Write down the invoice receipt number, and then click Post.
-
Click Transactions, click Purchasing, and then click Returns Transaction Entry.
-
Enter a return receipt by using the Return type without a purchase order for Item 100XLG, and then enter 3 in the Quantity Returned field. Use a unit cost of $1.00. Click the shipment receipt document number that you wrote down in step 2 for Receipt No., and then click Post.
-
Click Reports, click Purchasing, and then click Analysis.
-
Click the Received/Not Invoiced report, and then click New.
-
Enter a name for the report option. In the Ranges list, click Receipt Date, enter the date from step 2, and then click Insert.
-
Click Destination, click to select a print destination for the report, and then click OK.
-
In the Purchasing Analysis Report Options window, click Print.
After you follow these steps, the shipment receipt document number that you wrote down in step 2 may appear on a report that has a Qty Shipped value of 10, a Qty Invoiced value of 7, and a Qty Returned value of 3. You do not expect the shipment receipt document number that you wrote down in step 2 to appear on the report.