Skip to main content

Notifications

Announcements

No record found.

Microsoft Dynamics GP (Archived)

MR 2010 to 2012 Upgrade error

(0) ShareShare
ReportReport
Posted on by 2,410

After updating a 2010 install to 2012 we noticed two companies won't integrate.  The integration log is giving this error over and over: 

[GL Transaction to Fact] has encountered an error. Processing will be aborted. Error text: The multi-part identifier "seg1.ACCATNUM" could not be bound.

Operand data type void type is invalid for max operator.

The data types void type and nchar are incompatible in the CTCrVersionAgg operator.

Operand data type void type is invalid for max operator.

The data types void type and nchar are incompatible in the CTCrVersionAgg operator.

The multi-part identifier "seg0.ACTDESCR" could not be bound.

The multi-part identifier "seg1.ACCATNUM" could not be bound.

The multi-part identifier "seg1.ACCATNUM" could not be bound.

Operand data type void type is invalid for max operator.

The data types void type and nchar are incompatible in the CTCrVersionAgg operator.

Operand data type void type is invalid for max operator.

The data types void type and nchar are incompatible in the CTCrVersionAgg operator.

The multi-part identifier "seg0.ACTDESCR" could not be bound.

The multi-part identifier "seg1.ACCATNUM" could not be bound.

The multi-part identifier "seg1.ACCATNUM" could not be bound.

Operand data type void type is invalid for max operator.

The data types void type and nchar are incompatible in the CTCrVersionAgg operator.

The multi-part identifier "seg0.ACTDESCR" could not be bound.

The multi-part identifier "seg1.ACCATNUM" could not be bound.

 

Has anyone seen this yet, or a way to get through it?  

*This post is locked for comments

  • Suggested answer
    Lisa Payment Profile Picture
    Lisa Payment 65 on at
    RE: MR 2010 to 2012 Upgrade error

    In our instance it occurred because a company had been defined and never set up so there weren't any GL accounts in it.  Once the company without any gl accounts was deleted it worked fine.

  • Lisa Payment Profile Picture
    Lisa Payment 65 on at
    RE: MR 2010 to 2012 Upgrade error

    I have just encountered it with a new install of MR 2012 CU7...has anyone resolved it?  Thank you.

  • Brian_DiFi Profile Picture
    Brian_DiFi 2,410 on at
    RE: MR 2010 to 2012 Upgrade error

    I don't believe we have.  

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: MR 2010 to 2012 Upgrade error

    I received the same error. did you get this resolved?

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!

Tips for Writing Effective Verified Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

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

#2
Martin Dráb Profile Picture

Martin Dráb 230,445 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans