Field number mismatch in union query.

(0) Share

Report

Posted on by TestBot

950

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

I have the same question (0)

All responses (4)

Answers (1)

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?

Was this reply helpful? Yes No
TestBot 950 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.

Was this reply helpful? Yes No
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.

Was this reply helpful? Yes No
Verified answer

TestBot 950 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.

Was this reply helpful? Yes No