Exact MAX Consultants Information and Resources
Outline: Note: If you own the Warranty Tracking Module then please review the basic RMA processing. Adding the rework shop order is part of the overall procedure. Receive Defective Product to Inventory Create Rework Shop Order Add Unit to be repaired to the Order Bill and any other Components required for the repair to shop…
Outline: 1) Setup 2) Procedure a. Requisition b. Directly Add Non-Inventory PO Setup: 1) System Configuration Switches a. Set GL Ref required if desired GL Reference Required: If you set this switch to Y, Exact MAX will require a valid GL Reference when receiving non-inventory purchase orders (see Inventory > Transactions> Non-Inventory tab). If an…
Most users of MAX at one time or another have run into the arduous task of trying to edit MAX forms and reports. The main thing to realize is that the report extract file pre-creates report sections. If you look at the formulas you’ll see {Report_Extract.GRP} < 10 or =1 and so on. Well, if…
On occasion I have users tell me that their Access applications or external apps are not working after an upgrade. If you’ve done a backup or restore of a database you might have lost security to it. Check the security for the MAX Users group if you have one or the specific user/s User Mapping….
1. Start the MS Access app by holding down the shift key while double clicking the Access.MBD file (bypasses any Macro or Switchboard Screen that could prevent access to the tables) 2. Select to access all tables only 3. Right click a MAX Table and rename it to (table name)_old 4. Click on External Data…
First create the Function below. Next, run the query against your source DB, be sure to change the parameters so you get the length you want. This was used on a migration from MAS200 to MAX where the Sales Order Notes was a long string in an old text column (this was a challenge too)…
The other day I had a customer ask me for a query that would find Part Routing records the did not include a specific workcenter. I provided this snippet to help. This query selects the set that includes both(or all depending) work centers then “excepts” or removes the ones that contain “Work Center A”. USE…
Here’s another report that can be used to audit for parts without costs.
Occasionally you may need to check to see if there are parts in your database that are not contained in a Bill of Material. You can import this SSRS .RDL file to your Visual Studio project and deploy it to the SQL Server Reporting Services web site.