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…
Here’s a chart of the Exact MAX GL Account Table Default Codes. You can use this in comparison with the GL Account Report in financial integration to audit the table. GL Default Account ID Account Name Normal Balance Type ACCTPAY Accounts Payable Credit ACCTREC Accounts Receivable Debit ADJCHRG Adjustment (Reduction or increase) to Stock Expense…
Pilot Testing Checklist.docx
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…