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

Announcements

Introducing our New Video Series: Community Spotlight
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 201

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,790 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 201 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

News and Announcements

Introducing our New Video Series: Community Spotlight

Quick Links

Season of Sharing Community Challenge Winners!

Congratulations to our community stars!

Women in Power Builds Momentum

Expanding mentorship, skilling, and AI innovation

Congratulations to the June Top 10 Community Leaders

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics AX (Archived)

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans