Table Filter for FlowFields

philippegirod

Hi,

I can't find anywhere the answer to my problem..... if someone could help it will wonderfull.

The idea is this one :
I've a flow field in a newtable wich should calculate the sum of Qty for all entries from "Res. Ledger Entry" (203) where Entry Type is Usage and "Posting Date" is > than a Date Field of my NewTable
The first condition is very easy :

Sum("Res. Ledger Entry".Quantity WHERE (Entry Type=FILTER(Usage))))

but after that and don't know how to do...
And don't know how to use the OnlyMaxLimit and ValueIsFiltet bollean properties.
Please.... help

Sbhat

Hi,

No, in such a scenario i would not recommend you to create a flow field, rather use the code everytime to get the total quantity in Res. Ledger entry table. I would just put a code and dont forget to define a key in resource ledger entry table for "entry type and "posting date" and in the sumindex field of the keys define quantity.

resledg.setcurrentkey("entry type","Posting date");
resledg.setrange("entry type",resledg."entry type"::Usage);
resledg.setrange("Posting date",<New table>."Posting date");
if resledg.find('-') then
resledg.calcsums(quantity);

This should solve your problem.

Regards
Suresh.