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 |
Routing
| 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 |
Resources
| Property | Sage Table | Field |
| Plant | N/A | [Hardcoded] |
| Department | ToolingMaster & ProductionEmployee Master | WorkCenterCode |
| Resource Code | WorkCenterMaster | WorkCenterCode |
Capabilities
| 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 |