Skip to main content

Notifications

Microsoft Dynamics AX forum
Answered

Field number mismatch in union query.

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

  • 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?

Helpful resources

Quick Links

Dynamics 365 Community Update

Welcome to the inaugural Community Platform Update. As part of our commitment to…

Dynamics 365 Community Newsletter - August 2024

Catch up on the latest D365 Community news

Community Spotlight of the Month

Kudos to Mohana Yadav!

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 290,115 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 227,971 Super User 2024 Season 2

#3
nmaenpaa Profile Picture

nmaenpaa 101,148

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans