In Navision RDLC if we want Week No. Month Wise i.e. if a invoice is posted on 15/04/2016 then Week no. should come 3.
Note : Initially week starts from Monday but what if we want week no. of a month where week starts from Sunday.
When you are developing a Report in NAV with a Requirement that with Posting Date you also have to provide Week No. in which that particular Posting Date comes. (Month Wise with starting week day "Sunday").
As per the above requirement given below are the required Variables & Code for the same.
##C/AL Globals (Variables) :
Name DataType Subtype
DateRec Record Date
WeekNo Integer
StartDate Date
EndDate Date
Ctr Integer
PDStartDate Date
PDEndDate Date
PDStartBLN Boolean
DStartDate Date
DEndDate Date
##Code on Trigger (On After Get Record) :
Note : Initially week starts from Monday but what if we want week no. of a month where week starts from Sunday.
When you are developing a Report in NAV with a Requirement that with Posting Date you also have to provide Week No. in which that particular Posting Date comes. (Month Wise with starting week day "Sunday").
As per the above requirement given below are the required Variables & Code for the same.
##C/AL Globals (Variables) :
Name DataType Subtype
DateRec Record Date
WeekNo Integer
StartDate Date
EndDate Date
Ctr Integer
PDStartDate Date
PDEndDate Date
PDStartBLN Boolean
DStartDate Date
DEndDate Date
##Code on Trigger (On After Get Record) :
