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 !!”

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”

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”

Security in D365 F&O (III)

I would like to address briefly the last topic about Security in D365 F&O, i.e. field level access. Granting update access to a limited number of fields or makes a field invisible can be performed in D365 F&O. In our case, an organisation asks you to give access to raise a sales order but theyContinue reading “Security in D365 F&O (III)”

Security in D365 F&O (II)

I promised to deep dive into more complex and key security topics, here we go ! That article is part of a series of articles about security in D365 F&0.  I am an internal controller in an organisation and I need to see the log of users who have been logged on to D365 F&O and if they have accessContinue reading “Security in D365 F&O (II)”

Security in D365 F&O (I)

Security in D365 F&O is often not the priority in any ERP implementation. That topic is most of the time tackled after all other major topics and that is a mistake in my opinion. A resource should be assigned to that task and a specific security stream should be created. That article describes shortly how toContinue reading “Security in D365 F&O (I)”

Goods in Transit (Upfront invoices)

1 Business scenarioThe vendor sends the invoice before the goods are delivered to us. We would like to book the invoice before receiving in the goods. However, the invoice is approved after the goods are received in our warehouse and after our quality control. As a result, payment runs must exclude those invoices. 2 ProcessContinue reading “Goods in Transit (Upfront invoices)”