I want to generate a month on month vendor payment report.
Can anyone guide me how to get this in NAV 2013 R2 ?
For Example our Company has 200 vendors and we make variable payment month on month. We need a report say Vendors under Rows and months (April to March) under columns which should display payments or provision made against the vendors.
Hi Prabakaran, I Think There maybe a Standard Report How to get By Columns But Anyway Can you try Using Matrix Table So that Rows Contain Vendors Name and Columns By Amount or Whatever fields You Need Fields. Now Coming to Business Group Column By Select Column --> Group Properties-->GroupExpressions --> Add--> fx--->=Month(Fields!PostingDate_VendorLedgerEntry.Value) Note :- If you Want to Find Monthly totals Spend by vendor Don't Forget to write exp like =Sum(Fields!OriginalAmtLCY_VendorLedgerEntry.Value). If you need any Further Help Let Me Know..
Thanks for the Great words.. & sorry to get you angry.
I guess this is what you are looking for -
StartDate := 040116D; //Month-Date-Year (My System)
FOR I := 1 TO 12 DO BEGIN
DisplayText[I] := FORMAT(StartDate,0,'<Month Text>'); //Give You Report Header
CalcultationFilter[I] := FORMAT(StartDate) + '..' + FORMAT(CALCDATE('1M-1D',StartDate)); //Give you Filter for the Code That You Need
StartDate := CALCDATE('1M',StartDate);
StartDate - DataType (Date)
I - DataType (Integer)
DisplayText & CalcultationFilter - DataType (Text) and Dimensions = 12
Here is what you get in RDLC -
Let me know even if you want rest of the code.