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)…
A common request I get from customers is the need to sequence their parts on Pick Lists and in Engineering Reports. MAX sorts by the default Primary Clustered Key PRTNUM_01 (Part Master) or PARPRT_02 in the Product Structure. You can check this login in the Max Sample Company in Management Studio. Have Fun! /* You…
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.
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