Re: Last Invoice Date

Method_Audisho — Tue, 16 Jun 2015 15:54:40 GMT

Hi Kelly,

There is no Last Invoice Date field on the stock Customer and Contacts List screen. Are you perhaps referring to the Last Activity and Next Activity fields? If so, these fields are special Method fields and cannot be modified in any way.

If you do see a Last Invoice Date field on your screen, then it was created via customization. There are a couple of ways that we would normally use to populate such a field. The first is via an SQL override and the second would be to run an action set that would loop through your customers, retrieve the most recent invoice date and store it in a custom field on the customer table. The logic of each can be changed by modifying your SQL override query or your action set respectively.

I hope this helps.

-Audisho

Last Invoice Date

kelly — Tue, 16 Jun 2015 15:35:39 GMT

Hi - How does this field populate? Can I change this field manually? This is the one under the Customer Contact list screens

Method:Classic General Q&A

Re: Last Invoice Date

Last Invoice Date