Hi experts, i tried to get the customer ageing report by filtering business unit but no luck. when i am giving the below filter it is taking all the customers where at least one open invoice from the selected BU. I am looking for an ageing report which consist only the open invoices in the selected BU. anybody please help me.
Here is the code to fetch the data for selected Financial Dimensions.
I Did for the BussinessUnit dimension by passing hard coded value as 1103".
DefaultDimensionView defaultDimensionView; CustTrans custTrans;
delete_from custAgingReportTmp exists join custTrans where custTrans.Invoice == custAgingReportTmp.InvoiceId && custTrans.Voucher == custAgingReportTmp.Voucher && custTrans.TransDate == custAgingReportTmp.TransDate exists join defaultDimensionView where defaultDimensionView.DefaultDimension == custTrans.DefaultDimension && defaultDimensionView.Name == "BussinessUnit" && defaultDimensionView.DisplayValue != "1103";