Solutions - Patriot

Patriot Validator Wont Go Away
Update in Patriot > Patriot V25\ClientSideScripts\DataValidation > Date.js.  This can be used for other vailidators as well.
Thu, Nov 29, 2018 at 10:48 AM
UnPost Cash Batch (Fraternity)
Fraternity batches have dependencies in the AR Journal that must be handled when unposting,  Be sure to use the attached script to unpost a Fraternity Batch...
Thu, Dec 6, 2018 at 3:57 PM
Convert Journals to Events
    -- SELECt Distinct ActivityBeginDt, ActivityBeginDt, JournalDesc, JournalTypeCode, JournalClassificationCode   -- From tblJournals   --   Where Activ...
Wed, Aug 21, 2019 at 4:43 PM
Remove default search
To remove a default search remove all criteria from your seach.  Run the now blank search.  Select "change criteria" and then select button that s...
Tue, Sep 24, 2019 at 11:04 AM
Journal Extract
alter Procedure [dbo].[qRptJournalExtract] --694848 (     @prmSearchID Int ) As SET NOCOUNT ON DECLARE @strSQL        VarChar(8000) DECLARE ...
Tue, Sep 24, 2019 at 11:27 AM
Script to Find The first name Duplicated in the CompleteName
Select  personid, LAStmodon, CompleteNAme, Left(completename, Charindex(' ',completename)-1), len(Left(completename, Charindex(' ',comp...
Tue, Sep 24, 2019 at 4:51 PM
SAI - Per Capita Billing
We have historically run the SAI per capita via stored proc for them.   It takes some coordination with them to prevent creating invoices in existing invoic...
Wed, Oct 2, 2019 at 2:39 PM
Updating tlkZips in Patriot
Pam/Chris -    Attached is what should be an updated zip code data file with all the fields needed to import into Patriot tlkZips.   This file was taken...
Thu, Oct 3, 2019 at 3:15 PM
Script to create unpost Batches in bulk
Select 'EXEC lspUnpostCashbatch ' + Convert(varchar(10),BatchNum) from tblPaymentBatches Where  batchdate >= '1/1/2020' Copy and...
Wed, Feb 26, 2020 at 4:54 PM
Update Donation Batch Date
Script used to update donation batch date.
Wed, Jul 1, 2020 at 2:24 PM