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
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)…
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.
Transaction Transaction Code Debit Credit Adjustment to Stock (Favorable) A INVENTORY ADJCHRG Adjustment to Stock (Unfavorable) A ADJCHRG INVENTORY Customer Shipments (CU Orders) S CSTOFSLS INVENTORY Customer Shipments (CR Orders) S INVENTORY CSTOFSLS Cycle Count Adjustment (Favorable) C INVENTORY CYCCHRG Cycle Count Adjustment (Unfavorable) C CYCCHRG INVENTORY Post Time Ticket Completion P or Q WIP…