Take advantage of your investment into MAS 500 by integrating Galaxy APS to handle your planning and scheduling. For true constraint based scheduling for MAS 500, Galaxy APS is in a league of its own. Import Work Orders, Work Centers, and all the information that is so critical to your business and to your bottom line. Below is a list of the required fields that are commonly imported into Galaxy APS. Take your business to the next level!
Compatible Versions of MAS 500
MAS 500(v6.3 and later)
*Earlier versions can be retrofitted
Data Flows
Import data from MAS 500 to Galaxy:
Work Center Groups and Work Centers
Machines, Items and Inventory
Bills of Material
Sales, Purchase and Production Orders
Routing Lines and Production Order Components
Publish Schedule from Galaxy to MAS 500:
Start and End dates at the task level
Reported Quantities
Reported Time
Job Statuses
Field Level Details
Import Fields
Work Orders
| Property | MAS 500Table | Field |
| Work Order | tmfWorkOrdHead_HAI & tmfPlanWOHead_HAI & tmfEstimateHead | ‘WO-‘+ WorkOrderKey & ‘PLN’ PlanWOKey & ‘EST-‘ EstimateKey & ‘Proj’ intJobKey |
| Name | tmfWorkOrdHead_HAI & tmfPlanWOHead_HAI & tmfEstimateHead | ‘WO-‘ + WorkOrderNo & ‘PO-‘ + PlanWOKey & ‘EST-‘ EstimateKey & chrJobNumber |
| Due Date | tmfWorkOrdHead_HAI & tmfPlanWOHead_HAI & tmfEstimateHead | RequiredDate +.5, dteCmpItnDueDate for prjProjects175 |
Routing
| Property | MAS 500Table | Field |
| Work Order Number | tmfWorkOrdHead_HAI & tmfPlanWOHead_HAI & tmfEstimateHead | ‘WO-‘+ WorkOrderKey & ‘PLN’ PlanWOKey & ‘EST-‘ EstimateKey & ‘Proj’ intJobKey |
| Operation Sequence | tmfWorkOrdDetl_HAI, tmfPlanWODetl_HAI, tmfEstimateDetl_HAI, prjLines99125 | WorkOrderStepKey, PlanWOStepKey, EstimateStepKey, intJobLineKey
|
| Required Quantity | tmfWorkOrdHead_HAI & tmfPlanWOHead_ & tmfEstimateHead_HAI | Quantity
|
| Run Time | tmfWorkOrdDetl_HAI, tmfPlanWODetl_HAI, tmfEstimateDetl_HAI, prjLines99125 | numRevisedEstQTY if coming from prjLines99125
|
Bills of Material
| Property | MAS 500Table | Field |
| Work Order Number | tmfWorkOrdHead_HAI & tmfPlanWOHead_HAI & tmfEstimateHead | ‘WO-‘+ WorkOrderKey & ‘PLN’ PlanWOKey & ‘EST-‘ EstimateKey & ‘Proj’ intJobKey |
| Routing Step | tmfWorkOrdDetl_HAI, tmfPlanWODetl_HAI, tmfEstimateDetl_HAI, prjLines99125 | WorkOrderStepKey, PlanWOStepKey, EstimateStepKey, intJobLineKey
|
| Item Number | timItem | ItemKey |
Resources
| Property | MAS 500Table | Field |
| Plant | prjPlants | PlantExternalID |
| Department | tmfWorkCenter_HAI | U_NBS_DeptID |
| Resource Code | prjResources007 | MachineKey & EmployeeKey & ToolKey & intEmployeeKey
|
Capabilities
| Property | MAS 500Table | Field |
| Machine Ability | tmfWorkCenter_HAI | WorkCenterKey |
| Machine Name | tmfWorkCenter_HAI | WorkCenterID |
Purchase Orders
| Property | MAS 500Table | Field |
| Purchase Order Number | tpoPurchOrder & tpoPOLine & tmfMRPDetail_HAI | Pokey +’-‘+ POLinekey &TranID |
| Item Number | tpoPOLine & tmfMRPDetail_Hai | ItemKey |
| Location Code | tpoPOLineDist & tmfMRPDetail_Hai | ShipToWhseKey & WhseKey |
| Quantity Ordered | tpoPOLineDist & tmfMRPDetail_Hai | QtyOrd & TranQty |
| Expected Receipt Date | tpoPOLineDist & tmfMRPDetail_Hai | RequestDate & NetReqDate
|
Publish Fields
| Property | MAS 500Table | Field |
| Work Order | tmfWorkOrdHead_HAI & tmfPlanWOHead_HAI & tmfEstimateHead | ‘WO-‘+ WorkOrderKey & ‘PLN’ PlanWOKey & ‘EST-‘ EstimateKey & ‘Proj’ intJobKey |
| Start Date | tmfWorkOrdDetl_HAI | SchStepStartDate |
| End Date | tmfWorkOrdDetl_HAI | SchStepFinishDate |
Planning Functionality Features
Galaxy has unparalleled planning functionality features. The chart below compares Galaxy with Sage’s product. As you can see, Galaxy packs a powerful one-two punch: rapid implementation combined with unmatched functionality to solve the toughest scheduling challenges.
The following table compares in greater detail the user interface features of Galaxy and Sage.
