Integrating with Microsoft GP

Microsoft Dynamics GP is an excellent solution for mid-sized companies and one of PlanetTogether APS’ specialties. We integrate not only to GP, but also GP Manufacturing Module by augmenting the ERP with state of the art planning and scheduling system, capable of handling manufacturers across any industry. Imagine the places that PlanetTogether can take your production scheduling with a seamless integration into GP.

Compatible Versions
PlanetTogether APS is compatible with GP v2010, v10.0, v9.0, and can also be retrofitted to earlier versions.

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

  • 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 GP:

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

GP Fields:

Work Orders

Property GP Table Field
Work Order Number WO010032 MANFACTUREORDER_I
Item Number WO010032 ITEMNMBR
Required Finish Quantity WO010032 ENDQTY_I
Start Date WO010032 STRTDATE
End Date WO010032 ENDDATE

 

Routing

Property GP Table Field
Work Order Number WO010032 MANFACTUREORDER_I
Operation Sequence WR010130 RTSEQNUM_I
Required Quantity WO010032 ENDQTY_I

 

Bills of Material

Property GP Table Field
Work Order Number WO10032 MANUFACTUREORDER_I
Routing Step WR010130 RTSEQNUM_I
Item Number MOP1000 ITEMNMBR

 

Resources

Property GP Table Field
Machine Name WC010200 MACHINE_ID
EmployeeName WC010100 EMPOLYID
Work Center WC010200 WCID_I

 

Capabilities

Property GP Table Field
Machine Ability WC010015 WCID_I
Machine Name WC010015 WCID_I

 

Purchase Orders

Property GP Table Field
Purchase Order Number POP10110 PONUMBER+’-‘+LineNumber
Item Number POP10110 ITEMNMBR
Location Code POP10110 LOCNCODE
Quantity Ordered POP10110 QTYORDER – QTYCANCEL
Expected Delivery Date POP10110 PRMDATE

 

Publish Fields

Property GP Table Field
Work Order WO010032 MANUFACTUREORDER_I
Start Date WO010032 STRTDATE
Need By Date WO010032 ENDDATE