Patriot Software Solutions, Inc.

Update in Patriot > Patriot V25\ClientSideScripts\DataValidation > Date.js.  This can be used for other vailidators as well.

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...

    -- SELECt Distinct ActivityBeginDt, ActivityBeginDt, JournalDesc, JournalTypeCode, JournalClassificationCode   -- From tblJournals   --   Where Activ...

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...

alter Procedure [dbo].[qRptJournalExtract] --694848 (     @prmSearchID Int ) As SET NOCOUNT ON DECLARE @strSQL        VarChar(8000) DECLARE ...

Select  personid, LAStmodon, CompleteNAme, Left(completename, Charindex(' ',completename)-1), len(Left(completename, Charindex(' ',comp...

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...

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...

Select 'EXEC lspUnpostCashbatch ' + Convert(varchar(10),BatchNum) from tblPaymentBatches Where  batchdate >= '1/1/2020' Copy and...

Script used to update donation batch date.