Micro Manufacturing Systems
Micro Manufacturing Systems
  • Home
  • My Offers
    • MAX Consulting
    • Remote Business Analysis
    • MAX Systems Review
    • MAX Training
    • MRP Planning
    • Capacity Planning
    • KPI Trends
    • Quality At Receiving
    • SQL Scripts for MAX
    • KnowledgeSync Alerts
    • Process Executor
    • Crystal Reports for MAX
    • Database Documentation
  • Solutions Blog
  • About
  • More
    • Home
    • My Offers
      • MAX Consulting
      • Remote Business Analysis
      • MAX Systems Review
      • MAX Training
      • MRP Planning
      • Capacity Planning
      • KPI Trends
      • Quality At Receiving
      • SQL Scripts for MAX
      • KnowledgeSync Alerts
      • Process Executor
      • Crystal Reports for MAX
      • Database Documentation
    • Solutions Blog
    • About

  • Home
  • My Offers
  • Solutions Blog
  • About

SQL Scripts for MAX

The Next Step(s) in Automation

Custom programming has evolved to the database level.  SQL scripts may be used to created new data tables and write data to those tables (e.g., create a table to receive the tracking number from your shipping system).  They can also be used to create views to simplify reporting.


My favorite example of a SQL script is Material Overhead Update.  The process is simple; enter a new overhead rate, write that rate to the Part Master for all purchased parts, and then recalculate the total cost for the part using material, labor, overhead and subcontract cost elements.  Twenty-five years ago we wrote this as Visual Basic application.  Today, it is a script that resides in your database.  There are obvious savings in overhead between the two approaches.


Convert Configured Order is the most complex example of how SQL processing can be exploited.  This script will read the configuration string for a Features and Options Sales Order and convert that data into a new, unique Part Identifier and standard Bill of Material (BOM).  This allows the completed configured part to be stocked (i.e., finished goods and consignment at dealers/distributors) and managed as "normal" inventory.  Having "normal" engineering documentation also facilitates servicing that product going forward.  


To learn how to run these scripts from a desktop shortcut, your MAX Control Panel or MAX Tool Menu, and to add password controlled security for the execution of these scripts, see our Process Executor offer.


Need a SQL Procedure or View?

Choose from our library of 65+ existing reports.  See the "Downloads" section below.   If you cannot find what you are looking for, use the "Contact Me" link below for help.

SQL Scripts, MAX ERP, SQL Server, Automation

Utilize Microsoft's SQL Server to automate processes and reporting in your MAX database with our SQL

Downloads

 See our 'Process Executor' page for script execution from the desktop, System Manager Control Panel or Tool Menu. 

Custom SQL Script Listing 2021_ECI (pdf)Download
MAX Convert Configured Order Factsheet (pdf)Download

Copyright © 2020 Micro Manufacturing Systems - All Rights Reserved.

Powered by GoDaddy

  • Contact Me