What is this error - Copying all filters at once..?

ImaspalImaspal Member Posts: 68
Hi Experts!

Can you tell me, what I have to do, when I get a following error in NAV:
Copying all filters at once can only be done between records belonging to the same table.
Table: Sales Invoice Header <-- Sales Invoice Header
Copy the necessary filters one at a time.

Comments

  • kinekine Member Posts: 12,562
    1) It can be problem of wrong table Caption (caption was not changed after some table was copied)
    2) I saw this error sometime when the code was correct. I had no time to track the circumstances when it was called, but it was mainly because some errors etc. in previous transactions...
    Kamil Sacek
    MVP - Dynamics NAV
    My BLOG
    NAVERTICA a.s.
  • ImaspalImaspal Member Posts: 68
    Thanks. I guess in this case the code is correct and there are some errors etc. in previous transactions.

    By the way, I have an other error too. Can you explain what is this error and why it appears:
    Field no. 0 is not defined in the Sales Invoice Header table.


    Yours,
    IP
  • kinekine Member Posts: 12,562
    It looks like some broken link in the compiled object form or conflict between variable names (like same variable name as name of some field of Rec etc.)
    Kamil Sacek
    MVP - Dynamics NAV
    My BLOG
    NAVERTICA a.s.
  • davmac1davmac1 Member Posts: 1,283
    I ran into the same problem in 2013 R2 in the Purchase Invoices List (Page 9308).
    I set a filter for the purchasing code before running Post Batch, and then received this error.
    After reading this post, I decided to add a commit after setting the filter and before calling the batch posting report.
    This fixed the problem for me.

    Commits required before runmodal are not unusual, but usually the error message is more informative.
  • KishormKishorm Member Posts: 921
    Imaspal wrote:
    By the way, I have an other error too. Can you explain what is this error and why it appears:

    Field no. 0 is not defined in the Sales Invoice Header table.

    This could be because you have a lookup flowfield onto the Sales Invoice Header table but you have not defined the lookup field.
Sign In or Register to comment.