Skip to main content

Notifications

Announcements

No record found.

Community site session details

Community site session details

Session Id :
Microsoft Dynamics GP (Archived)

Unable to post the MO receipt.

(0) ShareShare
ReportReport
Posted on by 606

"you cannot post the receipt, following items are not completely issues/allocated/backflushed
as per pick list."

above is the error im getting while trying to post the MO receipt in MO receipt entry window. Could anyone help with this. Any ideas? . Its urgent..

Thanks,

Arunsh.

*This post is locked for comments

  • Suggested answer
    RE: Unable to post the MO receipt.

    Please try the following.

    1) Run checklink against - Manufacturing - Inventory and see whether you are able to receive the MO.  (Please take a backup before doing this)

  • Arunsh Profile Picture
    Arunsh 606 on at
    RE: Unable to post the MO receipt.

    The query you gave doesn't return any values. It is just empty.

    Since I'm new to manufacturing its being a struggle to understand the problem.

  • Suggested answer
    RE: Unable to post the MO receipt.

    Hi Shanthi,

    Okay please try the following query.  

    1. Run the following script against the company database:

    Select PICKNUMBER from MOP1210 where MANUFACTUREORDER_I = 'XXXX'

    and MANUFACTUREORDER_I in (select MANUFACTUREORDER_I from MOP1400

    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)

    Note In this script, you must replace the XXXX placeholder with the manufacturing order number.

    Results that the script in step 2 returns indicate that an un-posted picking document exists. To post the picking document or remove the items from the picking document, follow these steps:

    a. On the Transactions menu, point to Manufacturing, point to Manufacturing Orders, and then click Component Trx Entry.

    b. In the Manufacture Pick Number list, click the pick document number from step 2.

    c. Follow one of these steps:

     If you want to post the items, click Mark All, and then click Post.

     If you do not want to post the items, click to select the check box next to each item number, click Edit, and then click Delete Row.

    Note If all items are removed from the pick document, you do not have to post the pick document.

    Try this first and let me know.

  • Arunsh Profile Picture
    Arunsh 606 on at
    RE: Unable to post the MO receipt.

    Its not working, when executing im getting

    PENDING_SCRAP_QTY_I  = 0

    PENDING_REV_ISS_QTY_I  = 0

    PENDING_ISSUE_QTY_I  = 0

    so there is no use in updating these columns with zero right?

  • Arunsh Profile Picture
    Arunsh 606 on at
    RE: Unable to post the MO receipt.

    Thanks a lot babu, let me try this solution., Thanks again.

  • Suggested answer
    RE: Unable to post the MO receipt.

    Hi Shanthi,

    There is some component is allocated but not issued and stuck, so in order to release the same please run the following script on SQL.  Please take a backup before doing the following.

    Run the following scripts against the company database:

    select PENDING_ISSUE_QTY_I, MANUFACTUREORDER_I from MOP1400 where PENDING_ISSUE_QTY_I > 0 and MANUFACTUREORDER_I = 'MOxxx'

    select PENDING_REV_ISS_QTY_I, MANUFACTUREORDER_I from MOP1400 where PENDING_REV_ISS_QTY_I > 0 and MANUFACTUREORDER_I = 'MOxxx'

    select PENDING_SCRAP_QTY_I, MANUFACTUREORDER_I from MOP1400 where PENDING_SCRAP_QTY_I > 0 and MANUFACTUREORDER_I = 'MOxxx'

    select PENDING_REV_SCRAP_QTY_I, MANUFACTUREORDER_I from MOP1400 where PENDING_REV_SCRAP_QTY_I > 0 and MANUFACTUREORDER_I = 'MOxxx'

    Note In this script, you must replace the MOxxx placeholder with the manufacturing order number.

    Results that are returned from the script in step 2 indicate that the MOP1400 table must be updated. Run the following scripts against the company database:

    update MOP1400 set PENDING_ISSUE_QTY_I = 0 where PENDING_ISSUE_QTY_I > 0 and MANUFACTUREORDER_I = 'xxxx'

    update MOP1400 set PENDING_REV_ISS_QTY_I = 0 where PENDING_REV_ISS_QTY_I > 0 and MANUFACTUREORDER_I = 'xxxx'

    update MOP1400 set PENDING_SCRAP_QTY_I = 0 where PENDING_SCRAP_QTY_I > 0 and MANUFACTUREORDER_I = 'xxxx'

    update MOP1400 set PENDING_REV_SCRAP_QTY_I = 0 where PENDING_REV_SCRAP_QTY_I > 0 and MANUFACTUREORD_I = 'xxxx'

    Once you do the above you will be able to receive the MO.

  • Suggested answer
    Almas Mahfooz Profile Picture
    Almas Mahfooz 11,006 User Group Leader on at
    RE: Unable to post the MO receipt.

    Message is saying items ate not completely issues/allocated/backflushed. Did you check your items?

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

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Vahid Ghafarpour – Community Spotlight

We are excited to recognize Vahid Ghafarpour as our February 2025 Community…

Tip: Become a User Group leader!

Join the ranks of valued community UG leaders

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 292,468 Super User 2025 Season 1

#2
Martin Dráb Profile Picture

Martin Dráb 231,289 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans