Dynamics 365 Finance Tip: Did you know you can now apply cash advances to individual expense report lines?

Dynamics 365 Finance Tip: Did you know you can now apply cash advances to individual expense report lines?

Here is a quick tip on a new feature in the Expense Management module of Dynamics 365 Finance introduced in version 10.0.17.

If you give cash advances to your employees for expenses they might incur(Office or travel related expenses), they now have better control over applying specific cash advances(s) against each line of their expense reports.

Before the 10.0.17 release, cash advance application/reconciliation was automatically controlled by the system and the balance was tracked behind the scenes. This worked, but was lacking control and traceability/troubleshooting as such.

With this new feature, employees can submit cash advance requests using the Cash advance feature. Once the request is approved and paid, they become available for application/reconciliation against specific expense report lines.

When you go to enter your expense report, you will see the option to select one or more cash advances against the expense repot line. The system will automatically bring in unapplied cash advances on the screen.

Till the next one..

Unify your Project centric business with Dynamics 365 Project Operations – Best of all Microsoft applications in one package for project based organizations

Unify your Project centric business with Dynamics 365 Project Operations – Best of all Microsoft applications in one package for project based organizations

In an earlier post, I wrote about overview of the new Dynamics 365 Project Operations solution from Microsoft and the 3 different deployment modes available for customers today. I was finally able to free up some time to deploy the new general available build of Project Operations. I deployed the fully integrated mode for resource/non-stocked scenarios.

In this blog post, I wanted to dive into other “Fully integrated D365 Project operations with financials for resource/non-stocked scenarios” and showcase the key capabilities. This deployment scenario is suitable for project based organizations who does not have stocked inventory material and production requirements. The support for non-stocked materials is coming soon on the deployment mode.

In this post, we will focus on reviewing the end to end lifecycle of a project from lead to invoicing. The objective is not to go granular on each of the functionalities, but rather to review all functionalities you can use from at each stage. We will review specific features in future posts and deep dive into those.

The infographic below shows the overall capabilities of Dynamics 365 Project Operations.

Deal management experience (Lead > Opportunity > Quote > Contract):

D365 Project Operations provides comprehensive Lead, Opportunity and Quote management features suitable for project based firms. It leverages the best of the industry leading D365 Sales solution in the Customer Engagement platform and lights up the experience right within the Project Operations app.

You can track all required Lead information and once you quality the Work based lead, an Opportunity record is automatically created, where you can add the building block of the work.

In the Resource/Non-stocked based scenarios deployment of Project Operations, you can only add Project based lines right now, but the support for service based items/products is coming soon. (Note: If you have the Lite deployment of Project Operations with no Finance integration, you can still add product based lines, just like you did in the old D365 PSA app).

You can assign a price list/rate card for the opportunity and you can now build the line items on the Opportunity and specify the details such as Billing method, amount, customer’s budget and so on.

Once the Opportunity details are fine tuned with the customer, you can build a proposal/quote directly from the Opportunity and all the line item details are carried over automatically. The Quote lines represent the discrete components of the work that you will present on the quote to the customers.

The Quote line details is where you identify and estimate the details of each quote line/work component such as, schedule, financials, contracting model and so on. This information on the quote line details helps you do profitability analysis on the quote.

If the Project is funded by more than one entities of the customer, you can add the customers/funding sources on the quote line and designate the amount/percent split of the amount for billing and you can also specify the “Not-to-exceed” limit for each customer. This reminds of the Funding sources, funding limits and funding rules functionality that we all know in the classic Project accounting module of D365 Finance 🙂

If the quote line is a Time & Material line, you can specify additional details such as “Chargeable Roles”, “Chargeable Categories”.

You can also create the project to create the ground up estimates from the project tasks/plan and import those into the quote lines. After you have built the quote details, you can review profitability analysis info.

You can also how your quote compares to the customer’s expectations.

When you have won the quote, you can associate the Project ID to the quote/opportunity line and close the Quote as Won. As soon as a Quote is closed as Won, a Project contract is automatically created in Draft status and new project is associated with this contract.

Project and Resource management experience:

Project managers can create detailed project WBS/plan using the capabilities of Project for the web(P4W) capabilities built right into project operations. I am not going to focus on discussing details of the individual functionalities around project management and resource management aspects in this post. We will save that for another post.

Time & Expense management experience:

Your resources can use the intuitive time entry UI to keep track of their daily time and submit periodically/weekly. You can also keep track of employee expenses with the robust expense management module of Project operations, with features such as expense policies, workflows and credit card integration. The expense management experience comes from the proven D365 Finance app and offers advanced expense management capabilities. They can also use the T&E mobile apps.

Managers can review timesheets and expenses in the Approvals work bench and process them in timely manner.

Project transaction corrections and Invoicing

Project finance/billing team can stay on top of their tasks with intuitive interfaces for transactions corrections/adjustments to make sure any adjustments to transactions are processed prior to billing.

The dedicated work benches for Time & Material, Fixed price milestone and advance & retainers billing backlogs are handy providing all the billing backlog information at one place . You can review details such as invoice status, Not to exceed limits and statuses of each transaction to make sure the customer invoices are accurate.

Creating invoices for project contracts is simple. It can be created manually for each contract or an automated batch job can be setup to run on automatic recurrence.

As soon as you confirm the Draft/Proforma invoice, a project invoice proposal is created, which is then ready to be posted. With the industry leading sales tax engine of D365 Finance solution, you don’t have to worry about complexities of sales tax calculations.

Project Operations also provides functionality for advances and retainers billing to customers. This is a new feature that was released in version 4.5.0.134. This feature reminds me the good old customer advance functionality we have in the legacy project management and accounting module in D365 Finance.

Additional you can also setup an automatic retainer schedule to bill customers automatically based on a pre-defined schedule and invoice frequency. You can reconcile actuals against billed retainers and advances.

Revenue recognition, sales tax and financials management:

With the ” Fully integrated Resource/non-stocked scenario/deployment mode, you have full coverage of Revenue recognition, sales tax management and comprehensive industry leading project accounting and financials management. This part of the solution is built on the powerful Project management and accounting solution we all are familiar with in D365 F&O. The module is tailored and modified to work with the overall project operations solution. I am working on a separate blog post to explain the details of how the PMA module of D365 Finance is tailored to work with the Project operations solution. I will explain the key changes and how it works in that post.

That was a happy path blog post on Dynamics 365 Project Operations. This was my second post on the official D365 Project Operations solution on my blog and the idea was to showcase what the solution can do for project based organizations. I am pretty excited about how the different industry leading applications from Microsoft for the project based organizations (Dynamics 365 PSA, Dynamics 365 Finance, Project for the Web) came together powered by Microsoft Dataverse(CDS), providing a seamless application for project based organizations of all sizes

That’s it for this post! We will discuss specific topics on Project operations in future posts very soon.

Azure Data Lake(Gen2) integration with Dynamics 365 for Finance and Operations

Azure Data Lake(Gen2) integration with Dynamics 365 for Finance and Operations

Business Intelligence and Reporting has evolved in Dynamics 365 Finance and Operations since it’s launch. Entity store is the default relational database for dynamics 365 for finance and operations containing several aggregate measures and customers rely on it for near real time dashboarding on data from the Production database of D365 F&O. Entity store DB is included in the D365 F&O subscription and Microsoft ships quite a few embedded Power BI content packs that does direct query into the entity store to produce stunning dashboards and reports across various modules.

It is also possible to make the entity store available in Azure Data Lake (Gen2). This gives flexibility for customers to have the aggregate measures of entity store directly in their Azure data lake and allows them to do reporting and dashboarding by mashing up data from external sources also.

Another popular option used by many customers is BYOD. Customers can export out of the standard data entities and custom data entities and export them in a predefined schedule to their own Azure SQL DB and then use Power BI or other tools to create reports and dashboards and mash-up the data with external systems data as well if needed. While BYOD offers a good solution for reporting and dashboarding by mashing up data from systems other than just D365, F&O, it comes with it’s own limitations and often requires you to manage and maintain the recurring data exports. The Azure SQL storage is also comes at a cost, depending on what volume of data you want to export and store.

With the version 10.0.12 launch, Microsoft is now making it possible to replicate you D365 F&O production data into Azure Data Lake (Gen2) storage. This new feature and framework allows you chose the data tables and entities you want to export and will keep the F&O data up to date in Azure Data Lake in almost real time.

After you setup your Azure data lake storage account, application ID and authorization for D365 F&O to access the storage account you will first need to install the add-in within Lifecycle services(LCS). Then you can enable the new feature within the feature management area of D365 F&O and perform the remainder of the setup.

Why you should plan the transition to Azure Data Lake: In my view, customers who are invested in BYOD or the analytical workspaces of D365 F&O entity store today should look at taking advantage of Azure Data Lake and should plan the transition for the following reasons.

  1. BYOD requires continuous monitoring and troubleshooting. ADL maintains the data automatically and is always up to date with no intervention needed.
  2. You don’t need to create data entities to expose data in any table that you want. You can literally expose all data tables and fields with ADL integration.
  3. Azure SQL data storage is comparatively expensive than ADL.
  4. ADL cloud storage is more efficient, better for analytics and provides additional capabilities such as AI, and additional programming to transform large volume of data.
  5. Data lakes in Azure are designed for big data and analytics and are capable of handeling big amount of data with less cost. It takes advantage of Azure blob storage behind the scenes.
  6. Data lakes not only allows you to do analytics on the data using Power BI, but also it allows you do additional things like apply machine learning, AI on the data to learn and take meaning and action out of your big data.

That’s it for today’s post.

Useful new features under Project accounting module of Dynamics 365 Finance that you must checkout

Useful new features under Project accounting module of Dynamics 365 Finance that you must checkout

Hope everyone out there is keeping safe and healthy. We are living in unprecedented times and navigating this phase of the our lives certainly has been teaching us new thing every day!

I finally took some time out from the schedule to review some of the new features under Project Accounting module in the most recent releases of Dynamics 365 Finance. These features range from version 10.0.9 through 10.0.12. Let’s get to the point and review the features.

Show Vendor ID and vendor name on the Posted projects list page:

So this one is probably one of the most common asks I have heard from customers in all projects. Seeing the vendor name and account number certainly makes the life of the project accountants and billing analysts easier. We have been addressing this using a customization till now. These 2 additional data fields will make it easy for users to slice and dice project expenses by vendor and produce invoice supporting documents for customers when billing those expenses.

When you enable this feature and post a vendor invoice to the project, you will see the Vendor ID and name on the posted transactions list page.

You can also Personalize to the the Vendor ID and name fields to the Expense transactions inquiry page.

Adjust accounting on a posted project transaction:

This one is very interesting. Before this functionality, the only option to adjust accounting was to process a transaction adjustment. But that also required you to change data on the subledger transaction.

With this new feature, accountign team will find it easier to adjust accoutning posting for posted transactions.

It will basically reserve the original posting and recreate new ones.

For example, I have an expense transaction posted on one of my T&M projects. Let us say it posted to the wrong main account 500130 and wrong Business Unit dimension “004. I want it to post to 500120 and business unit 003.

Select the Posted project transaction and click Adjust accounting under Process tab.

System will open up a dialog that will allow you to see the current accounting entry and will also let you select the new account and dimensions.

You can also preview the new voucher to make sure everything is correct.

When you post this adjustment, it will reverse the original voucher and create the new one. Pretty cool and damn good flexibility!!

Note: I believe there might be a known issue here with the voucher, but when it is fixed, this feature is going to be extremely useful.

Enable default accounting setup for project:

This is again one of the most common asks from customers. We have actually customized the Projects and contract screen on many instances to view the financial dimensions and other associated data such as Project manager, Sales manager, Sales tax group and so on. With this new feature, you will see a new button named “Show default accounting” on the Projects and Project contracts list page.

You can not only see the data, but you can edit then directly on the list pages under the fact boxes. Really neat!

Enable project invoice proposal creation specific to selected project:

This one is small yet useful feature. Prior to this feature, when you have a Project setup heirarchy where there is a parent project and a bunch of sub projects underneath, then when you create the invoice for a sub project, system will always default to the parent project and try to create the invoice at the parent level.

With this new feature enabled, you can create the invoices at each sub project levels directly.

Enable sorting by resource during project invoice proposal creation:

When Billing analysts or finance managers create invoices for projects (Especially for Time and Material Projects), it is often desired to be able to sort the invoice line items by Resource, so that they can easily create the invoice. This is small usability enhancement, but has significant positive impact on the end users.

Below screenshot shows the Resource column on the Create invoice proposal screen without this new feature.

Below screenshot shows the Resource column on the Create invoice proposal screen with the new feature.

Project contract committed amount detail:

This has been released for a few months now, but I see a lot of value in this little feature. Under the Funding limit area of a project contract, there is no details available for any amount that is shown under the Committed or Spent amount columns. Being able to see the details under these will surely save significant amount of time for end users. I wish Microsoft will add the same functionality to see “Spent details” under the funding limits soon. (Candidate for an Idea in Ideas portal!!!)

There are a few more new country/region specific features available. You might want to check those out if applicable to you.

Till then….

Get your users from just using Dynamics 365 to Loving Dynamics 365 for Finance and Supply Chain Management

Get your users from just using Dynamics 365 to Loving Dynamics 365 for Finance and Supply Chain Management

As end users of any product, software application or any other app, we all love to spend less time in the system and get more done with less effort. Also we all love if the system gives us the flexibility to personalize the way we want it. Using an ERP systems should not be is no different. Dynamics 365 for Finance and Supply Chain Management has been on a journey to release new features every month. The goal is very simple. Drive the user base from just using Dynamics 365 to Loving Dynamics 365.

With the newest version 10.0.9 that is coming out in a couple of weeks, there are some new cool productivity features that every user of Dynamics 365 should take advantage of. Here are some of my favorite ones.

Saved Views:

We all love the Personalization feature of D365 F&O, which allowed us to add/remove fields, rearrange data fields and more. One of the primary limitation of the personalization feature was “Only one set of personalization was allowed on a view/form and you could never have more than one personalized views of the same page/form. Saved Views feature addresses that in the 10.0.9 release.

With Saved views, you can create your own personalized view with data fields added/removed or even with data filtered and save the view. You can switch to the custom view or the standard views any time based on what you want to see. An example of this is “Let’s say on the All Projects page, I want to see all closed projects of a customer (City manufacturing). I also want to see the “Project manage” column when I am in this view. I want another view to see all projects that are in Process for them and I want to see the Project group column in this view instead of the project manager. With the earlier personalization feature, you always had to filter the data and it was not possible to chose different columns to see depending on the view you are seeing. With Saved views, this is a breeze and will help user productivity significantly.

Additionally you can pin a saved view as your default view and you can also publish your saved views and let others take advantage of it. You can rename your views at any time.

Groupings and show totals of data in grids:

Imagine how nice it will be if you can group, sort and see data sliced and diced without having to export them to Microsoft Excel!! With the new grouping feature, you can now group data by literally any data column and even see totals of amounts for the grouped data. You don’t have to export the data to excel. This feature is not replacing Export to excel by any means 🙂 You can obviously do much more with slicing and dicing when you export data to excel, but if you were looking for basic grouping and view totals, then you an now do it right within the client.

For example I am a project controller and I am reviewing all the posted transactions on the Posted project transaction page and i want to see the amounts grouped by Category or grouped by date. I can just right click on a column and select group by. I can also chose to see then totals of the amounts at the bottom.

Run/View 3rd party Websites under a fast tab within D365 F&O:

In the earlier versions, there was the capability to add PowerApp to run in a n embedded view within D365 F&O. You can now add any website to run embedded within a fast tab of any page in D365 F&O. This is a very helpful additional. Think of a scenario where you have a home grown website/web app and you want to run it within F&O, so that you don’t have to leave the F&O page to run the app.

A sample use case of this will be adding vendor’s websites to the vendor records within F&O. When you are on a vendor record in D365 F&O, you can go to the site within the fast tab of the vendor record.

You also have any inhouse websites/webapps running within the fast tab.

Quick Personalization and faster data load on grids:

Rearranging data fields within a page does not require to go to Personalization mode now. You can just drag and drop fields on any page and arrange them in the order you want. This can be a part of your saved views as well.

The data filtering on the new grid control now got even better. Earlier if you were to filter certain records on a page using the “Is one of” option, it was very difficult and time consuming to type every single value, one at a time. With the new improved control, the “Is one of” control works like a charm. You actually get to see the values in the drop down and you can select them with just a click. That’s it!!

The new improved grid also provides key enhancements such as,

  • Improved data rendering speed and faster scrolling experiencing.
  • You can do positional scrolling. So if you are looking at a page that has thousands of records, then you can scroll to specific position on the scrollbar to go to the specific records.
  • Enter mathematical expressions on numerical columns for the system to recognize values. For example I am on the Project Hours forecast screen and on the Hours field, I can type = 5*45, instead of 225.
  • Faster data entry, as server side data validation allows user to enter data first and then the system validates data.

Thats it for this post.!!

Some new improved features in Project accounting module in Dynamics 365 for Finance and Operations

Some new improved features in Project accounting module in Dynamics 365 for Finance and Operations

Here are few tips on some of the small improvements in functionalities under the Project accounting module in D365 F&O.

Prevent project closure if open transactions exists: This is one of the most common requirements to make sure the Project is not closed out if there are pending transactions such as time, expense or invoices that are created but not yet posted to the project.

With this parameter marked, if a user tries to change the stage of a project to Closed/Finished, system will automatically detect if there any pending transactions and if there are, then it will not the user set the stage to Closed/Finished.

Advanced resource validation filtering enabled: This is a small enhancement that now allows you to filter employees based on their employment status. When enabled, you will see a new option to select the Employment status. This will make it easy to manage resource validations on projects when employees are terminated or when new employees come in with start date in the near future.

Allow sales orders for projects with multiple funding sources: When you have more than one funding source setup under a project contract, the system never allowed to create a sales order for the projects under that project contract. This has been one of the most important limitations of the system for a long time.

It is a very common requirement to have contracts funded by more than one funding sources/parties and if these contracts requires you to create sales orders, then it was not possible earlier. System would prompt with an error message as shown below.

With this new parameter marked, system will now allow you to create sales orders for projects which are setup with multiple funding sources. When you Mark this parameter, you will be able to chose whether you want the customer to be defaulted from the funding source or from the project.

The funding source which you select when creating the Sales order will be used when you invoice the sales order on the T&M project.

Allow batch process for publishing of Project WBS: When you have a Proejct work breakdown structure that is large and complex, having the option to publish the project WBS in batch (In the background) can come in very handy. This is a welcome change and improvement.

Automatically set accounting date to open ledger period for project journals: When a general ledger financial period is closed for transactions entry/posting, it is usually a requirement to allow the posting of the transactions automatically to the next open general ledger period. In earlier releases you could setup required parameters under Projects and Expenses module to post expense reports and project time sheets to post automatically to the next open GL period, if the fiscal period for the current transaction date is closed for entry.

With this new parameter, you can do the same thing for project journals. So for example you are trying to post a project journals into a GL period that is closed for entry/posting, then system can automatically post to the next open period.

For example, I have closed August 2019 for the Project module.

.

If the parameter is not marked, then you will get an error message as shown in screen below and the journal won’t post.

With the new parameter marked, I now try to post a project hours journal for the month of August. When this is posted, you can see the GL voucher is posted to September 1st (Next open GL period) automatically .

That’s it for this quick post!!

Regards, Sandeep


Common Data Service for Apps, Dynamics 365 for Talent and Dynamics 365 for Finance & Operations, The integration story with the new Power platform from Microsoft

Check out my new blog post on Common Data Service, Microsoft Power Platform and the out of the box integration between Dynamics 365 For Talent and Finance & Operations.

https://dynamics365.wordpress.com/2019/02/06/common-data-service-for-apps-dynamics-365-for-talent-and-dynamics-365-for-finance-operations-the-integration-story-with-the-new-power-platform-from-microsoft/

Common Data Service for Apps, Dynamics 365 for Talent and Dynamics 365 for Finance & Operations, The integration story with the new Power platform from Microsoft

Check out my new blog post on the Power platform and the integration of D365 For Talent and Finance & Operations using Common Data Service.

Dynamics 365, Power Platform & Dataverse

In one of my earlier posts, I discussed briefly about the testing I did for the first version of Common Data Service to integrate Dynamics 365 for Sales and Finance & Operations. That was primarily for syncing customer accounts and all associated information. Microsoft also ships several data integration templates out of the box for this, which covers pretty much all key entities in the Prospect to Cash scenario.

Today, we will take another deeper look at the Dynamics 365 integration story using the overall Power platform which contains the power of Common Data Service(CDS 2.0), Microsoft Power Apps, Flow and Power BI. We will learn about the new version of Common Data Service, which is referred to as CDS for Apps (CDS 2.0) and we will test an integration between Dynamics 365 For Talent and Dynamics 365 for Finance and Operations.

Create the Power platform environment (CDS For Apps…

View original post 1,063 more words

Some useful new features of Dynamics 365 for Finance and Operations version 8.1 under Core Financials management module – Part 1

Some useful new features of Dynamics 365 for Finance and Operations version 8.1 under Core Financials management module – Part 1

The October 2018 release of Dynamics 365 for Finance and Operations (Version 8.1) introduced several new and very useful features in the core financials management area of the application, along with several other new functionality and enhancements across various other modules, analytics, overall platform, extensibility and more.

In this blog post, we will review some of the key new features under the core financials area, which a lot of end users will certainly fall in love with.

Central view of Settlement Transactions: In the past, when you had to see the settlements on a customer or vendor transaction, you always had to make a few clicks and jump to more than one screen to find the relevant information, which was time consuming. With the new “View Settlement” form/option on the Customer and Vendor transactions form, you can now see the full settlement details, related transactions, accounting, history and more, all at one place. Here is an example.

A customer invoice is posted: The View settlements form shows just the required details of the invoice.

cust trans8.1
view settlements

Let us now settle this invoice against a customer payment along with some cash discount. Here is what you see in the view settlement form.

view settleemnts after settlement

On this new “View Settlements” form, you can,

  • View any related transaction lines for the invoice, payment, cash discount lines etc.
  • You can dig into the Settlement history, if there a transaction was settles, unsettled multiple times.
  • You can view the accounting entries directly from this screen, for each individual line.
  • You can also initiate the Undo Settlement process from this new form.
options on view settlements

Customer and Vendor data field change approvals: On the Customer and Vendor master records, if you want approval process to be in place, when certain data fields are changed on the customer or vendor records, you can now enable that functionality optionally. This is a pretty neat feature, which let’s you chose which data fields you want to control from being changed accidentally, and then configure a detailed one or multi step approval process, so that the changes can be reviewed and approved, before the new field value comes into effect for the customer or vendor. In the post today, we will see this on the Customer side, but it is the same functionality on the vendor side as well.

So the first step is to Enable the approval process. As i mentioned, this is completely optional and if you do not need, you just leave the feature turned OFF. To enable this, go to Accounts Receivable > Setup > AR Parameters form and mark the “Enable customer approval” check box under the General tab.

Enable Customer fields approval

The next step is to actually configure the approval workflow, which will be used for routing the proposed customer account changes for review and approval. This workflow is similar to other workflows in the system. In my case, i have setup a basic workflow with just one step approval process.

Once you have the workflow configured, let us now see this functionality in action. Navigate to the customer master and you will notice that the data fields you selected in the parameter screen , will now show as “requires approval” indicator. This is super helpful and easily tells the user that this field if changes will require approval. Let’s try to change the customer credit limit and customer group field.

Let’s try to change the customer credit limit and customer group field. When you save the changes, system will create and show the change proposal, which shows both current values and the proposed changed. At this point, the user if wishes, can discard the changes they made.

Notice now that the status of the Customer account says “Changes not submitted”.

One important thing to note here is, when the changes to the data fields are in process, you can still transact with the customer. System will just use the current values.

Once you are done with the changes, click Workflow > Submit to submit the changes to the workflow for review and approval. When the changes gets assigned to the approver, they can view the Proposed changes on the customer record directly.

Important note: There is a periodic option to submit all changes created for customer accounts in bulk. You can do it both manually and in the background/batch.

The changes to the data fields will come into effect after the change proposal has been approved. It works the same way for vendor records as well.

Financial Dimension values on Derived Dimensions: In many of the implementations I have done, a common requirement we here is to have some of the master records such as Item, Project, Customer etc. to be configured as one of the financial dimensions, so that customers can do adequate financial reporting on those. We use Derived dimension values for this and often end up having to select the financial dimension value manually on the master data record or we end up doing additional customization to automatically populate this value when new records are created in the master data table.

With this new functionality, you do not need to do any customization or even setup the dimension value manually when new records are created. If enabled, the system will automatically set these up now. Let us see this in action.

Additionally, there is another new functionality available on the financial dimensions area, where you can now setup certain dimension values to be defaulted when you select another dimension value. For example, when you select a specific business unit, you can have the system automatically default a cost center value for you.

To set this up, go under Financial dimensions > Select the dimension record and click Derived dimensions button. Here you can setup the value combinations of the defaulting of dimensions.

In this case, i have setup to default Cost center and Department values to be defaulted when i select a certain business unit.”. Let us see this in action.

With the above setup, when I select Business Unit dimension on a master record setup such as Project/Customer or anything else, the Cost center and Department dimensions will be auto populated, and i do not see to select them specifically. This is a pretty handy feature and will certainly save a lot of time for users in some cases.

For example, when i select Business unit 001 on my customer record, the Cost center and Department values auto populates to what i have setup.

The same defaulting functionality works on journal entry as well. For example, when I do a general journal entry and select the Business Unit dimension, i can have other dimension values defaulted (as long as they pass other account structure related validations)

Financial Journal Validation: Additional functionality to simulate posting during journal validation is available, which allows you to basically run the whole posting process, without actually posting the journal. As a result, you can see the possible errors, messages or warnings and you can take corrective actions on the journal.

Global Shared Number Sequence for Customers and Vendors:  The global shared number sequence functionality allows you to use a single number sequence across many legal entities for customers and vendors. With this, you can also copy customers and vendors easily between legal entities. Since you cannot share master data using virtual companies anymore in D365 F&O, this might be a functionality you want to use to share the customer or vendor master if needed in your implementation.

Note: This functionality is not a replacement of the Virtual company feature by any means. It is just a possible alternate that can be leveraged to have same customer ID and info for one customer across multiple entities, but they will live as separate data records and have their own transactions.

The first thing you have to do is configure a Shared number sequence and then you will need to select the same shared number sequence under the Number sequence parameter.

Then you need to make sure you select the same number sequence code for the customer account under the AR parameters page in all the entities where you want to use the shared customer account ID.


With that setup, let us now see how you can copy customer accounts from one entity to another and they will use the same customer account number and other related info for the customer.

In USSI entity, I created a new customer account. Notice that when i create the new customer, system does not assign a Customer account number immediately. This is because, if you want to copy the customer from another entity, it will use the same customer account number. If not, it will assign a new shared number after you save the details on the customer. (We will see this copying feature when we create this same customer in another entity USMF).

Now i have filled the required details for this new customer and i save the data. System assigned a customer account number using the shared number sequence we had setup.

We will now copy the customer in the USMF entity. Let us see how that process looks like. I will navigate to the Customer master in the USMF entity and click New on the All Customers page, and then i will type in the customer name i want to copy. System will automatically find the match and if they are an existing customer in another entity, it will present an option to copy the customer account.

You will now see that the Customer information is copied into the USMF entity and it used the same Customer account number.

Note: You will need to make sure all the dependent data fields for the customer account are correctly setup in both entities.

Now that we have the shared customer account numbers setup and customer accounts copied, let us look at another new feature that complements this feature.

Global Customer and Vendor Transactions List page:  If you are using shared number sequence for customers/vendors and have copied the accounts between multiple entities, you would obviously want to see a centralized view where you can see the transactions of the customer of vendor in all the entities they are copied in. I have already posted some transactions for this new customer “Marshal’s New store” in both USSI and USMF entities.

Invoice posted in USSI:

Invoice Posted in USMF:

Let’s see how the look in the new global transactions list page. I am in the USMF entity now and i will navigate to the global transactions list page.

Notice that the new page shows me all the transactions for this customer account form multiple entities. You will notice here that when you select the transaction for the specific entity on this page, the system automatically switches the company account, so that you can perform required operations on the transaction correctly.

That’s it for today’s post. In the next post, we will discuss in detail about another new feature in the core financials module called ‘Dual currency” and learn how it works and what are some of the significant changes that were introduced as part of this functionality.

Till next time !!!

Microsoft PowerApps, Microsoft Flow, SharePoint and Dynamics 365 working together, No coding required!!

Dynamics 365, Power Platform & Dataverse

All of you who attended the Microsoft Inspire and Las Vegas this year and the Microsoft Business Sumit at Seattle, would have heard a lot about the Microsoft Power platform. All the surrounding apps and services in Dynamics 365, such as Microsoft PowerApps, Flow, PowerBI, CDS etc. now are referred as the new Power platform.

In today’s blog post, we will see how all these powerful services puts the real power in the hands of the super-users of the systems and enables them to create seamless business process automation between applications such as Office 365, Microsoft SharePoint, Dynamics 365 and others, without requiring to write a single line of code.

The Scenario and the requirement:

  1. IT team of an organization uses Microsoft SharePoint(Office 365) for tracking company equipment loaned to it’s employees and for managing them. They use a SharePoint list for tracking these loaned equipment.
  2. Let us say the…

View original post 1,351 more words