Inventory batches with status "Receiving"

(0) Share

Report

Posted on by Community Member

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

I have the same question (0)

All responses (4)

Answers (0)

Suggested answer

soma 24,410 on at

Like (0)

Report

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!!!

Was this reply helpful? Yes No
Suggested answer

soma 24,410 on at

Like (0)

Report

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!!!

Was this reply helpful? Yes No
Suggested answer

Mahmoud Saadi 32,738 on at

Like (0)

Report

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,

Was this reply helpful? Yes No
Suggested answer

Community Member on at

Like (0)

Report

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.

Was this reply helpful? Yes No