Breaking news from around the world
Get the Bing + MSN extension
The views and opinions expressed in this blog are those solely of the author(s) and do not necessarily reflect Microsoft’s current policy, position, or branding. For official announcements and guidance on Dynamics 365 apps and services, please visit the Microsoft Dynamics 365 Blog.
Now Available in Community - MBAS 2019 Presentation Videos
Catch the most popular sessions on demand and learn how Dynamics 365, Power BI, Power Apps, Power Automate, and Excel are powering major transformations around the globe. | View Gallery
2019 release wave 2 Discover the latest updates and new features to Dynamics 365 planned through March 2020
Release overview guides and videos Release Plan | View virtual launch event
Ace your Dynamics 365 deployment with packaged services delivered by expert consultants. | Explore service offerings
Connect with the ISV success team on the latest roadmap, developer tool for AppSource certification, and ISV community engagements | ISV self-service portal
The FastTrack program is designed to help you accelerate your Dynamics 365 deployment with confidence.
FastTrack Program | Finance TechTalks | Customer Engagement TechTalks | Talent TechTalks | Upcoming TechTalks
Dynamics 365 version 9.0.2, Field Service solution version 7.x, PSA solution version 2.x, classic web client, Microsoft Flow
One of the most frequent questions I face when doing Dynamics 365 Field Service presales is “How do we submit time entries?“. OOTB Field Service doesn’t offer Time and Expense Entries the way Dynamics 365 Project Service Automation does. Field Service has Booking Journals, which are based on applied resource booking statuses. While some customers are happy with Booking Journals, many need more versatile Time and Expense Entry functionalities. This is where PSA can help.
The goal in this example is simple: Allow field technicians using Field Service to submit Time Entries for work and other activities related to a Work Order. Field technicians and back office staff shouldn’t have to create new records or spend extra time in Dynamics 365 CE excluding creating, submitting and approving Time Entries.
To achieve the goal, PSA’s Time Entries are leveraged. The process in this example is simple and straightforward: A created Work Order fires off a Flow that creates all the records required for Time Entries. The idea of this blog post is to pitch a no-code solution about what’s possible with PSA and Flow. As every company has different needs for the devil in the details, you can freely take this concept and tweak it to fit your business specific needs.
The process is:
Create Work Order -> Create PSA Order -> Create Project -> Create Project Tasks -> Create PSA Order Line -> Submit Time Entries -> Approve Time Entries.
Invoicing is something this blog post doesn’t cover. There are plenty of variables with Time Entries without speculating on an approach to invoicing. A good point to understand and remember is that where as in Field Service a Closed-Posted Work Order usually creates a Field Service Invoice, in PSA approved Time Entries create Actuals. These Actuals are then invoiced from an Order’s (Project Contract) context and the formed invoice is a PSA Invoice. You can always create a nice document using SSRS reports with data from both Invoices, however if you are integrating Dynamics 365 CE to an ERP, your approach will most likely have to be different.
The images of the Flow’s steps include annotations to point out specific fields that need clarification. As this blog post covers a fairly straightforward approach where only OOTB fields are used, your own Flow may look different. When using Dynamic content, be sure to choose a field’s value from the correct step of your Flow.
The first step is fired off when a Work Order is created. Considerations:
A Project is created after a PSA Order (Project Contract). A field technician will submit Time (and possibly Expense) Entries against a Project. As the Name field equals Work Order Number, it’s easy to distinguish the correct Project for Time Entries. Considerations:
If a Project Template is not used, Project Tasks can be created in this step. In this example I’m creating four tasks which represent different options a field technician can submit Time Entries against. Unique fields on the tasks are Project Task Name and WBS ID. The image at the bottom of this chapter illustrates a WBS with four tasks on PSA V2. Considerations:
The fourth step is to create an Order Line for the Order from step 1. As a Project will be associated with an Order Line, it’s easier to first create an Order, then a Project and leave an Order Line for last. As field technicians are submitting Time Entries for a Project and we may want to invoice those entries, it’s important to set the Billing Method as Time and Material and to set Include Time (as well as Expense) to Yes. Considerations:
The final step is to submit Time Entries either with the Dynamics 365 for phones and tablets app or the Dynamics 365 Field Service Mobile (truck app) which leverages the Resco Woodford solution. The “truck app” is more versatile and is also more straightforward for field technicians as they can use a single app for both Fields Service related work (such as Work Orders) and Time Entries. Before you can use Time Entries on the “truck app” you have to customize your Resco Woodford mobile project and enable Time Entries on it. More information on installing the Field Service Mobile App can be found here.
I hope this post helps you take more out of both Field Service and PSA and gives you ideas on how to leverage PSA’s Time and Expense Entries with Field Service. There are many ways this concept can be taken even further. I challenge you to experiment with Flow! If you want to grab this Flow and edit it for your environment, grab it from the Those Dynamics Guys PowerApps Bank here.
My personal thanks to MVP Elaiza “What The Flow” Benitez for giving me the (All)Spark to this article and Flow!
All my blog posts reflect my personal opinions and findings unless otherwise stated.
Business Applications communities