web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

No record found.

Community site session details

Community site session details

Session Id :
Microsoft Dynamics GP (Archived)

Error message when you try to close a manufacturing order in Microsoft Dynamics GP: "This Manufacturing Order has a Pending Component Transaction"

(0) ShareShare
ReportReport
Posted on by

Hello,

I go the following error message when I tried to close a  MO.

"This Manufacturing Order has a Pending Component Transaction, See Picking Document PCKXXXXXXXXX for more information"

 However, I've found a solution to this on https://support.microsoft.com/en-gb/kb/953438

The query in Resolution 1 results me a different Picking Doc number to what's shown in error message.

Does anyone know what this means, as to why two picking documents exist and as to why the PCK number shown in the error message different from the result from the query. 

Many Thanks

*This post is locked for comments

I have the same question (0)
  • Community Member Profile Picture
    on at

    In my experience, the picking document referenced in that error message is simply the first pick doc that was issued for the MO.  It's a red herring.  Once you find the real pick doc and fix it, you won't see the error.  Just one of those things.

  • Community Member Profile Picture
    on at
    I don't know where I found these scripts, but they might help shed some light on trx pending against your MO. 



    select * from MOP1025 (nolock)
    where MANUFACTUREORDER_I like '%448'
    
    
    
     select PENDING_ISSUE_QTY_I
    	,PENDING_REV_ISS_QTY_I
    	,PENDING_SCRAP_QTY_I
    	,PENDING_REV_SCRAP_QTY_I
    	,* 
     from MOP1400 (nolock) 
     where MANUFACTUREORDER_I = 'MORD000448' 
    	and  (PENDING_REV_ISS_QTY_I <> 0 
    			or PENDING_ISSUE_QTY_I <> 0 
    			or PENDING_SCRAP_QTY_I <> 0 
    			or PENDING_REV_SCRAP_QTY_I <> 0
    		)
      order by ITEMNMBR
    
    
    
    select PICKNUMBER 
    from MOP1210 (nolock) 
    where MANUFACTUREORDER_I = 'MORD000448'
    	and MANUFACTUREORDER_I in (
    			select MANUFACTUREORDER_I 
    			from MOP1400 (nolock) where MANUFACTUREORDER_I in 
    					(select MANUFACTUREORDER_I 
    					where PENDING_REV_ISS_QTY_I <> 0 
    						or PENDING_ISSUE_QTY_I <> 0 
    						or PENDING_SCRAP_QTY_I <> 0 
    						or PENDING_REV_SCRAP_QTY_I <> 0)
    						) 
    			and TRX_TYPE in (1,2,5,6) 
    			and PICKNUMBER in (
    				select PICKNUMBER from MOP1200 where POSTED = 0) 

  • Community Member Profile Picture
    on at

    This was the problem I encountered too - thanks for sharing the solution

  • Community Member Profile Picture
    on at

    Went looking for the open Picklist (s) and they were top of the heap when I ran a simple query against MOP1025

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Leaderboard > 🔒一 Microsoft Dynamics GP (Archived)

#1
mtabor Profile Picture

mtabor 1

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans