a small prob

daroon
Member Posts: 35
Hi all out there,
I have a flow field in a table. In the properties under Calcformula there is
Sum(Debitorenposten."Restbetrag (MW)" WHERE (Offen=CONST(Ja),Debitorennr.=FIELD(Nr.),Kostenstellencode=FIELD(Kostenstellenfilter),Kostenträgercode=FIELD(Kostenträgerfilter),Fälligkeitsdatum=FIELD(Datumsfilter),Währungscode=F IELD(Währungsfilter),Profitcentercode=FIELD(Profitcenterfilter)))
and the field Fälligkeitsdatum i want to filter, like "..workdate", i mean from start to today ? How can i put this filter in this properti ??
Much thnx for helping me
Greetz
reen
I have a flow field in a table. In the properties under Calcformula there is
Sum(Debitorenposten."Restbetrag (MW)" WHERE (Offen=CONST(Ja),Debitorennr.=FIELD(Nr.),Kostenstellencode=FIELD(Kostenstellenfilter),Kostenträgercode=FIELD(Kostenträgerfilter),Fälligkeitsdatum=FIELD(Datumsfilter),Währungscode=F IELD(Währungsfilter),Profitcentercode=FIELD(Profitcenterfilter)))
and the field Fälligkeitsdatum i want to filter, like "..workdate", i mean from start to today ? How can i put this filter in this properti ??
Much thnx for helping me
Greetz
reen
0
Comments
-
It is all built-in in the "Datumsfilter" field. When the end-user fills in the "Datumsfilter" field (using Shift-F7) like ".. t" than Navision interprets this as "from start to today". No extra programming is necessary.No support using PM or e-mail - Please use this forum. BC TechDays 2024: 13 & 14 June 2024, Antwerp (Belgium)0
-
thnx for help, but i dont want that the user had to put it in himself, the system should do it "automaticly"0
-
Then the answer is simple: you can't. You can't use WORKDATE or TODAY in calcformula's.
But what is the problem. The user doesn't have to fill in this field. And if it's blanc, Navision uses ALL the dates. Or you can leave that field out of the calcformula. So again, what is the problem?
[ 22-01-2002: Message edited by: Luc Van Dyck ]No support using PM or e-mail - Please use this forum. BC TechDays 2024: 13 & 14 June 2024, Antwerp (Belgium)0 -
the problem is that this field has to calvulate ALL things that a Firm had to pay until today. They have to pay bills within 2 weeks, so in the table there are all bills to pay, but the sum sould only have all bills that should be paid until TODAY, you understand
thnx for helpin me so much
reen0 -
OK, now I understand. I think you have to use a variabele on the form, and calculate that value instead of using calcformula's.
Have a look at form 151 Customer Statistics. Here, the field "Total (LCY)" is calculated on that form (have a look at the code on the form). You'll have to write your own code to calculate your field.
If you need this field again in eg. a report, you have to code it again. That is the drawback.
Hope this helps.No support using PM or e-mail - Please use this forum. BC TechDays 2024: 13 & 14 June 2024, Antwerp (Belgium)0
Categories
- All Categories
- 73 General
- 73 Announcements
- 66.6K Microsoft Dynamics NAV
- 18.7K NAV Three Tier
- 38.4K NAV/Navision Classic Client
- 3.6K Navision Attain
- 2.4K Navision Financials
- 116 Navision DOS
- 851 Navision e-Commerce
- 1K NAV Tips & Tricks
- 772 NAV Dutch speaking only
- 617 NAV Courses, Exams & Certification
- 2K Microsoft Dynamics-Other
- 1.5K Dynamics AX
- 320 Dynamics CRM
- 111 Dynamics GP
- 10 Dynamics SL
- 1.5K Other
- 990 SQL General
- 383 SQL Performance
- 34 SQL Tips & Tricks
- 35 Design Patterns (General & Best Practices)
- 1 Architectural Patterns
- 10 Design Patterns
- 5 Implementation Patterns
- 53 3rd Party Products, Services & Events
- 1.6K General
- 1.1K General Chat
- 1.6K Website
- 83 Testing
- 1.2K Download section
- 23 How Tos section
- 252 Feedback
- 12 NAV TechDays 2013 Sessions
- 13 NAV TechDays 2012 Sessions