Reset subform filter after clicking on next record button on Parrent page on Sales Order

george175
george175 Member Posts: 26
in NAV Three Tier
Hello all,

Is there some solution to reset used defined filter from button function on subpage, when I will click on next record button on parent page? If I click on next record button, subpage cant filter on next record lines and lines are empty. I have to click on clear filter first.

I know that there is ctrl+shift+a hotkey on subpage, but have to do this automatically.

Any ideas or suggestions?

Answers

  • archer89
    archer89 Member Posts: 337
    why do you filter the subform?
    please describe the whole process, where that is used.
    best regards
    Franz Kalchmair, MVP
    Alias: Jonathan Archer

    please like / agree / verify my answer, if it was helpful for you. thx.
    Blog: http://moxie4nav.wordpress.com/
  • TallyHo
    TallyHo Member Posts: 417
    I don't know what you mean by "from button function on subpage" either.

    But you could add this global function to the subform:
    ResetManualFilters()
    RESET;

    And in the main form:
    Form - OnAfterGetRecord()
    CurrForm.SubFormName.FORM.ResetManualFilters;

    This will reset all the filters the users set on the records in the sub page when they click next.
    But maybe it is better to explain the FILTER indication in the bottom of the document.
  • george175
    george175 Member Posts: 26
    TallyHo wrote: »
    I don't know what you mean by "from button function on subpage" either.

    But you could add this global function to the subform:
    ResetManualFilters()
    RESET;

    And in the main form:
    Form - OnAfterGetRecord()
    CurrForm.SubFormName.FORM.ResetManualFilters;

    This will reset all the filters the users set on the records in the sub page when they click next.
    But maybe it is better to explain the FILTER indication in the bottom of the document.

    This unfortunately does not work :/
    this is my subpage pageAction filter

    RESET;
    SETRANGE("Document Type",SalesHeader."Document Type");
    SETRANGE("Document No.",SalesHeader."No.");
    SETRANGE("Outstanding Quantity")

    If I click on next more times or just one time, I have filter on first record still.

Categories