Filter

kolaboy

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

tinoruijs

:-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?

kolaboy

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

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.

ar4ijs

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

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

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

kolaboy

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

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

kolaboy

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

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.

kolaboy

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

Thanks everyone, i got it working.
=D>