get filter from flowfield

TikusJalang

hello I want to ask...
is it possible I get the filter from the calcformula, so I can apply that filter to another field?

thnks...

johnson_alonso

where do you want to get the calcformula and to where do you want to apply ?


:whistle:

rgds,
Johnson Alonso

kriki

I don't know a way how you could get that filter (except by coding it).

TikusJalang

I want to result sum net change at G/L Account form, base on resp. centre.
resp. centre is different from one user to another, if one user login and open the form G/L Account, so he/she just see the transaction g/l entry that he/she made before, other transaction from other users is invisible at g/l entry and not calculated at net change....

@kriki
can we get the filter by coding?
i've tried getfilter and getfilters,the filtering couldn't work......

if we look properties field net change at g/l account table, its calcformula like this

Sum("G/L Entry".Amount WHERE (G/L Account No.=FIELD(No.),G/L Account No.=FIELD(FILTER(Totaling)),Business Unit Code=FIELD(Business Unit Filter),Global Dimension 1 Code=FIELD(Global Dimension 1 Filter),Global Dimension 2 Code=FIELD(Global Dimension 2 Filter),Posting Date=FIELD(Date Filter)))

nah, I want to know can we coding for onlymaxlimit and valueisfilter?
:roll:

kriki

In the index of the entries, you have to add responsibility center to be able to SIFT on it.
In G/L Account, you have to put a new flowFILTER=responsibility center.

In the OnAfterGetRecord, you add a filter to your flowFILTER-field, and do a CALCSUMS of your sift-fields.
If the user does a dropdown to see the entries involved, he can always delete the filters. If you don't wont him to remove the filter on responsibility center, you have to add some code in the entries-form that saves the filter on responsibility center and puts it also in another FILTERGROUP, so the user cannot delete the filter.

TikusJalang

ok, problem soved....

thnks a lot...... :-({|=