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. The Bin field and the "Quantity Selected" field are unavailable in the "Bin Quantity Entry" window when you enter a "Reverse Issue" transaction in Manufacturing in Microsoft Dynamics GP or Microsoft Great Plains

The Bin field and the "Quantity Selected" field are unavailable in the "Bin Quantity Entry" window when you enter a "Reverse Issue" transaction in Manufacturing in Microsoft Dynamics GP or Microsoft Great Plains

Symptoms

When you enter a Reverse Issue transaction in Manufacturing in Microsoft Dynamics GP 9.0 or in Microsoft Business Solutions - Great Plains, the Bin field and the Quantity Selected field are unavailable in the Bin Quantity Entry window.

This issue occurs when the following conditions are true:
  • The Enable Multiple Bins check box is selected in the Inventory Control Setup window. To view this check box, point to Setup on the Tools menu, point to Inventory, and then click Inventory Control.
  • There are no unposted Reverse Issue pick documents for the component or for the manufacturing order in the Component Transaction Entry window.

↑ Back to the top

Cause

This issue occurs if the MOP_Bin_Issue table (MOP1027) contains an invalid-quantity unposted entry.

↑ Back to the top

Resolution

To resolve this issue, follow these steps:
  1. Make sure that there are no unposted Reverse Issue pick documents for the component or for the manufacturing order. To do this, follow these steps:
    1. On the Transactions menu, point to Manufacturing, point to Manufacturing Orders, and then click Component Trx Entry.
    2. Click the lookup button next to Manufacturing Pick Number to open the Manufacturing Pick Number Lookup window.
    3. In the Restrict to list, click Saved.
    4. Review the returned pick numbers to make sure that there are no unposted Reverse Issue pick documents for the component or for the manufacturing order.
  2. Back up the company database.
  3. Start SQL Query Analyzer. To do this, click Start, point to All Programs, point to Microsoft SQL Server, and then click Query Analyzer.
  4. In the database list, click your company database.
  5. Copy the following SQL statement to the Query window.
    SELECT * FROM MOP1027 WHERE ITEMNMBR = 'xxxx' AND MANUFACTUREORDER_I  = 'moxxxx'
    In this statement, replace the xxxx placeholder with the component item number. Replace the moxxxx placeholder with the manufacturing order number.
  6. On the Query menu, click Execute.
  7. Review the returned results. If a quantity other than 0 (zero) is displayed in the QTYPENDING column, note the corresponding value that is displayed in the DEX_ROW_ID column.
  8. Copy the following SQL statement to the Query window.
    UPDATE MOP1027 SET QTYPENDING = '0' WHERE DEX_R0W_ID = 'XX'
    In this statement, replace the XX placeholder with the value in the DEX_ROW_ID column that you noted in step 7.
  9. On the Query menu, click Execute.
  10. Exit SQL Query Analyzer.
Note The Bin field and the Quantity Selected field in the Bin Quantity Entry window should now be available.

↑ Back to the top

Keywords: kbnosurvey, kbentirenet, kbtshoot, kbmbspartner, kbmbsmigrate, kbprb, kb

↑ Back to the top

Article Info
Article ID : 918952
Revision : 1
Created on : 3/3/2017
Published on : 11/2/2013
Exists online : False
Views : 83