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”

Vendor payments in D365 F&O

In the previous versions of D365 F&O, the usual approach to processing payments for a vendor involves creating a payment journal, and then processing a payment proposal. To provide more automation capabilities, a new feature for payment processing has been introduced lately. You can create a predefined schedule with a combination of payment proposal criteriaContinue reading “Vendor payments in D365 F&O”

How to deal with enums in Electronic Reporting ?

Enum fields cannot be exported as it is in Electronic reporting. We need to use a workaround that is detailed in that post.  In our case I would like to export the item type stored on a purchase order line.   In the Model mapping designer, select Enumeration and click Add root  Type in a Name Continue reading “How to deal with enums in Electronic Reporting ?”

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