Filter

kolaboy
kolaboy Member Posts: 446
edited 2008-04-04 in NAV/Navision Classic Client
Hi,
I am trying to show a form on the Menu that will result after going through:
General Ledger - Chart of Account - Account - Ledger Entries.
This shows General ledger Entry form. Here you can click on Table filter to get G/L Entry-Table filter. G/L Entry-Table filter will enable you to filter on the table. Now i want only G/L Entry-Table filter to show on a Menu without having to go through General Ledger - Chart of Account - Account - Ledger Entries. and then click on table filter to have access to it.

I want a way that you can just click onces and G/L Entry-Table filter appear. Then the user just place the filter he/she wants and filter. We don't want the user to be able to click on the table filter after going through General Ledger - Chart of Account - Account - Ledger Entries..
Any ideas please.
Thanks

Answers

  • tinoruijs
    tinoruijs Member Posts: 1,226
    :-k
    So you want form 20 General Ledger Entries to appear after the user first enters a g/l account no.?
    We don't want the user to be able to click on the table filter after going through General Ledger - Chart of Account - Account - Ledger Entries..

    Why not? What the thought behind that?
    Tino Ruijs
    Microsoft Dynamics NAV specialist
  • kolaboy
    kolaboy Member Posts: 446
    They are Auditors. They Can't go through that process. We just want to make things easy for them.

    I want them to see G/L Entry-Table filter when they log in, so that they can just enter g/l account no. to filter.
    Is there a way to achieve this?
    Thanks
  • tinoruijs
    tinoruijs Member Posts: 1,226
    kolaboy wrote:
    They are Auditors. They Can't go through that process. We just want to make things easy for them.

    I want them to see G/L Entry-Table filter when they log in, so that they can just enter g/l account no. to filter.
    Is there a way to achieve this?
    Thanks

    No. You can't start a form with a filter. Not like in a report.

    You could add form 20 to the menu and when form 20 is opened, you could use sendkeys (search forum for more about sendkeys) to open the filter directly.

    But I wouldn't go that far.
    Just add form 20 to the menu and let the auditors click on the Table Filter button themselves.
    Tino Ruijs
    Microsoft Dynamics NAV specialist
  • ar4ijs
    ar4ijs Member Posts: 24
    Maybe you can create new form with one field for Account No. filter. When user sets the filter, you open next Entries form with filter passed.
  • kolaboy
    kolaboy Member Posts: 446
    ar4ijs wrote:
    Maybe you can create new form with one field for Account No. filter. When user sets the filter, you open next Entries form with filter passed.

    How can i Achieve this. I created a form as you said but i is not allowing me to enter g/l account no. to filter so that i can get a filtered result.
    Thanks
  • Savatage
    Savatage Member Posts: 7,142
    Is the form you created a tabular type form?

    Now, you want a box at the top or the bottom where they can enter a g/l account no and the tabular form will filter the results for that account no.?

    have you tried creating a Variable EnterAccountNo code size 20
    add a text box to form with EnterAccountNo as sourceexp.

    Add OnValidate SETRANGE("G/L Account No.", EnterAccountNo);

    I'm assuming your talking g/l entries :-k
    Harry Ruiz
    http://www.BiloBeauty.com
    http://www.autismspeaks.org
  • kolaboy
    kolaboy Member Posts: 446
    Savatage suggestion works., Am am trying to apply it on form 372 but the text box is not coming. It looks like a button, not a text box. The same thing happens to form 5604.

    What is the problem. Why can't i have a text box on the variable i defined and used as sourceExp?
    Thanks
  • Savatage
    Savatage Member Posts: 7,142
    kolaboy wrote:
    It looks like a button, not a text box.

    I'm not sure I understand a test box is a text box a button is a button.

    Are you sure your selecting the correct option from the toolbox?

    don't forget about setting the vert & horizontal glues.

    isn't it easier to teach them to:
    1)click on a field
    2)F7
    3)Enter

    Here a quick example you can try..
    (Not sure what fields you need to filter)
    so I made 2 text boxes where you can filter on A Bank Account No or A Posting Date or Both.
    http://savatage99.googlepages.com/Form5 ... terTes.fob
    Harry Ruiz
    http://www.BiloBeauty.com
    http://www.autismspeaks.org
  • kolaboy
    kolaboy Member Posts: 446
    Savatage wrote:
    kolaboy wrote:
    It looks like a button, not a text box.

    I'm not sure I understand a test box is a text box a button is a button.

    Are you sure your selecting the correct option from the toolbox?

    don't forget about setting the vert & horizontal glues.

    isn't it easier to teach them to:
    1)click on a field
    2)F7
    3)Enter

    Here a quick example you can try..
    (Not sure what fields you need to filter)
    so I made 2 text boxes where you can filter on A Bank Account No or A Posting Date or Both.
    http://savatage99.googlepages.com/Form5 ... terTes.fob
    Savatage your example works and i am trying to use your example on form 5604 but its not working. I have use the vert & horizontal glues, but iits just not working on 5604.
    What am i doing wrong?
    Thanks
  • Savatage
    Savatage Member Posts: 7,142
    we don't use fa ledger entries I can't test it.
    note you should add a CurrForm.UPDATE;
    on the onaftervalidate trigger as seen in the test fob.
    Harry Ruiz
    http://www.BiloBeauty.com
    http://www.autismspeaks.org
  • kolaboy
    kolaboy Member Posts: 446
    Savatage wrote:
    we don't use fa ledger entries I can't test it.
    note you should add a CurrForm.UPDATE;
    on the onaftervalidate trigger as seen in the test fob.

    I added CurrForm.UPDATE; but still not workihg.
  • kolaboy
    kolaboy Member Posts: 446
    Thanks everyone, i got it working.
    =D>

Categories