Skip to main content

Notifications

Announcements

No record found.

Microsoft Dynamics AX (Archived)

Field number mismatch in union query.

(0) ShareShare
ReportReport
Posted on by 932

Field number in 'ProjLedgerJournalTransUnpostedView' is not the same as the field number in 'ProjIntercompanyUnpostedVendInvLineView'. \Queries\ProjUnpostedTransUnion\Data Sources\ProjLedgerJournalTransUnpostedView(ProjLedgerJournalTransUnpostedView) ProjLedgerJournalTransUnpostedView Err:153

2502.err.jpg

how to rectify this?suggestions plsssss

*This post is locked for comments

  • Verified answer
    Shaik146 Profile Picture
    Shaik146 932 on at
    RE: Field number mismatch in union query.

    Hi,

    Actually whatever customizations i have done,deleted and restored that query and then compiled. then i got the error like below.

    UninonError1.jpg

    Then,

    I changed the size of EDT which workername uses(dirpartytable->Name(field) EDT: dirpartyname), changed the size from 100 to 140.) then it resolvd the error.

  • Suggested answer
    Rustem Galiamov Profile Picture
    Rustem Galiamov 8,072 on at
    RE: Field number mismatch in union query.

    Is there any customisations in the ProjUnpostedTransUnion query or ProjLedgerJournalTransUnpostedView and ProjIntercompanyUnpostedVendInvLineView views?

    Check the number of fields of ProjLedgerJournalTransUnpostedView and ProjIntercompanyUnpostedVendInvLineView in that query.

    Screen-Shot-2018_2D00_10_2D00_09-at-10.31.16.png

  • Shaik146 Profile Picture
    Shaik146 932 on at
    RE: Field number mismatch in union query.

    Hi,

    Actually i was given a 2012 project to fix the errors in it,when i compile it, the above error came in a query. i dont have much knowledge abt it. any suggestions pls.?

    this is restored db of client in our instances.

  • Rustem Galiamov Profile Picture
    Rustem Galiamov 8,072 on at
    RE: Field number mismatch in union query.

    Hi!

    What actually you do to get this kind of error?

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

Congratulations 2024 Spotlight Honorees!

Kudos to all of our 2024 community stars! 🎉

Meet the Top 10 leaders for December!

Congratulations to our December super stars! 🥳

Get Started Blogging in the Community

Hosted or syndicated blogging is available! ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

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

#2
Martin Dráb Profile Picture

Martin Dráb 230,371 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans