Hi,
I'm trying to put together a flowfield that will calculate whether a customer has purchased in the last 6 months.
I have tried many variations of the below CalcFormula below but keep getting "CALCDATE... is not a valid date"
Share
ReportExist("Cust. Ledger Entry" WHERE (Posting Date=FILTER(> CALCDATE(<-6M>) ),Document Type=FILTER(Invoice),Customer No.=FIELD(No.) ) )
Another one I'd like to do is this for the previous financial year:
Posting Date=FILTER(-CY-1Y..CY-1Y)
*This post is locked for comments
Yes, during the opening of the page you will set the flowfilter which will indeed calculate your flowfield.
Thanks Suresh. It does look like a FlowFilter is the way to go.
I would like the filter set by default though, and I notice on our system (not sure if it is a standard thing) on the Customer List the page loads with "Limit totals to: Where Date Filter is 01/01/18..31/12/18". Do you know where this gets done? Is it C/AL code on the page? Unfortunately I'm not a developer so can't see the code.
Thanks KTA.
Where would I put that code?
You need to do that using a flow filter and then apply your 6M filter to the FlowFilter to Calculate it. Check for example Inventory field on Item, it uses various flow filters.
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
#1
André Arnaud de Cal...
291,269
Super User 2024 Season 2
#2
Martin Dráb
230,198
Most Valuable Professional
#3
nmaenpaa
101,156
All responses (
Answers (