Vincent Stefanetti – MAX ERP Consultant

    First Date of last month =DateAdd(“m”, -1, DateSerial(Year(Now()), Month(Now()), 1)) =Today.AddDays(1- Today.Day).AddMonths(-1) Last date of last month =DateAdd(“d”, -1, DateSerial(Year(Now()), Month(Now()), 1)) =Today.AddDays(-1.0 * Today.Day) First date of current month =DateSerial(Year(Now()), Month(Now()), 1) =Today.AddDays(1 – Today.Day) Last date of current month =DateAdd(“d”,-1,(DateAdd(“m”, 1, DateSerial(Year(Now()), Month(Now()), 1)))) =Today.AddDays(-1 * Today.Day).AddMonths(1) Yesterday’s date  =DateAdd(“d”, -1,…

  /* 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…

1) First, I would remove the integrated applications in QB (Edit–Preferences–Integrated applications–Company tab). Highlight the two and remove.2) Next, I would delete the ExactRM user in QB3) Then remove the QBFC 11 from Control Panel–Uninstall Program4) Rename the ExactMAXQB.xml.5) Make sure all users are out of MAX and QB.6) Go to Finance–Financial Integration–Options–Integration Setup. Click…

1. To clear up the Invoice Edit list – Set INVCE_27 to “Y” or … a. Stop shipping b. Have them post all sales orders that they want to actually go through c. Turn off the integration with Great Plains d. Post all remaining orders e. Turn on the integration with Great Plains f. Resume…

When upgrading MAX databases from SQL 2005 be sure to change the legacy setting of TORN_PAGE to CHECKSUM in the PAGE_VERIFY setting of your MAX database. 

  In some cases setting the database Parameterization setting may increase performance of MRP Explosion and other sizable batch processes. Testing this in your test environment is definitely recommended. Change this setting under options in your SQL database and benchmark the change in processing time.

I recently had to create a report that needed adjacent columns of serial numbers much like columns in a Word document. I pored over several advices but in the end discretely defining the number of serial numbers per column worked out best. I used the code below to get a row number and list them…

  SELECT Order_Master.ORDNUM_10, CM.NAME_23, CM.COMNT1_23, CM.COMNT2_23, CM.UDFREF_23FROM Order_Master INNER JOINSO_Master SMon LEFT(CUSORD_10,8) = SM.ORDNUM_27inner join Customer_Master CM on SM.CUSTID_27 = CM.CUSTID_23WHERE – Add anything here that you need to select the proper record set.

    @echo =========  SQL Server Ports  ===================@echo Enabling SQLServer default instance port 1433netsh firewall set portopening TCP 1433 “SQLServer” @echo Enabling Dedicated Admin Connection port 1434netsh firewall set portopening TCP 1434 “SQL Admin Connection” @echo Enabling conventional SQL Server Service Broker port 4022  netsh firewall set portopening TCP 4022 “SQL Service Broker” @echo Enabling…