Exact MAX Training Turning off the requirement to enter a default or primary stock ID If keep running into the warning “Primary Stock ID Required” when you are adding parts in MAX you can shut this off. To shut off the warning simply click on the Options menu item in the Bill of Materials module…
Exact MAX Database SSMS 2012 No Ctrl Shift M You may have come across the fact that in SSMS 2012 you can’t use CTRL SHIFT M any more. Below is a link that explains how to fix it. http://blogs.msdn.com/b/monicarivera/archive/2012/08/26/enabling-the-ctrl-shift-m-keyboard-shortcut-for-template-parameters-in-ssms-2012.aspx
Exact MAX Support Dynamics GP Data Mart Currency Errors and Data Mart The official Knowledgebase article from MicroSoft is here: mbs2.microsoft.com/…/KBDisplay.aspx To install the Data Mart in Management Reporter you need to assign both a functional currency and an ISO code to each of your companies in Dynamics GP. Here are the steps: A Functional Currency…
Exact MAX Training How to Process a Subcontract Order Shop Floor Method Setup Set Auto Launch Navigator to “Y” in Shop Floor Key in Configuration Editor in System Manager Add Subcontract Vendors – Purchasing > Acitivity > Purchasing Data > Vendor Master Add Service IDs Shop Floor > Acitivity > Subcontract Services > Service…
Exact MAX Training How to Process a Subcontract Order BOM Method Log into MAX System Manager Go to the Materials tab and select Purchasing Select Activity from the menu and Select Purchase Order Select PO from the menu and select Subcontract Add the line items for the products that will be going out for Subcontract…
Exact MAX Support Setting Up a SQL Maintenance Plan Create SQL Maintenance Plan: In SQL Management Studio ensure the SQL Agent is running. Jobs will not run unless this service is running. Make sure the service is set to automatic. Select the Maintenance Branch, right click and select the Maintenance Wizard Check the following and set…
Synergy HRMail Job Does Not Run Exact MAX Support Synergy was producing Event Log Errors due to the SysHRMail Job not being able to run. The source of that issue was resolved by installing Excel on the App Server. App and DB Server are separate. After the completing the above the job was run manually…
Finding hidden characters in your data using Dynamic T-SQL On occasion you may have run into a situation where you have had extended ASCII characters in your DB fields. They could be from old data conversions or from various problems and errors in the databases. The script below can enable you to find the characters within…
How to Convert Crystal Reports from Pervasive DB to SQL Database Exact MAX Training THIS POST DOES NOT APPLY TO CUSTOMIZED FORMS, SUCH AS INVOICE, PACKING LIST, SALES ORDER AND OTHER MAX FORMS Click Database and then Set Data Source location. In replace with, below, in create new connection select OLE DB (ADO) (click the plus…
Crystal Reports Bar Code DLL U2LBAR.DLL Exact MAX Support Exact MAX Support – Physical Inventory Module You may have occasioned the error in printing tags in the Physical Inventory Module. Error in file PrimTags {8CBE430D0-EF56-4A59-9D1A-B52080D3DBOC}RPT: Error in Formula TagnumberBarCodeCurr: “While printing Records; UFL’u2lbar.dll’that implements this function is missing. You’ll need to copy the u2lbar.dll file…