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] |