Vincent Stefanetti – MAX ERP Consultant

MAX 5.5.10 Batch 4800 MAX 5.5.10 Batch 4800 is generally available to MAX customers as of November 14, 2019. This release is an update only. Changes in MAX 5.5.10 • Support for SQL Server 2017 • Defect corrections MAX 5.5.10 CORRECTIONS ID Backlog Group Title Resolved in Build D- 55265 COSTING Total Order Cost report…

Troubleshooting Exchange Integration (checklist) Introduction The integration between Exact Synergy Enterprise and Microsoft Exchange (2010 and higher) is based on Windows Services. The background job used in the previous Microsoft Exchange application is no longer applicable for Microsoft Exchange 2010 (and higher) integration. Two Windows Services can easily be installed via MSI installation process. For…

When a double period is used, as in:   ExactMAXSampleDB..Part_Master   This means the schema is inferred to be the default schema of the current login.   In most cases this will be .dbo. So instead of having to provide it one could use the shortcut of the “..” or more correctly the default for…

Exact MAX TNXCD_58 Field Exact MAX Training Work General Ledger Table I think you’ll find this data useful in trying to comprehend the actuality of the function that was introduced in 5.5.3. First the short answer, if TNXID_58 = 0 that means the entry cannot be tied to a single Transaction History entry.  For AP…

SELECT SS.PARPRT_02, SS.COMPRT_02, SS.EFFDTE_02 , SS.QTYPER_02, (SELECT ‘~’ + US.NOTES_61 FROM Windows_Notes US WHERE US.PRTNUM_61 = SS.PARPRT_02 AND US.COMPRT_61 = SS.COMPRT_02 AND US.EFFDTE_61 = SS.EFFDTE_02 AND US.TYPE_61 = ‘BM’ FOR XML PATH(”) ) [BOM/NOTES] FROM Product_Structure SS WHERE PARPRT_02 <> ” GROUP BY SS.PARPRT_02, SS.COMPRT_02, SS.EFFDTE_02, SS.QTYPER_02 ORDER BY 1, 2 Vincent Stefanetti Senior Consultant…

MAX ERP Client Install Troubleshooting New: Go to \\YourServerName\EXACTSHARED\EXACT\EXACT\RMSERVER\NET\SETUP.EXE then click through and perform a client install. If prompted for license location select: \\ YourServerName \EXACTSHARED\EXACT\RMSERVER\lic folder Login to workstation Navigate to \\ YourServerName \EXACTSHARED\SERVERMOVE Execute the ServerMove.bat as Administrator Review the Command Prompt screen for errors. All copies should succeed. Log into MAX MAX…

Outline: Add Parts and Part Specific Information Add Bills of Materials Add new routing for the top level part to automatically roll the labor cost from the routing. Recalculate Low Level Codes Roll the Cost for the new Assembly Open Bill of Materials Module 1) Open the MAX system manager. 2) Click the Engineering Tab…

  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.

Part_Master Key Value not Found – CLR was disabled If you run into an error like this when you’ve just installed SQL Server and MAX is could be the CLR was not enabled. Verify CLR is enable by running the following server Configuration script. sp_configure @configname=clr_enabled, @configvalue=1 GO RECONFIGURE GO