Handy Date Calculations

  /* Handy Date Stuff */ —-Today SELECT GETDATE() ‘Today’   –Full Day SELECT CAST(GETDATE() as date) AS DT  —-Yesterday SELECT DATEADD(d,-1,GETDATE()) ‘Yesterday’  —- Previous Day  DATEADD(day, DATEDIFF(day, 0, yourDate), 0)   —-First Day of Current Week SELECT DATEADD(wk,DATEDIFF(wk,0,GETDATE()),0) ‘First Day of Current Week’  —-Last Day of Current Week SELECT DATEADD(wk,DATEDIFF(wk,0,GETDATE()),6) ‘Last Day of Current Week’  —-First…

Read More

Dynamics GP Feature List

Dynamics.set – List of Dynamics GP Products Product Code Main Dictionary Forms Reports Microsoft Dynamics GP 0 Dynamics.dic Forms.dic Reports.dic Project Accounting 258 PA258.DIC PAFORM.DIC PAREPT.DIC Fixed Assets 309 FAM.DIC F309.DIC R309.DIC Manufacturing 346 ICONMFG.DIC ICONFRMS.DIC ICONRPTS.DIC Human Resources 414 HR.DIC HRPFROM.DIC HRPRPTS.DIC FieldService 949 SRVSADV.DIC FRMS949.DIC RPTS949.DIC Interfund Management 1042 IFUND.DIC 1042FORM.DIC 1042RPTS.DIC Revenue…

Read More

MAX Anywhere Activation Issue

When logging into MAXAnywhere, it reports that the MAX license is not activated even though the license has been successfully activated and the MAX clients do not report any activation issues. MAXAnywhere stores the activation/connection information in the web.config file. This message could be the result of a mismatch between the connection information in this…

Read More

Cash Requirements SQL

Cash_Requirements Download and rename to .sql and open in Management Studio — Create a Stored Procedure using this code DECLARE @Rng_CashRequirement int = 0 –0 = All, 1 = Range, 2 = Individual DECLARE @Rng_CashRequirement_Start nvarchar(30) = ” DECLARE @Rng_CashRequirement_End nvarchar(30) = ” DECLARE @Rng_CashRequirement_Individual nvarchar(MAX) = ” DECLARE @Rng_CashRequirement_Field int = 0 –0 =…

Read More