News and Announcements icon

Dynamics 365 CommunityForums Microsoft Dynamics GP (Archived) Lost Inventory Batch H...

Microsoft Dynamics GP (Archived)

Lost Inventory Batch Header

(0) Share

Report

Report

Posted on by Accounting Department

1,540

A stock count posting batch was stuck with a Marked to Post status. In Master Posting user was able to uncheck this, and view the batch in Inventory Trx.

We verified that the quantities were in fact posted, and the GL side was also posted. I can pull the details from Smartlist.

I cannot however reproduce the posting journal. The info does not exist in IV30100 at all.

I ran a checklinks on Inventory Trx Work but that did not fix this issue. Do I need to checklinks on another series or reconcile something?

*This post is locked for comments

All responses Img

All responses (1)

Answers Img

Answers (0)

Suggested answer

Mahmoud Saadi 32,738 on at

Like (0)

Report

RE: Lost Inventory Batch Header

I have encountered several cases in inventory posting previously. One of the cases is corrupted records in IV30100 and IV30200. Check links would not fill in the missing records.Therefore, you may consider filling these tables on the database level.

Corrupted records in IV30100 and IV30200 affect inquiry drill down capabilities through the transaction source document. Details in IV30100 and IV30200 can be found in IV30300.

SELECT * FROM dbo.IV30100
SELECT * FROM dbo.IV30200
SELECT * FROM dbo.IV30300

Please never hesitate to share any further inquiries.

Helpful resources

Quick Links

Leaderboard

#1

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

#2

Martin Dráb 230,235 Most Valuable Professional

#3

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans