Field number mismatch in union query.

(0) Share

Report

Posted on by Shaik146

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

All responses (4)

Answers (1)

Verified answer

Shaik146 932 on at

Like (0)

Report

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.

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 8,072 on at

Like (0)

Report

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.
Shaik146 932 on at

Like (0)

Report

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 8,072 on at

Like (0)

Report

RE: Field number mismatch in union query.

Hi!

What actually you do to get this kind of error?