Skip to main content

Notifications

Microsoft Dynamics GP (Archived)

Generar tablas de historico de inventario IV10200 y IV10201

Posted on by 100

Buenas tardes compañeros tengo un problema con los historicos de inventario, en algun momento existieron errores con transferencias entre inventarios y se duplicaron, al eliminarlas nos falto removerlas de la las tablas IV10200 y IV10201 que manejan el historico de inventario las misma presentaron errores cuando se corrio la conciliacion nos colocaron masl las cantidades de los articulos y no esta calculando bien las existencias, alli me pregunta no existe una forma de generar nuevamente estos registros para recontruir el stock de inventarios?

Me seria de gran ayuda cualquier informacion!!!!!!!!!!!!!!!

*This post is locked for comments

  • JulianH Profile Picture
    JulianH on at
    RE: Generar tablas de historico de inventario IV10200 y IV10201

    Puedes verificar las tablas de control (IV10200 y IV10201),  a través de un enfoque 'conciliatorio', revisando dos o incluso tres tablas de la siguiente manera:

    IV30300

    IV10200

    IV10201

    Puedes utilizar RCPTNMBR, RCTSEQNUM (IV10200), SRCRCTSEQNUM, ORIGINDOCID (IV10201), DOCNMBR (IV30300) para comparar la información entre ellas.

    Por lo que sé, excepto por el uso del HITB no existe otro método para reconstruir las tablas de control.

    Espero te sirva la información sobre este tema.

  • Suggested answer
    Mahmoud Saadi Profile Picture
    Mahmoud Saadi 32,738 on at
    RE: Generar tablas de historico de inventario IV10200 y IV10201

    Inventory cost layers tables (IV10200, IV10201) are key tables not only for the inventory module, but also for all other distribution modules. There is no way to rebuild these tables.

    Actually, the HITB reset tool that you have mentioned retrieves the data related to inventory cost layers IV10200, IV10201 and build the historical inventory trial balance table (SEE30303), mainly for GL-IV reconciliation purposes. The IV10200, IV10201 are not modified by this process.

    There is another workaround solution to create new cost layers (not rebuild them), through bringing inventory balance down to zero, and then re-enter these transactions. It will zero out the old cost layers and create new ones. Although, I am kinda curious about the type of problem we have here, rebuilding cost layers seems to me as a suggestion solution, but what's the main issue that we encounter here is important.

    Your feedback is highly appreciated,  

  • JulianH Profile Picture
    JulianH on at
    RE: Generar tablas de historico de inventario IV10200 y IV10201

    Good morning,

    Mr. Saadi, the question is how to rebuild inventory control tables (IV10200 & IV10201), I suggest that he can use a 'Reconcile' kind of approach, reviewing two or even three tables as follows:

    IV30300

    IV10200

    IV10201

    Can use RCPTNMBR, RCTSEQNUM (IV10200), SRCRCTSEQNUM, ORIGINDOCID (IV10201), DOCNMBR (IV30300) to compare information between tables.

    As far as I know, I've no found information related, except for using HITB to rebuilt control tables.

    I hope you can give us more information about this topic.

    Thanks,

    Julián H.

  • Mahmoud Saadi Profile Picture
    Mahmoud Saadi 32,738 on at
    RE: Generar tablas de historico de inventario IV10200 y IV10201

    Is it possible to provide the question in English ?

    Your feedback is highly appreciated,

  • JulianH Profile Picture
    JulianH on at
    RE: Generar tablas de historico de inventario IV10200 y IV10201

    La condición del funcionamiento de inventarios radica en tres tablas principales

    IV10200 Entradas

    IV10201 Salidas

    IV30300 Transaccionalidad

    Debes verificar el estado de las transacciones de transferencia a nivel de financiero e inventario, si tienes disponibles los productos Kárdex y HITB también es posible rastrear las transacciones.

    Luego debes comprobar las transacciones y  definir como procesarlas

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!

Community AMA December 12th

Join us as we continue to demystify the Dynamics 365 Contact Center

Leaderboard

#1
André Arnaud de Calavon Profile Picture

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

#2
Martin Dráb Profile Picture

Martin Dráb 230,149 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans