We have a lot of customers that have no recent activity, either open sales orders or invoices. I know I could report on this by doing a group by GI with Customers, grabbing the max order date from SOOrder and the max invoice date from ARInvoice, but I really want to get this in front of the users both in the Customers GI as well as on the Customers screen.
I see there is a “LastActivity” date in the Customers DAC, but it’s marked as Obsolete (we’re on 23R1, upgrading to 25R1 later this month). Are there any other “In DAC” values that would help me avoid adding yet another set of joins (and the complexity of needing to group by the relevant customer fields) to the Customers GI?
I’m going to post another thread in the Development forum about adding a DAC field, but before I write up a customization I wanted to see if I was missing something obvious already in the system.
