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
Went looking for the open Picklist (s) and they were top of the heap when I ran a simple query against MOP1025
This was the problem I encountered too - thanks for sharing the solution
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)
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.
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
André Arnaud de Cal... 291,240 Super User 2024 Season 2
Martin Dráb 230,149 Most Valuable Professional
nmaenpaa 101,156