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

Void payments in AX 2012 R3

Cheque payments: (No review process) Navigate to Cash and bank management > Common > Cheques.Select the cheque to reverse.Click Payment reversal.Enter a date and a reason for reversal (The reason is mandatory).Select OK to post the reversal. Other vendor payments (Ex: Electronic payments) Navigate to Purchase ledger > Suppliers > All suppliers. Select the vendorContinue reading “Void payments in AX 2012 R3”