Skip to main content



No record found.

Microsoft Dynamics GP forum

IV10200 and IV10201 and Historical Stock Status

Posted on by 92
It appears that previous questions regarding IV10200 and IV10201 have not been addressed. Additionally, I am encountering an issue with missing records in IV10201.

To summarize:

  • IV10200 holds items received, identified by RCTSEQNM, ITEMNMBR,QTYRECVD,TRXLOCTN
  • a RCTSEQNM is kept by item in IV10202.
  • For each quantity increase adjustment, RCTSEQNM is incremented in IV10202, and a receipt is recorded in IV10200.  
  • When an item is removed, an entry is created in IV10201 with SRCRCTSEQNM pointing to the RCTSEQNM in IV10200.
  • Item reconciliation creates entries in both IV10200 (RCPTNMBR = 'Reconcile') and IV10201 (ORIGINDOCID = 'RECON').

However, as previously noted, there are missing entries in IV10201. This results in IV10200 having a QTYSold > 0 without corresponding entries in IV10201 detailing the decrease adjustment.

Running an inventory reconcile did not resolve this issue. How can this be corrected?

Additionally, how is this affecting the Historical Stock Status report?

Thank you.




Helpful resources

Quick Links

Replay now available! Dynamics 365 Community Call (CRM Edition)

Catch up on the first D365 Community Call held on 7/10

Community Spotlight of the Month

Kudos to Saurav Dhyani!

Congratulations to the June Top 10 community leaders!

These stars go above and beyond . . .


André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 287,914 Super User

Martin Dráb Profile Picture

Martin Dráb 225,549 Super User

nmaenpaa Profile Picture

nmaenpaa 101,148


Featured topics

Product updates

Dynamics 365 release plans