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

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) / MR 2010 to 2012 Upgrad...
Microsoft Dynamics GP (Archived)

MR 2010 to 2012 Upgrade error

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

  • Community Member Profile Picture
    Community Member on at

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

  • Brian_DiFi Profile Picture
    Brian_DiFi 2,410 on at

    I don't believe we have.  

  • Lisa Payment Profile Picture
    Lisa Payment 65 on at

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

  • Suggested answer
    Lisa Payment Profile Picture
    Lisa Payment 65 on at

    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.

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

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 August Top 10 Community Leaders

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics GP (Archived)

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans