Military customers

ChasityD Registered User ✭✭
Is there a report showing all military customers??


  • storable_support
    storable_support Registered User, Registered Moderator, Community Manager ✭✭✭✭✭
    @ChasityD - We do not currently have a report showing all military customers. However, you can try this query in the "Custom Reporting" screen and it may help you to find active tenants flagged as military:

    Select T.*
    From Tenants T
    join MktgType M on T.MktgTypeID = M.MktgTypeID and T.siteID = M.siteID
      Select Count(L.LedgerID)
      From Ledgers L
        Inner Join Access A On L.LedgerID = A.LedgerID
      Where A.TenantID = T.TenantID
      And L.dMovedOut Is Null
      And L.dDeleted Is Null
    ) >= 1
    and m.sdefmktgtypedesc = 'Military' (edited) 
    GM_SJ_BSS Registered User ✭✭✭
    If you offer a military discount you pull up the discount reports

© 2018 SiteLink Software, LLC. All Rights Reserved

Terms of Use  |  Privacy Policy   |  Cookies Policy   |  Help  |  Contact Community Manager   |  Change Marketplace Ads