Dynamics 365 CE Implementation Helps A Waste Management Company Digitally Transform Business Processses

Customer: A successful biosolids and organic waste management companyProfile: The company offers transportation, treatment, site monitoring, land application, and environmental regulatory compliance services, as well as dredging, dewatering, and cleaning services for municipal and industrial lagoons.

Services: D365 CE Implementation

Size: 501-1,000 employees
Region: MD, USA
Industry: Waste Management

Business Need

The biosolids organization was looking to reduce the amount of paper transactions, the associated data entry, and the costs of handling documents. It wanted to place collection and delivery transaction forms in the hands of truck drivers with a digital phone app that replaces paper documents. The client wanted drivers to seamlessly and remotely operate the app online, so they could capture day-to-day transactions and submit images of source documents.

The client wanted to implement the Dynamics 365CE platform as a digital transformation application for its growing business, to enable both business development activities and revenue-generating field transactions. Key requirements included:

  • Implement D365 cloud platform
  • Minimize licensed, out-of-the-box functionality to specified scope
  • Build a role-based app using PowerApps with UX attention on driver usability
  • Integrate D365 with NetSuite
  • Provide administrators with easy to use views and dashboards.

The Biosolids organization was on the lookout for an Technology partner who could deliver an integrated solution that would help gather, store and evaluate the data flowing from current Oracle NetSuite system into D365 CE. The client approached Synoptek for implementing the solution, eliminating manual data entry of tickets, and report generation.

Solution and Approach

Synoptek began the engagement by understanding the client’s existing systems and processes. The client had huge amounts of data on Customers, Projects, Collection Locations, Locations, Billing Item Codes, Expense Codes, Truck Ticket (WO) and more in Oracle NetSuite. To automate this process, Synoptek divided the solution into four parts:

  1. NetSuite to CRM: Initial data was pulled over to CE using KWS SSIS
  2. CRM to PowerApps: Data was pulled in PowerApps with the help of CDS
  3. PowerApps to CRM: Data was again pulled from PowerApps through responsive UI and CDS
  4. CRM to NetSuite: After Work Order creation, data was pushed NetSuite using KWS SSIS

D365CE Field Service Implementation

For the D365CE Field Service Implementation, Synoptek carried out the following activities:

  • Customers – OOB Accounts: Utilized accounts in D365 CE o store customer information from NetSuite.
  • Address – Custom: Stored address information of collection locations with 1 CL- N Address relationship.
  • Product Types – Custom: Created bridge entity Account Product Types to associate collection locations and product types.
  • Project – Custom: Pulled projects from NetSuite which contained detailed information about tasks that need to be done by drivers.
  • Driver Project Assignment – Custom: Created N-N Entity to allow operation managers to assign drivers to projects.
  • Assets – OOB: Stored truck information in Facility/Equipment entity.
  • E Ticket – Custom: Provided facility to field admins to print ticket information – single as well multiple – from the e-ticket itself.
  • Work Order – OOB: Posted Image/Exact replica of the e-ticket which gets integrated to NetSuite.

PowerApp – E Ticketing App

Synoptek created an e-ticketing app for . To fetch/push data to and from D365CE, Synoptek used the premium connector of CDS.

  • Project Screen: Designed a screen where drivers can select State (assigned to them) and based on state selected projects get populated.
  • Pickup Process: Designed tabs where drivers can add data related to Asset, Collection Location, Product.


To bring data from NetSuite and push it back after the Work Order gets created in CE, Synoptek adopted the KWS SSIS tool. Pre-defined saved searches of NetSuite were used to pull data using NetSuite Connector to make smooth integration.

  • Data Pull Packages: Customers, Projects, Collection locations, Addresses, Product types, Destination locations, Destination types, Billing item codes, and expense code information was pulled from NetSuite to CE.
  • Data Push Package: Pushed Work Order information from CE to NetSuite.

Server Deployment

Synoptek made use of Azure blob storage to deploy all integration packages built using KWS.

Business Results

With Synoptek’s services, the waste management company achieved a number of business benefits:

  • Automated key processes and reduced the number of manual transactions.
  • Reduced costs associated with data collection and document management by building a driver-centric app
  • Delivered easy-to-use reports and dashboards that provided timely and accurate insight.


Download Pdf