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 Dynamics 365 for Operations, AX 2012, 2009, 4.0, and can also be retrofitted to earlier versions.
Here are just a few examples of what you can import from 365 for Operations / 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 365 for Operations / 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.)
See Integration Fields
Dynamics Fields:
Plants
D365 Table |
D365 Field |
PT Item/Property |
InventSite |
SiteID |
Plant ID |
InventSite |
Name |
Plant Name |
Departments
D365 Table |
D365 Field |
PT Item/Property |
WrkCtrTableGroupView |
SiteID |
Plant ID |
WrkCtrTableGroupView |
WrkCtrID |
Department ID, Department Name |
WrkCtrTableGroupView |
Name |
Department Description |
Resources
D365 Table |
D365 Field |
PT Item/Property |
WrkCtrResourceAndGroupView |
SiteID |
Plant ID |
WrkCtrResourceAndGroupView |
WrkCtrIDGroup |
Department ID |
WrkCtrResourceAndGroupView |
WrkCtrID |
Resource ID, Resource Name |
WrkCtrResourceAndGroupView |
Name |
Resource Description |
Capabilities
D365 Table |
D365 Field |
PT Item/Property |
WrkCtrResourceAndGroupView |
WrkCtrID |
Capability ID, Capability Name |
WrkCtrResourceAndGroupView |
WrkCtrIDGroup |
Capability ID, Capability Name |
WrkCtrResourceAndGroupView |
Name |
Capability Description |
Capability Assignments
D365 Table |
D365 Field |
PT Item/Property |
WrkCtrResourceAndGroupView |
WrkCtrID |
Capability ID, Resource ID |
WrkCtrResourceAndGroupView |
WrkCtrIDGroup |
Department ID, Capability ID |
WrkCtrResourceAndGroupView |
SiteID |
Plant ID |
Items
D365 Table |
D365 Field |
PT Item/Property |
InventTable |
ItemID |
Item ID, Item Name |
InventTable |
NameAlias |
Item Description |
Warehouses
D365 Table |
D365 Field |
PT Item/Property |
InventLocation |
InventSiteID |
Plant ID |
InventLocation |
InventLocationID |
Warehouse ID, Warehouse Name |
InventLocation |
Name |
Warehouse Description |
Plant Warehouses
D365 Table |
D365 Field |
PT Item/Property |
InventLocation |
InventSiteID |
Plant ID |
InventLocation |
InventLocationID |
Warehouse ID |
Inventories
D365 Table |
D365 Field |
PT Item/Property |
InventSum |
ItemID |
Item ID |
InventSum |
PhysicalInvent |
Qty On Hand |
InventSum |
InventDimID |
|
InventDim |
InventLocationID |
Warehouse ID |
InventDim |
InventDimID |
|
Sales Orders
D365 Table |
D365 Field |
PT Item/Property |
SalesTable |
SalesStatus |
|
SalesTable |
SalesID |
SO ID |
SalesTable |
SalesName |
SO Name |
SalesTable |
DeliveryDate |
SO Delivery Date |
SalesTable |
CustAccount |
Customer |
Sales Order Distibutions
D365 Table |
D365 Field |
PT Item/Property |
SalesLine |
SalesID |
SO ID |
SalesLine |
LineNum |
SO Line |
SalesLine |
ItemID |
SO Item ID |
SalesLine |
Name |
SO Line Desc |
SalesLine |
RemainInventPhysical |
Delivery Quantity |
SalesLine |
ConfirmedDlv |
Delivery Date |
SalesLine |
QtyOrdered |
Order Quantity |
SalesLine |
InventDimID |
|
Purchase Orders
D365 Table |
D365 Field |
PT Item/Property |
PurchTable |
PurchID |
PO ID |
PurchTable |
PurchName |
PO Name |
PurchTable |
PurchStatus |
PO Status |
PurchLine |
LineNumber |
PO ID |
PurchLine |
ItemID |
Item ID |
PurchLine |
DeliveryDate |
Scheduled Delivery Date |
PurchLine |
Name |
Item Name |
PurchLine |
QtyOrdered |
Order Quantity |
PurchLine |
PurchQty |
|
PurchLine |
Complete |
|
PurchLine |
Purch ID |
|
PurchLine |
InventDimID |
|
Production Orders
D365 Table |
D365 Field |
PT Item/Property |
ProdRoute |
ProdID |
|
ProdRouteJob |
ProdID |
|
ProdTable |
ItemID |
Product ID |
ProdTable |
InventDimID |
|
ProdTable |
ProdStatus |
|
ProdTable |
ProdID |
Job ID |
ProdTable |
ProdPrio |
Priority |
ProdTable |
DlvDate |
Need Date |
ProdTable |
Name |
Job Desc |
ProdTable |
QtySched |
Required Quantity |
ProdTable |
RouteJobs |
|
InventDim |
BOMUnitID |
UoM |
Process Operations
D365 Table |
D365 Field |
PT Item/Property |
ProdRoute |
ProdID |
Job ID |
ProdRoute |
OprNum |
Op ID |
ProdRoute |
ProcessTime |
Run Rate |
ProdRoute |
ProcessPerQty |
Run Rate |
ProdRouteJob |
OprNum |
Op ID |
ProdRouteJob |
CalcTimeHours |
Cycle Hours |
ProdRouteJob |
WrkCtrID |
|
ProdRouteJob |
JobType |
|
ProdRouteJob |
FromDate |
Anchor Flag, Anchor DateTime |
ProdRouteJob |
FromTime |
Anchor Flag, Anchor DateTime |
ProdRouteJob |
ToDate |
|
ProdRouteJob |
ToTime |
|
ProdRoute |
ProdID |
Job ID |
ProdRoute |
OprNum |
Op ID |
ProdRoute |
ProcessTime |
Cycle Hours |
ProdRoute |
ProcessPerQty |
Qty Per Cycle |
ProdRoute |
RouteGroupID |
Description |
ProdRoute |
WrkCtrIDCost |
Resource ID |
ProdRoute |
JobPayType |
Job Type |
Operation Reported Activity
D365 Table |
D365 Field |
PT Item/Property |
ProdJournalRoute |
ProdID |
Job ID |
ProdJournalRoute |
OprNum |
Op ID |
ProdJournalRoute |
QtyGood |
Reported Good Quantity |
BOM
D365 Table |
D365 Field |
PT Item/Property |
ProdBOM |
ProdID |
Job ID |
ProdBOM |
OprNum |
Op ID |
ProdBOM |
ItemID |
Item ID |
ProdBOM |
BOMQty |
Total Qty Required (scaled) |
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] |