FlowFilter Cronus database

ataris

Hi All,

I could be going completely mad but if you design the Cust. Ledger Entry table and use the Date Filter to filter on dates within the table the Flowfilter doesn't work.

It looks like it has been setup correctly, has anyone else experienced this?

I have tried fixing this but can't and it's bugging me big time.

Balello

What kind of error did you get?

ataris

No error occurs.

It just ignores the filter ](*,)

Balello

Date filter filters on detail customer ledger entries when retrieving castomer ledger entry flowfields values. So it doesn't filter on customer ledger entries. I can be more explicit, but I need to undertand if the problem is that or It's at a deeper level.

ataris

From what I can understand the Cust. Ledger Entries are calculating flowfields from the Detailed Cust. Ledger table. So a Flowfilter has been set on the Amount field of the Cust. Ledger table which is looking at the Detailed Ledger table and a key has been setup on the Detailed Cust. table for Posting Date and a SumIndex of Amount to calculate the amounts by Posting Date.

If you run the Cust. Ledger table to use the FlowFilter it doesn't filter by Posting date. It's at the Cust. Ledger level which it's not working on.

Balello

Yes, you got it. When you push the drilldown button on the flowfield you should see the detail entries whose sum gives the amount. And if the flowfilter is set, you shouldn't see detailed entries whose posting date is outside the filter. I try on my database and it works good. :-k

ataris

How strange.

I even loaded another Cronus database on my drive and tried that one out and it still did not work.