Customer-Summary Aging Report Problem

Mrinmay

Hi Exparts,
I have got a problem in cutomer -Summary Againg Report. actually it is not filtering the data accorinding to dimensions. can any body explain me why it is not coming? in detailed cutomer ledger entry the dimension is storing as Initial entry global dimension. still is not coming. In report i am selecting Dimension filters.

I have another question also. what is the difference between Global dimension Code and Global Dimension Filter.

Regards
Mrinmay

ara3n

You need to modify the report and add the following code.

Customer - OnAfterGetRecord()
PrintLine := FALSE;
LineTotalCustBalance := 0;
Customer.COPYFILTER("Currency Filter",DtldCustLedgEntry."Currency Code");
//MOD01 start
Customer.COPYFILTER("Global Dimension 1 Filter",DtldCustLedgEntry."Currency Code");
//MOD01 ENd
FOR i := 1 TO 5 DO BEGIN
  DtldCustLedgEntry.SETCURRENTKEY("Customer No.","Initial Entry Due Date");

ara3n

I have another question also. what is the difference between Global dimension Code and Global Dimension Filter.

Dim Code is a regular field that is used to define the default dimension.
Dim Filter is a flow filter and it is use for setting dynamic filters to calculate flowfields. Balance on customer card for example.

Also for the code change above use the global dim filter on the report.

Mrinmay

Hi Rashed,
Thanks for ur reply. I have added code how u told. but still it is not coming properly.it is not filtering the data according to filters. for currency fiter it is coming properly.


Regards,
Mrinmay

ara3n

sorry I made a mistake.

Customer.COPYFILTER("Currency Filter",DtldCustLedgEntry."Currency Code");
//MOD01 start
Customer.COPYFILTER("Global Dimension 1 Filter",DtldCustLedgEntry."Initial Entry Global Dim. 1");
//MOD01 END

notice DtldCustLedgEntry."Initial Entry Global Dim. 1"