Power automate – Delete sharepoint files automatically

I have been playing with Power automate lately and I found it very useful. I thought about one use case and many others came in mind after this one I confess… In D365 F&SCM, you can export data into Excel and set up a document type to store the file in a sharepoint folder. However,Continue reading “Power automate – Delete sharepoint files automatically”

Regression Suite Automation Tool (RSAT) – Guidelines

RSAT is an automated testing tool that allows organizations to automate testing for their business processes in D365 Finance & Operations. First, you need to define your test plan, test suite and test cases in Azure DevOps Example: Test plan = RSAT Test suite = Indirect procurement Test cases = Purchase order creation There areContinue reading “Regression Suite Automation Tool (RSAT) – Guidelines”

D365 Finance – What a change !!

D365 Finance has evolved significantly for a couple of years. I would like to highlight what are the new features that are a game changer. The full scope of Finance can be managed in D365 Finance. The weak point remains the cost controlling scope if I may say. I try to make you discover thoseContinue reading “D365 Finance – What a change !!”

Goods in transit management in D365 F&SCM

The new landed cost module in D365 F&SCM allows to gain supply chain visibility and maximize item profitability. It is also designed specifically for Inbound shipping operations. How to activate the landed cost module ? In the Feature management workspace, turn on the landed cost feature Go to the Landed cost module, then in theContinue reading “Goods in transit management in D365 F&SCM”

Import bank statements (MT940)

The purpose of importing bank statements is to perform reconciliation of payments sent to the bank, and payments received versus the cash amounts shown on the bank statement. The bank reconciliation is an important part of a company’s internal controls over its assets. The most common formats of electronic bank statements are MT940, BAI2 andContinue reading “Import bank statements (MT940)”

Consolidation in D365 F&O

Consolidations in D365 F&O comes with two features to accomplish consolidations. One of the functionalities that can be used to consolidate is what is now called Financial Reporter.  Your second option in D365 F&O is a process called “Consolidate online.” I explain how to use the “Consolidate online” feature in our case. Consolidation company (ReportingContinue reading “Consolidation in D365 F&O”

How to apply cost allocation rules in the cost accounting module ?

In my previous article, I showed you how to configure the basics of cost accounting in D365 F&O. It is time to move to the next steps and apply some allocation rules.  I would like to apply allocations based on statistical dimensions. Some costs have been accumulated on non allocated business units and need toContinue reading “How to apply cost allocation rules in the cost accounting module ?”

Cost accounting – Configuration basics

Cost accounting is the process of recording, analyzing and reporting all of a company’s costs. It classifies a company’s costs by behaviour (fixed, variable, etc), by nature (direct, indirect),  by function (administration, production, etc)… The following example shows the difference between direct and indirect costs.  The cost accounting module in D365 F&O has been dramaticallyContinue reading “Cost accounting – Configuration basics”

Foreign exchange rate exposure – Intro

International companies sell goods to overseas customers and they receive payments in the customer’s currency. For instance, a company that operates and reports in EUR made a sale to a customer in the United States for 1 000 USD. That company is subject to the risks resulting from fluctuations in the USD/EUR exchange rate. However,Continue reading “Foreign exchange rate exposure – Intro”

Credit management in D365 F&O

In the previous versions of D365 F&O, there were crucial features missing around credit management. That’s why I have seen many developments in that area of the ERP.   Fortunately, Microsoft released a brand new feature called credit management that covers most business cases that I have encountered. However, there is a big limitation in someContinue reading “Credit management in D365 F&O”