Filtering Budget

Est005

Hi,

I am using the Budget form to look up G/L Account No. from the Purchase Lines but I need to filter it so it shows only certain accounts that the user is allowed to view. I have made a copy of the Budget form, and am able to return the G/L Account selected form it to te Purchase Lines, but I can't find way to filter the Budget form so it shows me only the allowed accounts.

Help please....

Thanks in advance.

Est005

Hi,

I found a solution to my problem, I created a function that sends a filter string, to the Budget Form and sets the G/L Account filter to that string, problem is the length of the string is limited to 250 characters, so looking for a way around that now. Will post once I find it. If anyone has any suggestions please let me know.

Est005

Can anyone help with this, here is some more detail:

I am using the Budget form 113, but I need it filtered according to specific G/L accounts, problem is I can't use the G/L Account Filter on the form because the size of the filter string is longer than 250 characters. I can Mark the records I need through the code, but I can't show MARKEDONLY, I am guessing this is because the form is generated using buffer tables and everything is in memory.

Any ideas or suggestion please, I have spent the whole week on this.

Thanks in advance.

kitik

Create a new form, based on a temporary table.
Use the G/L Account table. Insert on the temporary table, only the accounts you need. This way you don't have to filter anything.

Salut!

Est005

Hi,

Unfortunately the powers that be, want to view the Budget form, so that is not an option. Originally that how I had done, it.

kitik

I don't really underestand why? Is it because they like the way the budget looks or is there any other reason?

Salut!

Est005

Well yes, it's the way the budget looks, and the fact that they can view available budget for a period. Do you think it's possible to do what I am trying?

kitik

Take a look on how the functions FindRec and NextRec works. Try not to insert the accounts you don't want to see.

Salut!