Monthly Archives: August 2015

Management Report Setup Important

After CU 11 you need to:Go to Microsoft Dynamics GP > Tools > Setup > Company > Company.Click on “Options” to open the “Company Setup Options” window There is a separate section for management reporter integration with Dynamics GP when … Continue reading

Posted in Uncategorized | Leave a comment

Resetting the QuickBooks FIM Integration for Exact MAX

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 … Continue reading

Posted in Uncategorized | Leave a comment

Clearing up Posting in Exact MAX

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 … Continue reading

Posted in Uncategorized | Leave a comment

Upgrades form SQL 2005 to Later Versions for Exact MAX

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. 

Posted in Uncategorized | Leave a comment

Use of Parameterization on SQL Database for Exact MAX

  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 … Continue reading

Posted in Uncategorized | Leave a comment

Multi-Column Report for Serial Numbers

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 … Continue reading

Posted in Uncategorized | Leave a comment

Linking the Order Master to the Sales Master Table in ExactMAX for AutoGenerated Master Scheduled Orders

  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.

Posted in Uncategorized | Leave a comment