web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics GP (Archived) / Generar tablas de hist...
Microsoft Dynamics GP (Archived)

Generar tablas de historico de inventario IV10200 y IV10201

(0) ShareShare
ReportReport
Posted on by Soporte Santillana 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

I have the same question (0)
  • JulianH Profile Picture
    JulianH on at

    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

  • Mahmoud Saadi Profile Picture
    Mahmoud Saadi 32,738 on at

    Is it possible to provide the question in English ?

    Your feedback is highly appreciated,

  • JulianH Profile Picture
    JulianH on at

    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.

  • Suggested answer
    Mahmoud Saadi Profile Picture
    Mahmoud Saadi 32,738 on at

    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

    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.

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

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Congratulations to the November Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics GP (Archived)

#1
mtabor Profile Picture

mtabor 1

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans