MRP Command Line Batch Sample with Log File
1) Open the txt file and edit the file as needed. 2) Rename the sample file to .BAT. 3) Copy to the Server and place in the \EXACT\RMCLIENT\EFW folder 4) Enter a Scheduled Task in Windows to run it. MRP
Read More
Configuring the MRP Command Line
Configuring the MRP Command Line 1) First create a user called EXPLOSION with password EXPLOSION (or other) with access to the MRP Explosion in the MRP module. All other selections can be set to Read or No Access. 2) Reg Update (not required in 5.5.6 update) NOTE!! 5.5.6 Has the capability to specify the company…
How to Backup and Restore your MAX Suite Databases on SQL Server
It is quite common to backup and restore. Here’s a procedure to help you do it in SQL 2012. Backup 1) Log into SQL Server Management Studio on your Database Server (server that has SQL Server Loaded) 2) In the Object Explorer expand the databases tree and right click on the database name that you…
How to Manage Custom Crystal Reports
In the RMServer\NET\Updates folder there is a new folder named CustomReports. This folder is where customized versions of the reports should be kept. A check is done each time System Manager is launched, this check will copy any updated reports from RMServer\NET\Updates\CustomReports to the client machines C:\Exact\RMClient\EFW folder. This is a significant change in functionality…
How to Add a Purchase Order
Once the orders have been approved in MRP and the Purchase Requisitions have been created, Purchase Orders can be added. Note: That you can manually add an unplanned PO or Non-Inventory PO in the Purchasing Module at any time. To create Purchase Orders, do the following: 1) Log into MAX 2) From the System Manager…
Code to Produce Multi-Level Parent Component Bill of Materials – Effective Date Logic and Non-Zero Qty’s
Hi All, I thought I would write a post that covers a common necessity. One also needs to have filter for the occurrence of a non-zero and the current effective date. I’ve included both the Multi-Level CTE Recursion and the Non-Zero and Effective Date view which is inner joined. Let me know if you have…
How to Process and Maintain Forecast Orders in Exact MAX
· Using the Max User Interface to Maintain Forecast · Using Extract, Transform and Load to Load and Maintain your forecast using Excel Using the Max User Interface to Maintain Forecast 1) Log into MAX System Manager 2) Click Materials Tab > Master Scheduling 3) Select Activity > Forecast Order 4) Enter Part / Date…
How to Test SMTP Email Using Telnet
Open a telnet session: From a command prompt, type telnet, and then press ENTER. Type set local_echo on a computer running Microsoft Windows® 2000 Server or SET LOCALECHO on a computer running Windows Server™ 2003 or Windows XP, and then press ENTER. This command allows you to view the responses to the commands. Type o…
How to Create Parent, Component, Qty Per from Solidworks Item Code Sequences 1.1.1.1
Hi – I thought I would do a post regarding parsing the Solidworks Item Number. In my travels I’ve often run into this issue and it you use this code you can create a parent component relationship with the qty per from a Raw Export. Note that your input field would have the following fields….
How to Setup Lot Serial Structure – Visual As Built
Information: The Visual As-Built allows you to create lot and serial structures to provide for a complete lot and serialized build traceable in the MAX system. This is necessary when you have a serialized parent on a shop order and you need to link the serial number of components to each individual parent serial number…