Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Dynamics 365 Community / Forums / Microsoft Dynamics GP (Archived) / Inventory batches with...
Microsoft Dynamics GP (Archived)

Inventory batches with status "Receiving"

(0) ShareShare
ReportReport
Posted on by Community Member Microsoft Employee

Hello Everybody,

I have several old Inventory batches that show status "Receiving". Most are empty. I would like to delete them but when I try I get the message "Error message 20151 doesn't exist".

Anyone know...

- What this message means?

- How inventory batches land in "Receiving" and how I can process or delete them.

I found one reference here that was quite technical about deleting records from tables, etc .. Hoping to understand why this occurred to avoid in the future.

A search for "20151" through the MS knowledge base did not return any results.

Many thanks,

Maria.

*This post is locked for comments

  • Suggested answer
    Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Inventory batches with status "Receiving"

    Try to re-enter the transaction with the same document number.  It will force system to put the batch into recovery.   Go to MS Dynamics > Tools > Routines > Batch Recovery and in the pop up window click Continue Button.

  • Suggested answer
    Mahmoud Saadi Profile Picture
    Mahmoud Saadi 32,738 on at
    RE: Inventory batches with status "Receiving"

    Hello Frandz,

    The back-end correction is one way, not the only way. Since this is one of the most common issues encountered with Dynamics GP clients, Microsoft has provided a "Fix it for me" utility (as a preferred option) especially when the client doesn't have a technical know-how. Check the support article Article ID: 850289

    Your feedback is highly appreciated,

  • Suggested answer
    soma Profile Picture
    soma 24,406 on at
    RE: Inventory batches with status "Receiving"

    Follow the below steps to correct & delete the batch with Receiving status.

    1. Make a backup of your company database and run the below query.

    UPDATE IV10000 SET PSTGSTUS = 0 WHERE  BACHNUMB = 'XXX'

    UPDATE SY00500 SET MKDTOPST = 0, BCHSTTUS = 0 WHERE  BACHNUMB = 'XXX'

    2. Now go to Inventory Batches window and delete the batches.

    Note: XXX -- Replace with your batch number with the status of Receiving.

    Hope this helps!!!

  • Suggested answer
    soma Profile Picture
    soma 24,406 on at
    RE: Inventory batches with status "Receiving"

    There are many reasons (Network problem, power failure, unexpected system shutdown. etc.,) may cause for this issue. To resolve this issue you need remove it from back-end (SQL). If you have knowledge about SQL then follow below steps to remove the unwanted inventory batches or contact your technical support team to correct the issue.

    Follow the below steps to delete the empty record batch.

    1. Please take a backup of  your company database.

    2. Open SSMS(SQL Server Management Studio) and run the below query against your company database.

    DELETE IV10001 where IVDOCNBR in (SELECT IVDOCNBR from IV10000 where BACHNUMB = 'XXX')

    DELETE IV10000 where BACHNUMB = 'XXX'

    3. Run the below query to note DEX_ROW_IDvalue for your batch.

    SELECT DEX_ROW_ID,* from SY00500 where BACHNUMB = 'XXX'

    4. Run the below query to delete batch from batch master table.

    DELETE SY00500 where BACHNUMB = 'XXX' and DEX_ROW_ID='Pass the first column value of the resultant from the step3'

    5. Open Inventory Batch window to check whether the batch available or not.

    6. Finally run the inventory reconcile.

    Note: XXX -- Replace with your batch number with empty records.

    Hope this helps!!!

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

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Tips for Writing Effective Suggested Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,253 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,188 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans