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 AX (Archived) / AX2009 to AX2012 Prepr...
Microsoft Dynamics AX (Archived)

AX2009 to AX2012 Preprocessing Error: Missing InventTrans

(0) ShareShare
ReportReport
Posted on by lispyj 181

I am receiving an error that some InventTransPosting records do not have corresponding InventTrans table records.  Thankfully only a few.  The message says that the error should be fixed before the data migration can take place.  What strategy would I use to fix this?  I have looked into one of the issues and it appears that a record should be added to the InventTrans table.  I am pretty concerned about even attempting such a thing, but what other choice would there be?

*This post is locked for comments

I have the same question (0)
  • Brandon Wiese Profile Picture
    Brandon Wiese 17,788 on at

    I guess the resolution to this depends upon the problem.  If you believe you need InventTrans records because they somehow got deleted, i.e. you have a packing slip and/or invoice for a stocked inventory item but somehow the InventTrans records are now gone, then repairing that may actually be useful.  If you decide to create InventTrans records, then you'll also have to update the InventSum records affected also.  

    On the other hand, if the InventTransPosting records seem extra and you want to delete them, that's a much easier problem to fix.  Obviously you don't want to delete InventTransPosting records that support packing slips or invoices.

    The real question here is do you have missing InventTrans records that should exist, or do you have extra InventTransPosting records that have no reason to exist?

  • Verified answer
    lispyj Profile Picture
    lispyj 181 on at

    I haven't researched each of the records yet, but the one I did appears to be a deleted inventTrans record.  There is a posting journal that supports a production picking list, but no invent trans.  I will check out inserting an inventTrans record.  I thought that running a consistency check to calculate the on hand would take care of the inventSum.  If that doesn't work, I will see what I need to do with the InventSum.  

    Thanks for the reply!

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 AX (Archived)

#1
Martin Dráb Profile Picture

Martin Dráb 4 Most Valuable Professional

#1
Priya_K Profile Picture

Priya_K 4

#3
MyDynamicsNAV Profile Picture

MyDynamicsNAV 2

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans