Method Community

 

Last Invoice Date

Last post 06-16-2015 10:54 AM by Method_Audisho. 1 replies.
Page 1 of 1 (2 items)
Sort Posts: Previous Next
  • 06-16-2015 10:35 AM

    • kelly
    • Top 500 Contributor
    • Joined on 05-28-2015
    • Posts 19

    Last Invoice Date

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

  • 06-16-2015 10:54 AM In reply to

    Re: Last Invoice Date

    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

    Audisho Sada
    Product Manager
    Method:CRM
    a.sada@method.me
    Toll Free: 1.888.925.6238
    Local & Overseas: 416.847.0400
    Fax: 416.640.6027
Page 1 of 1 (2 items)