Integrating with Microsoft Dynamics AX

AX is one of our specialties and we can tailor a solution specific to what’s important to your company.

Compatible Versions
PlanetTogether APS is pre-integrated with AX 2012, 2009, 4.0, and can also be retrofitted to earlier versions.

PlanetTogether APS and Microsoft Dynamics AX Integration

 

 

PlanetTogether APS Launching within Microsoft Dynamics AX

 

 

 

Here are just a few examples of what you can import from Dynamics AX:

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

PlanetTogether also allows you to publish schedules back to AX:

  • Publish scheduled start and end datetime on production orders. Specifically, fields Schedend and Schedstart on ProdTable table
  • Publish scheduled start and end datetime on production order jobs. Fields from date, fromtime, todate and totime in table prodroutejob
  • Optionally publish Costed Resource
  • Optionally publish Production Quantities
  • Optionally publish the Production Status
  • Publishing works via SQL stored procedures or AX .Net connector. (Please note: If using the AX .Net connector, a Microsoft AX Device CAL and a Menu Item CAL are required.)

 

Dynamics AX Fields:

Production Orders

Property AX Table Field
Production Order Number PRODTABLE PRODID
Item PRODTABLE ITEMID
Priority PRODTABLE PRODPRIO
Delivery Date PRODTABLE DLVDATE
Description PRODTABLE NAME

 

Routing

Property AX Table Field
Production Order Number PRODTABLE PRODID
Operation Sequence PRODROUTEJOB OPRNUM
Required Quantity PRODTABLE QTYSCHED

 

Bills of Material

Property AX Table Field
Production Order Number ProdBOM PRODID
Routing Line PRODROUTEJOB OPRNUM
Item Name ProdBOM ITEMID

 

Resources

Property AX Table Field
Plant Name [Hardcoded] [Plant]
Workcenter WRKCTRTABLE WRKCTRGROUPID
Machine WRKCTRTABLE WRKCTRID

 

Capabilities

Property AX Table Field
Machine Abilities WRKCTRPROPERTY PROPERTYID
Name WRKCTRPROPERTY NAME

 

Sales Orders

Property AX Table Field
Sales Order Number SalesLine SALESID
Line Number SalesLine LINENUM
Source Warehouse [Hardcoded] [Hardcoded]
Quantity Ordered SalesLine QTYORDERED
Delivery Date SalesTable DELIVERYDATE

 

Publish Fields

Property AX Table Field
Production Number ProdTable PRODID
Start Date ProdROUTE [fromdate]
Start Time ProdROUTE [fromtime]
End Date ProdROUTE [todate]
End Time ProdROUTE [totime]