Integrating with Sage MAS 90/200

Take advantage of your investment into Sage 100/Advanced (formerly MAS 90/200) by integrating PlanetTogether APS to handle your planning and scheduling. For true constraint based scheduling for Sage, PlanetTogether is in a league of its own. Import Work Orders, Purchase 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 fields that are commonly imported into PlanetTogether. These imports are simple SQL queries that can be easily installed and fully customized by PlanetTogether staff or your IT experts.

You can publish plans and schedules to Microsoft SQL Server for sharing. You can also publish schedule dates back to Sage using a program developed and sold by our partner, Blytheco .

Compatible Versions
Here are just a few examples of what you can import from MAS 90/200:

  • Work Center Groups and Work Centers
  • Machines, Items, and Inventory
  • Bill of Material
  • Sales, Purchase, and Production Orders
  • Routing Lines and Production Order Components

PlanetTogether also allows you to publish schedules back to MAS 90/200:

  • Start and End dates at the task level
  • Reported Quantities
  • Reported Time
  • Job Statuses

MAS 90/200 Fields:

Work Orders

Property Sage Table Field
Work Order WorkorderMaster WorkOrder
Quantity Planned WorkorderMaster QtyPlanned
Due Date Workordermaster WODueDate



Property Sage Table Field
Work Order Number WorkorderMaster WorkOrder
Operation Sequence WorkOrderOperationDetail StepNumber



Required Quantity WorkorderMaster QtyPlanned
Run Time WorkOrderOperationDetail StdRunTime


Bills of Material

Property Sage Table Field
Work Order Number WorkorderMaster WorkOrder
Routing Step WorkOrderOperationDetail StepNumber
Item Number Item ItemCode



Property Sage Table Field
Plant N/A [Hardcoded]
Department ToolingMaster & ProductionEmployee Master WorkCenterCode
Resource Code WorkCenterMaster WorkCenterCode



Property Sage Table Field
Machine Ability WorkCenterMaster ‘MACHINE-‘ +WorkCenterCode
Machine Name WorkCenterMaster ‘MACHINE-‘ +Description
Labor Ability WorkCenterMaster ‘LABOR-‘ +WorkCentercode


Purchase Orders

Property Sage Table Field
Purchase Order Number PurchaseOrderEntryHeader PurchaseOrderNumber
Item Number PurchaseOrderEntryLine ItemNumber
Location Code N/A [Hardcoded]
Quantity Ordered PurchaseOrderEntryLine QtyOrdered – QtyReceived
Expected Receipt Date PurchaseOrderEntryLine RequiredDate