Dynamics Community Forum Thread Details

IV10200 and IV10201 and Historical Stock Status

Hi,

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.

Jutta

Categories:

Microsoft Dynamics GP

Quick Links

Leaderboard