Customer aging report for multiple legal entities
In one of our client, there were more than 5 legal entities which share the same customers as the customer were merged from Global address book. System doesn't provide the aging for multiple legal entities, so it was very difficult for the user to export the aging report from each company and then merge them because there were thousands of customers. Hence it was decided to create a separate aging report. First I created a query in AOT. Here is the contract class to get As on date. [DataContractAttribute] class DSS_CustomerAgingComparisonContract { Amount Amount; FromDate asOnDate; [DataMemberAttribute("As On Date") ,SysOperationLabelAttribute(literalStr('As of date'))] public FromDate parmFromDate(FromDate _asOnDate = asOnDate) { asOnDate = _asOnDate; return asOnDate; } } ...