---
title: Cittros Insights
description: Cittros Insights
---

[![cittros_white_200](https://www.cittros.com/hs-fs/hubfs/LOGO%20CITTROS/cittros_white_200.png?width=200&height=39&name=cittros_white_200.png)

![cittros_regular_200x40](https://www.cittros.com/hs-fs/hubfs/LOGO%20CITTROS/cittros_regular_200x40.png?width=200&height=39&name=cittros_regular_200x40.png) 

](https://www.cittros.com)

[**](https://www.cittros.com/insights/all#tmpmodule_1568761248550301)

**

###### 2 min read

## [Cross Company Data sharing in Dynamics 365 Finance](https://www.cittros.com/insights/cross-company-data-sharing-in-dynamics-365-finance)

 By [Clara Seijo Blanque](https://www.cittros.com/insights/author/clara-seijo-blanque) on 19 July 2024

[![](https://www.cittros.com/hubfs/database-1954920_1280.jpg) ](https://www.cittros.com/insights/cross-company-data-sharing-in-dynamics-365-finance)

Working with multiple legal entities in Microsoft Dynamics 365 Finance can involve a high effort during the configuration of the system and once the project is live, if in the support phase is required to create new parameters/configuration in multiple entities.

###### Topics: [Finance](https://www.cittros.com/insights/topic/finance) [D365FO](https://www.cittros.com/insights/topic/d365fo) [D365 Supply Chain Management](https://www.cittros.com/insights/topic/d365-supply-chain-management)

###### 5 min read

## [Invoice capture in Dynamics 365 Finance](https://www.cittros.com/insights/invoice-capture-in-dynamics-365-finance)

 By [Clara Seijo Blanque](https://www.cittros.com/insights/author/clara-seijo-blanque) on 12 July 2024

[![](https://www.cittros.com/hubfs/2024-05-07_14-14-38.jpg) ](https://www.cittros.com/insights/invoice-capture-in-dynamics-365-finance)

The Accounts Payable departments spend part of their time processing vendor invoices: collect the invoices from the post mail or email, create the invoices in the system, start the approval process and post the invoices for future payment.

###### Topics: [Finance](https://www.cittros.com/insights/topic/finance) [D365FO](https://www.cittros.com/insights/topic/d365fo) [OCR](https://www.cittros.com/insights/topic/ocr) [AI](https://www.cittros.com/insights/topic/ai) [Machine learning](https://www.cittros.com/insights/topic/machine-learning)

###### 2 min read

## [Foreign currency revaluation improvements](https://www.cittros.com/insights/foreign-currency-revaluation-improvements)

 By [Clara Seijo Blanque](https://www.cittros.com/insights/author/clara-seijo-blanque) on 05 July 2024

[![](https://www.cittros.com/hubfs/Cittros%20Image%20bank/currency-1680795_1280.png) ](https://www.cittros.com/insights/foreign-currency-revaluation-improvements)

Working with multiple currencies means that, at the end of the month, is required to run the Foreign Currency Revaluation process for open vendor transactions (AP), open customer transactions (AR), bank balances and ledger balances.

###### Topics: [Finance](https://www.cittros.com/insights/topic/finance) [D365FO](https://www.cittros.com/insights/topic/d365fo)

###### 6 min read

## [Intercompany timesheets setup and process](https://www.cittros.com/insights/intercompany-timesheets-setup-and-process)

 By [Clara Seijo Blanque](https://www.cittros.com/insights/author/clara-seijo-blanque) on 28 June 2024

[![](https://www.cittros.com/hubfs/Designer%20(14).jpeg) ](https://www.cittros.com/insights/intercompany-timesheets-setup-and-process)

In the actual scenario with a super globalized world and with the teleworking becoming more and more common, each time is more often that resources from a company are decentralized and working from different locations in the same global projects. 

###### Topics: [Finance](https://www.cittros.com/insights/topic/finance) [D365FO](https://www.cittros.com/insights/topic/d365fo)

###### 2 min read

## [Customer engagement in Dynamics 365 Commerce](https://www.cittros.com/insights/customer-engagement-in-dynamics-365-commerce)

 By [Daniela Arsovska](https://www.cittros.com/insights/author/daniela-arsovska) on 21 June 2024

[![](https://www.cittros.com/hubfs/mobile-phone-5836879_1280.png) ](https://www.cittros.com/insights/customer-engagement-in-dynamics-365-commerce)

In this article we are providing an overview of customer engagement strategies within Dynamics 365 Commerce for retailers. The illustration below gives an overview of the main points regarding the system's capabilities:

###### Topics: [D365FO](https://www.cittros.com/insights/topic/d365fo) [D365 Commerce](https://www.cittros.com/insights/topic/d365-commerce) [Retail](https://www.cittros.com/insights/topic/retail)

###### 2 min read

## [Manage store inventory in Dynamics 365 Commerce](https://www.cittros.com/insights/manage-store-inventory-in-dynamics-365-commerce)

 By [Daniela Arsovska](https://www.cittros.com/insights/author/daniela-arsovska) on 14 June 2024

[![](https://www.cittros.com/hubfs/high-level-rack-ga19dbd3ba_1280.jpg) ](https://www.cittros.com/insights/manage-store-inventory-in-dynamics-365-commerce)

Managing store inventory in Dynamics 365 Commerce is essential for efficient operations and customer satisfaction. Dynamics 365 Commerce offers various capabilities to manage store inventory effectively, such as replenishment, inbound and outbound operations, stock counts, and inventory lookup features. Let us delve into the key points: 

Dynamics 365 Commerce utilizes the warehouse entity to oversee and manage physical inventory at each fulfillment location, whether it is a distribution center or a brick-and-mortar store.

###### Topics: [D365FO](https://www.cittros.com/insights/topic/d365fo) [D365 Commerce](https://www.cittros.com/insights/topic/d365-commerce) [Retail](https://www.cittros.com/insights/topic/retail)

###### 2 min read

## [Configure info codes - Commerce Part 6](https://www.cittros.com/insights/configure-info-codes-commerce-part-6)

 By [Daniela Arsovska](https://www.cittros.com/insights/author/daniela-arsovska) on 07 June 2024

[![](https://www.cittros.com/hubfs/e-commerce-gf2de66c71_1280.jpg) ](https://www.cittros.com/insights/configure-info-codes-commerce-part-6)

 

###### Topics: [D365 Commerce](https://www.cittros.com/insights/topic/d365-commerce) [Retail](https://www.cittros.com/insights/topic/retail) [POS](https://www.cittros.com/insights/topic/pos)

###### 4 min read

## [Set up modes of delivery - Commerce part 5](https://www.cittros.com/insights/set-up-modes-of-delivery-commerce-part-5)

 By [Daniela Arsovska](https://www.cittros.com/insights/author/daniela-arsovska) on 31 May 2024

[![](https://www.cittros.com/hubfs/cash-register-g2437a9fd5_1280.jpg) ](https://www.cittros.com/insights/set-up-modes-of-delivery-commerce-part-5)

This article is about setting up how items get delivered to your store or online shop. We will show you how to pick which delivery options you want for your places and for selling items on the Internet. You will also find out how to offer different shipping methods for different mixes of your shops, what you are selling, and where it is going.

###### Topics: [D365 Commerce](https://www.cittros.com/insights/topic/d365-commerce) [Retail](https://www.cittros.com/insights/topic/retail) [POS](https://www.cittros.com/insights/topic/pos)

###### 22 min read

## [Setup PayPal - Commerce part 4](https://www.cittros.com/insights/setup-paypal-commerce-part-4)

 By [Daniela Arsovska](https://www.cittros.com/insights/author/daniela-arsovska) on 24 May 2024

[![](https://www.cittros.com/hubfs/paypal-gd0b67edcf_1280.jpg) ](https://www.cittros.com/insights/setup-paypal-commerce-part-4)

A significant portion of e-commerce transactions uses PayPal for online payments. D365 Commerce offers an out-of-the-box PayPal connector to facilitate the acceptance of PayPal transactions. Once an order is created and fulfilled, PayPal payments are captured from the back office as part of the invoicing process.

###### Topics: [D365 Commerce](https://www.cittros.com/insights/topic/d365-commerce) [Retail](https://www.cittros.com/insights/topic/retail) [POS](https://www.cittros.com/insights/topic/pos)

###### 3 min read

## [Copilot for Finance in Outlook](https://www.cittros.com/insights/copilot-for-finance-in-outlook)

 By [Daniela Arsovska](https://www.cittros.com/insights/author/daniela-arsovska) on 03 May 2024

[![](https://www.cittros.com/hubfs/2024-04-24_12-09-19.jpg) ](https://www.cittros.com/insights/copilot-for-finance-in-outlook)

In our previous article we explained how to use Copilot for Finance in Excel, now we are going to dive into Copilot for Finance in Outlook. As we mentioned before in our previous article, Copilot for Finance and Outlook are now integrated. This means we can reply and write new emails straight from Copilot for Finance. It can save us time and make us more accurate in our answers. Let us dive into writing a new email using Copilot. 

###### Topics: [D365FO](https://www.cittros.com/insights/topic/d365fo) [Copilot](https://www.cittros.com/insights/topic/copilot) [Outlook](https://www.cittros.com/insights/topic/outlook) [AI](https://www.cittros.com/insights/topic/ai)

###### 3 min read

## [Excel reconciliation with Copilot for Finance](https://www.cittros.com/insights/excel-reconciliation-with-copilot-for-finance)

 By [Daniela Arsovska](https://www.cittros.com/insights/author/daniela-arsovska) on 26 April 2024

[![](https://www.cittros.com/hubfs/2024-04-24_11-46-33.jpg) ](https://www.cittros.com/insights/excel-reconciliation-with-copilot-for-finance)

Microsoft has this new tool called Microsoft Copilot for Finance. It is designed to make life easier for finance teams by automating the boring stuff and giving them smart tips right within the apps they are already using every day, like Excel and Outlook. This new feature is part of Microsoft 365, and it is smart enough to collaborate with your company's financial systems, like Dynamics 365. With Copilot for Finance, you can automate tasks, get suggestions on what to do next, and make better decisions without wasting any time.

###### Topics: [Finance](https://www.cittros.com/insights/topic/finance) [D365FO](https://www.cittros.com/insights/topic/d365fo) [Copilot](https://www.cittros.com/insights/topic/copilot) [Excel](https://www.cittros.com/insights/topic/excel) [AI](https://www.cittros.com/insights/topic/ai)

###### 12 min read

## [Configure payment methods - Commerce part 3](https://www.cittros.com/insights/configure-payment-methods-commerce-part-3)

 By [Daniela Arsovska](https://www.cittros.com/insights/author/daniela-arsovska) on 19 April 2024

[![](https://www.cittros.com/hubfs/credit-card-g1516d5ede_1280.jpg) ](https://www.cittros.com/insights/configure-payment-methods-commerce-part-3)

In this article we will give a brief explanation on how to set up a payment method for omnichannel in D365 Commerce. 

###### Topics: [D365 Commerce](https://www.cittros.com/insights/topic/d365-commerce) [Retail](https://www.cittros.com/insights/topic/retail) [POS](https://www.cittros.com/insights/topic/pos)

###### 4 min read

## [Configure omnichannel prerequisites in Dynamics 365 Commerce - Part 2](https://www.cittros.com/insights/configure-omnichannel-prerequisites-in-dynamics-365-commerce-part-2)

 By [Daniela Arsovska](https://www.cittros.com/insights/author/daniela-arsovska) on 12 April 2024

[![](https://www.cittros.com/hubfs/shopping-gcef9da5da_640.png) ](https://www.cittros.com/insights/configure-omnichannel-prerequisites-in-dynamics-365-commerce-part-2)

In this article we are going to explain how to configure a retail warehouse, one of remaining components of the omnichannel in D365. [In the previous post](https://www.cittros.com/insights/how-to-configure-omnichannel-in-dynamics-365-commerce-part-1), we explain how to do the setup for *Initializing Seed Data*, *Commerce Parameters* and *Distribution Schedules*. Here we will continue with configuration of the warehouse.

###### Topics: [D365FO](https://www.cittros.com/insights/topic/d365fo) [D365 Commerce](https://www.cittros.com/insights/topic/d365-commerce)

###### 4 min read

## [Setting up Omnichannel in Dynamics 365 Commerce - Step by step Part 1](https://www.cittros.com/insights/how-to-configure-omnichannel-in-dynamics-365-commerce-part-1)

 By [Daniela Arsovska](https://www.cittros.com/insights/author/daniela-arsovska) on 05 April 2024

[![](https://www.cittros.com/hubfs/e-commerce-g6a05b8475_640.png) ](https://www.cittros.com/insights/how-to-configure-omnichannel-in-dynamics-365-commerce-part-1)

Before you dive into setting up your online store or other sales channels, or before you get your Dynamics 365 Commerce rolling, there are some basic things you have got to do first. Here's what you need to sort out:

###### Topics: [D365FO](https://www.cittros.com/insights/topic/d365fo) [D365 Commerce](https://www.cittros.com/insights/topic/d365-commerce) [Retail](https://www.cittros.com/insights/topic/retail)

###### 4 min read

## [Dynamics 365 Commerce - channel types](https://www.cittros.com/insights/dynamics-365-commerce-channel-types)

 By [Daniela Arsovska](https://www.cittros.com/insights/author/daniela-arsovska) on 29 March 2024

[![](https://www.cittros.com/hubfs/online-store-g27f0978ae_1280.png) ](https://www.cittros.com/insights/dynamics-365-commerce-channel-types)

[Dynamics 365 Commerce](https://www.cittros.com/insights/introduction-to-d365-commerce) is cool for shoppers because it lets you buy stuff whenever and wherever you want, on any device, and this works both online and if you walk into a store.

###### Topics: [D365FO](https://www.cittros.com/insights/topic/d365fo) [D365 Commerce](https://www.cittros.com/insights/topic/d365-commerce) [Retail](https://www.cittros.com/insights/topic/retail)

###### 6 min read

## [How to connect Retail CPOS to a hardware station](https://www.cittros.com/insights/how-to-connect-retail-cpos-to-a-hardware-station)

 By [Daniela Arsovska](https://www.cittros.com/insights/author/daniela-arsovska) on 22 March 2024

[![](https://www.cittros.com/hubfs/register-g8ee8245be_1280.jpg) ](https://www.cittros.com/insights/how-to-connect-retail-cpos-to-a-hardware-station)

A Cloud-based Point of Sale (CPOS) is a web-based application accessible through a web browser. As a result, it does not support offline capabilities. CPOS is intended to be used together with a hardware station in the retail store.

After the [introduction to Microsoft Dynamics 365 Commerce](https://www.cittros.com/insights/introduction-to-d365-commerce), in this article we are going to see how to connect Retail CPOS to a hardware station.

Connecting Retail Cloud POS (CPOS) to a hardware station requires a few steps to properly set up and associate users, as well as to ensure that hardware and software communicate correctly. Here is a summarized guide to help you through the process:

###### Topics: [D365 Commerce](https://www.cittros.com/insights/topic/d365-commerce) [Retail](https://www.cittros.com/insights/topic/retail)

###### 7 min read

## [Exploring D365 Commerce – A Gateway to Unifying Commerce](https://www.cittros.com/insights/introduction-to-d365-commerce)

 By [Daniela Arsovska](https://www.cittros.com/insights/author/daniela-arsovska) on 15 March 2024

[![](https://www.cittros.com/hubfs/girl-gd29d3617d_1280.jpg) ](https://www.cittros.com/insights/introduction-to-d365-commerce)

We are welcoming you to our series of eleven articles on Dynamics 365 Commerce, where we dive into the world of modern retail and business management. In this first article, "Exploring D365 Commerce," we will introduce you to the importance of Dynamics 365 Commerce today.  This article will be followed up by these ten other articles: 

- How to connect Retail CPOS to a hardware station (activation) 
- Dynamics 365 Commerce channels  
- Setting up Omnichannel in D365 Commerce 
- Configure omnichannel prerequisites in D365 Commerce  
- Dynamics d365 Commerce Payment methods  
- Setup PayPal  
- Configure mode of delivery  
- Configure info codes 
- Manage channel inventory 
- Customer engagement in d365 

In today's world, where customers expect more, Dynamics 365 Commerce has tried to create a complete omnichannel solution. It combines the operations of the back-office, physical stores, call centers, and online storefronts.

###### Topics: [D365FO](https://www.cittros.com/insights/topic/d365fo) [D365 Commerce](https://www.cittros.com/insights/topic/d365-commerce) [Retail](https://www.cittros.com/insights/topic/retail)

###### 3 min read

## [Financial tags for Sales Order](https://www.cittros.com/insights/financial-tags-for-sales-order)

 By [Clara Seijo Blanque](https://www.cittros.com/insights/author/clara-seijo-blanque) on 08 March 2024

[![](https://www.cittros.com/hubfs/Knowledge%20base/tags-gf712a7b8a_1280.png) ](https://www.cittros.com/insights/financial-tags-for-sales-order)

A few months ago we [discover ](https://www.cittros.com/insights/financial-tags-discovering)the new functionality included in Microsoft Dynamics 365 Finance, Financial Tags, and as I was expecting this great tool, after been included in [journals](https://www.cittros.com/insights/financial-tags-for-journals), is growing, nice!!

###### Topics: [Finance](https://www.cittros.com/insights/topic/finance) [D365FO](https://www.cittros.com/insights/topic/d365fo)

###### 4 min read

## [Power Apps- which one is the right for your organization](https://www.cittros.com/insights/power-apps-which-one-is-the-right-for-your-organization)

 By [Daniela Arsovska](https://www.cittros.com/insights/author/daniela-arsovska) on 01 March 2024

[![](https://www.cittros.com/hubfs/microsoft-4553960_1280.png) ](https://www.cittros.com/insights/power-apps-which-one-is-the-right-for-your-organization)

Many organizations struggle to create solutions that support their business effectively. They find it hard to update their systems and often lack the resources needed to keep up with evolving business needs. One example, engineers in production frequently encounter situations where they require specific mechanical parts to complete a job. Usually, they would have to submit a request and wait for relevant managers to respond, only to discover the part is not available. With Power Apps, engineers can now check inventory levels on-site and request parts immediately. This will minimize delays and will streamline the process.

###### Topics: [Power Platform](https://www.cittros.com/insights/topic/power-platform) [PowerApps](https://www.cittros.com/insights/topic/powerapps)

###### 2 min read

## [Marked Transaction Detail form in Microsoft Dynamics 365 Finance and Operations](https://www.cittros.com/insights/marked-transaction-detail-form-in-microsoft-dynamics-365-finance-and-operations)

 By [Daniela Arsovska](https://www.cittros.com/insights/author/daniela-arsovska) on 23 February 2024

[![](https://www.cittros.com/hubfs/compare-1207270_1280.jpg) ](https://www.cittros.com/insights/marked-transaction-detail-form-in-microsoft-dynamics-365-finance-and-operations)

Sometimes you or your client have encountered a bit of a hiccup when creating an Accounts Payable Payment Journal, specifically running into an error that states: "*This transaction has been marked for settlement by AP payment*.” No worries, in this article I will guide you through a straightforward process to resolve this.

###### Topics: [Finance](https://www.cittros.com/insights/topic/finance) [D365FO](https://www.cittros.com/insights/topic/d365fo) [D365 Supply Chain Management](https://www.cittros.com/insights/topic/d365-supply-chain-management)

###### 5 min read

## [Tips and Tricks for Accrual Schemes in D365FO](https://www.cittros.com/insights/tips-and-tricks-for-accrual-schemes-in-d365fo)

 By [Mads Bender](https://www.cittros.com/insights/author/mads-bender) on 16 February 2024

[![](https://www.cittros.com/hubfs/image.png) ](https://www.cittros.com/insights/tips-and-tricks-for-accrual-schemes-in-d365fo)

**Introduction:**   
Welcome to our latest blog post where we delve into the world of Accrual Schemes within Dynamics 365 Finance and Operations (D365FO). This topic is crucial for anyone involved in financial management, as understanding, and effectively utilizing accrual schemes is key to accurately representing a company's financial health. Today, we're excited to share a powerful trick that will not only simplify working with accruals in D365FO but also enhance your overall financial oversight. Let's get started! 

###### Topics: [Finance](https://www.cittros.com/insights/topic/finance) [D365FO](https://www.cittros.com/insights/topic/d365fo)

###### 4 min read

## [How to test if the Email was sent in D365 Finance and Operations](https://www.cittros.com/insights/how-to-test-if-the-email-was-sent-in-d365-finance-and-operations)

 By [Daniela Arsovska](https://www.cittros.com/insights/author/daniela-arsovska) on 09 February 2024

[![](https://www.cittros.com/hubfs/email-4284157_1280.png) ](https://www.cittros.com/insights/how-to-test-if-the-email-was-sent-in-d365-finance-and-operations)

Are your users asking why they are not receiving workflow emails? Or they have sent an invoice to a customer who claims they have not received it? In this article, I will demonstrate how to verify that an email has been sent and how to access the email history to view the email content. I will also cover adjusting the sender's email address.

###### Topics: [D365FO](https://www.cittros.com/insights/topic/d365fo) [D365 Supply Chain Management](https://www.cittros.com/insights/topic/d365-supply-chain-management)

###### 3 min read

## [Enabling Copilot in Power Platform](https://www.cittros.com/insights/enabling-copilot-in-power-platform)

 By [Daniela Arsovska](https://www.cittros.com/insights/author/daniela-arsovska) on 02 February 2024

[![](https://www.cittros.com/hubfs/undefined-4.png) ](https://www.cittros.com/insights/enabling-copilot-in-power-platform)

Microsoft is offering an incredible feature - Copilot in Power Platform. It is of great help when building an app. Copilot in Power Apps acts like a smart helper. It helps app users understand their data by chatting in everyday language. With Copilot, users can work smarter, getting helpful tips and easily moving around the app.  

###### Topics: [Copilot](https://www.cittros.com/insights/topic/copilot) [Power Platform](https://www.cittros.com/insights/topic/power-platform)

###### 6 min read

## [Navigate the URL landscape using query parameters in D365 FO](https://www.cittros.com/insights/navigate-the-url-landscape-using-query-parameters-in-d365-fo)

 By [Vladimir Danoski](https://www.cittros.com/insights/author/vladimir-danoski) on 26 January 2024

[![](https://www.cittros.com/hubfs/Navigate%20the%20URL%20landscape%20using%20query%20parameters%20in%20D365%20FO.jpg) ](https://www.cittros.com/insights/navigate-the-url-landscape-using-query-parameters-in-d365-fo)

 

###### Topics: [Finance](https://www.cittros.com/insights/topic/finance) [D365FO](https://www.cittros.com/insights/topic/d365fo) [D365 Supply Chain Management](https://www.cittros.com/insights/topic/d365-supply-chain-management)

###### 4 min read

## [Modification of Excel templates in D365 FO](https://www.cittros.com/insights/modification-of-excel-templates-in-d365-fo)

 By [Daniela Arsovska](https://www.cittros.com/insights/author/daniela-arsovska) on 19 January 2024

[![](https://www.cittros.com/hubfs/Designer%20(12).jpeg) ](https://www.cittros.com/insights/modification-of-excel-templates-in-d365-fo)

When dealing with journals that have a lot of data lines, the best way to manage it is by opening the journal lines in Excel. Dynamics 365 Finance and Operations (D365 FO) provides this functionality, which is incredibly useful. However, frequently, the standard templates need adjustments to meet specific business requirements.

###### Topics: [Finance](https://www.cittros.com/insights/topic/finance) [D365FO](https://www.cittros.com/insights/topic/d365fo) [D365 Supply Chain Management](https://www.cittros.com/insights/topic/d365-supply-chain-management)

###### 1 min read

## [Vendor on hold for payment](https://www.cittros.com/insights/vendor-on-hold-for-payment)

 By [Daniela Arsovska](https://www.cittros.com/insights/author/daniela-arsovska) on 12 January 2024

[![](https://www.cittros.com/hubfs/clock-2696234_1280.jpg) ](https://www.cittros.com/insights/vendor-on-hold-for-payment)

I am sure many of you have been in this situation where you want to block a vendor, but not fully block him.There are a few different ways and a few different reasons why we want to put vendor on hold. Let us assume we have not received the required quantity and quality from our vendor, so we decided to put the payment for this vendor on hold.

###### Topics: [Finance](https://www.cittros.com/insights/topic/finance) [D365FO](https://www.cittros.com/insights/topic/d365fo) [D365 Supply Chain Management](https://www.cittros.com/insights/topic/d365-supply-chain-management)

###### 5 min read

## [Advancing Your Skills Best Practices and Trade-offs in DAX and M Query](https://www.cittros.com/insights/advancing-your-skills-best-practices-and-trade-offs-in-dax-and-m-query)

 By [Mads Bender](https://www.cittros.com/insights/author/mads-bender) on 09 January 2024

[![](https://www.cittros.com/hubfs/image1%20(9).png) ](https://www.cittros.com/insights/advancing-your-skills-best-practices-and-trade-offs-in-dax-and-m-query)

Welcome back to a new Reporting Tuesday blog post, in this post we will dive deeper into Power BI's capabilities! After our introductory guide, this article focuses on enhancing your understanding of DAX and the strategic decisions between DAX and M Query. We’ll provide practical insights and applications for these concepts, aiming to boost your proficiency in Power BI. Enjoy!

###### Topics: [DAX](https://www.cittros.com/insights/topic/dax) [PowerBI](https://www.cittros.com/insights/topic/powerbi) [Reporting tuesdays](https://www.cittros.com/insights/topic/reporting-tuesdays) [Reporting](https://www.cittros.com/insights/topic/reporting)

###### 5 min read

## [Recurring AP invoices](https://www.cittros.com/insights/recurring-ap-invoices)

 By [Clara Seijo Blanque](https://www.cittros.com/insights/author/clara-seijo-blanque) on 05 January 2024

[![](https://www.cittros.com/hubfs/bookkeeper-1016299_1280.jpg) ](https://www.cittros.com/insights/recurring-ap-invoices)

 When I started to review the new features included in the release 10.0.38, the first one I'm curious about is Enable recurring AP invoice with this description provide by Microsoft:

###### Topics: [Finance](https://www.cittros.com/insights/topic/finance) [D365FO](https://www.cittros.com/insights/topic/d365fo) [D365 Supply Chain Management](https://www.cittros.com/insights/topic/d365-supply-chain-management)

###### 2 min read

## [A Novice's Guide to DAX in Power BI](https://www.cittros.com/insights/a-novices-guide-to-dax-in-power-bi)

 By [Mads Bender](https://www.cittros.com/insights/author/mads-bender) on 19 December 2023

[![](https://www.cittros.com/hubfs/image1%20(8).png) ](https://www.cittros.com/insights/a-novices-guide-to-dax-in-power-bi)

Introduction

Welcome back to a new Reporting Tuesday blog post. As a novice to the world of Power BI, one term you'll often encounter is DAX, or Data Analysis Expressions. This beginner-friendly guide will introduce you to DAX, explaining its importance and how it can transform your data analytics experience in Power BI. Enjoy!

###### Topics: [DAX](https://www.cittros.com/insights/topic/dax) [PowerBI](https://www.cittros.com/insights/topic/powerbi) [Reporting tuesdays](https://www.cittros.com/insights/topic/reporting-tuesdays) [Reporting](https://www.cittros.com/insights/topic/reporting)

###### 3 min read

## [Temporary voucher number in D365 Finance](https://www.cittros.com/insights/temporary-voucher-number-in-d365-finance-and-operations)

 By [Daniela Arsovska](https://www.cittros.com/insights/author/daniela-arsovska) on 15 December 2023

[![](https://www.cittros.com/hubfs/hourglass-3697513_1280.jpg) ](https://www.cittros.com/insights/temporary-voucher-number-in-d365-finance-and-operations)

Often, we are witnesses or the error message: “Voucher XXX is already used as of date XXX.”

###### Topics: [Finance](https://www.cittros.com/insights/topic/finance) [D365FO](https://www.cittros.com/insights/topic/d365fo) [D365 Supply Chain Management](https://www.cittros.com/insights/topic/d365-supply-chain-management)

###### 2 min read

## [Generate payments from bank statement and reconciliation](https://www.cittros.com/insights/generate-customer-and-vendor-payments-from-bank-statement-and-reconciliation)

 By [Clara Seijo Blanque](https://www.cittros.com/insights/author/clara-seijo-blanque) on 08 December 2023

[![](https://www.cittros.com/hubfs/credit-card-1104961_1280.jpg) ](https://www.cittros.com/insights/generate-customer-and-vendor-payments-from-bank-statement-and-reconciliation)

In the new version of Dynamics 365 Finance 10.0.37 available this November 2023 there is an interesting new feature, in preview, called "Generate customer and vendor payments from bank statement and reconciliation". it sounds very helpful to generate, directly from the bank reconciliation form the customer or vendor transactions included in the bank statement of the bank that have not been posted in the system yet.

###### Topics: [Finance](https://www.cittros.com/insights/topic/finance) [D365FO](https://www.cittros.com/insights/topic/d365fo)

###### 2 min read

## [Use of Microsoft's Application Insights in D365 Finance](https://www.cittros.com/insights/use-of-microsofts-application-insights-in-d365-finance)

 By [Daniela Arsovska](https://www.cittros.com/insights/author/daniela-arsovska) on 01 December 2023

[![](https://www.cittros.com/hubfs/ux-787980_1280.jpg) ](https://www.cittros.com/insights/use-of-microsofts-application-insights-in-d365-finance)

Do you wonder how the app you created is doing? In our digital world, making sure applications work smoothly is super important. Applications do all sorts of jobs, like helping businesses, serving customers, and automating tasks. As apps become fancier, we need better ways to watch over them and fix problems. That is where Microsoft's Application Insights comes to the rescue.

###### Topics: [Finance](https://www.cittros.com/insights/topic/finance) [D365FO](https://www.cittros.com/insights/topic/d365fo) [Artificial intelligent](https://www.cittros.com/insights/topic/artificial-intelligent) [AI](https://www.cittros.com/insights/topic/ai) [Reporting](https://www.cittros.com/insights/topic/reporting)

###### 6 min read

## [Application Lifecycle Management Described: Building Software is Like Building a House](https://www.cittros.com/insights/application-lifecycle-management-described-building-software-is-like-building-a-house)

 By [Mads Bender](https://www.cittros.com/insights/author/mads-bender) on 29 November 2023

[![](https://www.cittros.com/hubfs/ALM%20described.jpg) ](https://www.cittros.com/insights/application-lifecycle-management-described-building-software-is-like-building-a-house)

**Introduction: ** 

###### Topics: [D365FO](https://www.cittros.com/insights/topic/d365fo) [D365 Commerce](https://www.cittros.com/insights/topic/d365-commerce) [D365 Supply Chain Management](https://www.cittros.com/insights/topic/d365-supply-chain-management) [ALM](https://www.cittros.com/insights/topic/alm)

###### 2 min read

## [New feature: Bulk edit in grid](https://www.cittros.com/insights/new-feature-bulk-edit-in-grid)

 By [Daniela Arsovska](https://www.cittros.com/insights/author/daniela-arsovska) on 24 November 2023

[![](https://www.cittros.com/hubfs/technology-791029_1280.jpg) ](https://www.cittros.com/insights/new-feature-bulk-edit-in-grid)

I bet that every one of us has had a request from our customers to change the value in some field for a group of vendors, or a Purchase order line. Then we needed to open each record one by one and make this change. The request may be a change of mode of delivery for given PO lines or change of vendor group for given vendors. And this is all time consuming.

###### Topics: [Finance](https://www.cittros.com/insights/topic/finance) [D365FO](https://www.cittros.com/insights/topic/d365fo) [D365 Supply Chain Management](https://www.cittros.com/insights/topic/d365-supply-chain-management)

###### 3 min read

## [Advanced Data Transformation Techniques in Power BI](https://www.cittros.com/insights/advanced-data-transformation-techniques-in-power-bi)

 By [Mads Bender](https://www.cittros.com/insights/author/mads-bender) on 21 November 2023

[![](https://www.cittros.com/hubfs/image1%20(7).png) ](https://www.cittros.com/insights/advanced-data-transformation-techniques-in-power-bi)

Welcome to another Reporting Tuesday blog post! Are you ready to unlock the full potential of Power BI with advanced data transformation techniques? Whether you're an intermediate user or on your way to becoming an advanced one, this article is tailored for you. Let's dive into the heart of effective reporting and analysis in Power BI.

###### Topics: [D365FO](https://www.cittros.com/insights/topic/d365fo) [PowerBI](https://www.cittros.com/insights/topic/powerbi) [Reporting tuesdays](https://www.cittros.com/insights/topic/reporting-tuesdays) [Reporting](https://www.cittros.com/insights/topic/reporting)

###### 1 min read

## [Approve posting with matching discrepancies](https://www.cittros.com/insights/approve-posting-with-matching-discrepancies)

 By [Daniela Arsovska](https://www.cittros.com/insights/author/daniela-arsovska) on 10 November 2023

[![](https://www.cittros.com/hubfs/tic-tac-toe-1777933_1280.jpg) ](https://www.cittros.com/insights/approve-posting-with-matching-discrepancies)

Have you ever been stuck with errors on matching invoice and purchase order?' in this article we will show you how to resolve matching discrepancies.

###### Topics: [Finance](https://www.cittros.com/insights/topic/finance) [D365FO](https://www.cittros.com/insights/topic/d365fo) [D365 Supply Chain Management](https://www.cittros.com/insights/topic/d365-supply-chain-management)

###### 5 min read

## [Foreign currency revaluation in MDyn365F](https://www.cittros.com/insights/foreign-currency-revaluation-in-mdyn365f)

 By [Clara Seijo Blanque](https://www.cittros.com/insights/author/clara-seijo-blanque) on 27 October 2023

[![](https://www.cittros.com/hubfs/currency-1680795_1280.png) ](https://www.cittros.com/insights/foreign-currency-revaluation-in-mdyn365f)

One of the powerful tools in Microsoft Dynamics 365 Finance is the use of multiple currencies with the specific exchange rates for the posting of vendor invoices, bank transfers, payments... as a summary, all the required movements that need to be posted in a company.

###### Topics: [Finance](https://www.cittros.com/insights/topic/finance) [D365FO](https://www.cittros.com/insights/topic/d365fo)

###### 2 min read

## [Excel add-in  - how to skip the extra download step](https://www.cittros.com/insights/excel-add-in-how-to-skip-the-extra-download-step)

 By [Inga Numadottir](https://www.cittros.com/insights/author/inga-numadottir) on 20 October 2023

[![](https://www.cittros.com/hubfs/tips-4905013_1280.jpg) ](https://www.cittros.com/insights/excel-add-in-how-to-skip-the-extra-download-step)

I find it very annoying to have to do the extra download when I just want to open data in Excel from D365 FO. What I realized is that it has nothing to do with D365, but that Edge is so ‘helpful’ and decides to always open Excel in a browser.

###### Topics: [Finance](https://www.cittros.com/insights/topic/finance) [D365FO](https://www.cittros.com/insights/topic/d365fo)

###### 2 min read

## [Journal features - one voucher and others](https://www.cittros.com/insights/journal-features-one-voucher-and-others)

 By [Inga Numadottir](https://www.cittros.com/insights/author/inga-numadottir) on 13 October 2023

[![](https://www.cittros.com/hubfs/desk-3076954_1280.jpg) ](https://www.cittros.com/insights/journal-features-one-voucher-and-others)

Microsoft is planning to discontinue the feature they call ‘One Voucher’. This feature allows you to use one voucher pr. journal. This journey has already started, and new features do not respect the setup of the journal. This can cause an issue when using some of the later features, as these do not check the setup of the journals used. The result is that some journals will never be posted. I have one good example below, where setup of journal in general is not considered in split fixed asset.

###### Topics: [Finance](https://www.cittros.com/insights/topic/finance) [D365FO](https://www.cittros.com/insights/topic/d365fo)

###### 4 min read

## [Exploring Parameterized Queries in Power BI](https://www.cittros.com/insights/exploring-parameterized-queries-in-power-bi)

 By [Mads Bender](https://www.cittros.com/insights/author/mads-bender) on 10 October 2023

[![](https://www.cittros.com/hubfs/Knowledge%20base/powerBI4.jpg) ](https://www.cittros.com/insights/exploring-parameterized-queries-in-power-bi)

Welcome back to another informative installment of our Reporting Tuesday blog posts. In this article, we will delve into the world of Parameterized Queries in Power BI. Parameterized queries are an exciting and potent feature that empowers you to create more adaptable and dynamic reports. By utilizing parameters to control the data loaded into your report, you can enhance the flexibility of your reporting while simplifying data manipulation during the loading process. Furthermore, this flexibility can, with the proper prerequisites, be extended to end-users, enabling them to slice and customize data according to their needs. In this article, we will break down what parameterized queries are, how to use them effectively, and why they are invaluable. Enjoy the exploration!

###### Topics: [PowerBI](https://www.cittros.com/insights/topic/powerbi) [Reporting tuesdays](https://www.cittros.com/insights/topic/reporting-tuesdays)

###### 2 min read

## [How to share a workspace](https://www.cittros.com/insights/how-to-share-a-workspace)

 By [Daniela Arsovska](https://www.cittros.com/insights/author/daniela-arsovska) on 06 October 2023

[![](https://www.cittros.com/hubfs/analysis-3782319_1280.jpg) ](https://www.cittros.com/insights/how-to-share-a-workspace)

In this fourth and last article for [creation of workspace](https://www.cittros.com/insights/creating-a-workspace-in-d365) we are going to explain how to share the workspace. 

###### Topics: [Finance](https://www.cittros.com/insights/topic/finance) [D365FO](https://www.cittros.com/insights/topic/d365fo) [Workspace](https://www.cittros.com/insights/topic/workspace)

###### 3 min read

## [Add list and link to the workspace](https://www.cittros.com/insights/add-list-and-link-to-the-workspace)

 By [Daniela Arsovska](https://www.cittros.com/insights/author/daniela-arsovska) on 29 September 2023

[![](https://www.cittros.com/hubfs/charts-6246450_1280.png) ](https://www.cittros.com/insights/add-list-and-link-to-the-workspace)

This is the third article in the series of articles about how to create workspace and share the workspace.  

###### Topics: [Finance](https://www.cittros.com/insights/topic/finance) [D365FO](https://www.cittros.com/insights/topic/d365fo) [Workspace](https://www.cittros.com/insights/topic/workspace)

###### 5 min read

## [Basic Data Transformation Techniques in Power BI](https://www.cittros.com/insights/basic-data-transformation-techniques-in-power-bi)

 By [Mads Bender](https://www.cittros.com/insights/author/mads-bender) on 26 September 2023

[![](https://www.cittros.com/hubfs/Knowledge%20base/powerBI.jpg) ](https://www.cittros.com/insights/basic-data-transformation-techniques-in-power-bi)

Welcome back to another installment of our Reporting Tuesday blog posts. In this article, we will delve into the fundamental Data Transformation Techniques in Power BI. This exciting journey will enable you to harness Power BI's capabilities to transform and visualize your data effectively. To create powerful and insightful reports and dashboards, you often need to clean and shape your data to make it suitable for analysis. In this piece, we will explore some essential data transformation techniques in Power BI to help you get started on this enriching journey. Enjoy!

###### Topics: [PowerBI](https://www.cittros.com/insights/topic/powerbi) [Reporting tuesdays](https://www.cittros.com/insights/topic/reporting-tuesdays)

###### 2 min read

## [Adding tiles to new workspace](https://www.cittros.com/insights/adding-tiles-to-new-workspace)

 By [Daniela Arsovska](https://www.cittros.com/insights/author/daniela-arsovska) on 22 September 2023

[![](https://www.cittros.com/hubfs/graph-6249046_1280.png) ](https://www.cittros.com/insights/adding-tiles-to-new-workspace)

In our [previous article](https://www.cittros.com/insights/creating-a-workspace-in-d365), we created a new workspace for procurement supervisors. In this article we are going to explain how to add tiles to the workspace. 

###### Topics: [Finance](https://www.cittros.com/insights/topic/finance) [D365FO](https://www.cittros.com/insights/topic/d365fo) [Workspace](https://www.cittros.com/insights/topic/workspace)

###### 3 min read

## [Creating a workspace in D365](https://www.cittros.com/insights/creating-a-workspace-in-d365)

 By [Daniela Arsovska](https://www.cittros.com/insights/author/daniela-arsovska) on 15 September 2023

[![](https://www.cittros.com/hubfs/graph-6249047_1280.png) ](https://www.cittros.com/insights/creating-a-workspace-in-d365)

When collaborating with customers, there is lots and lots of data, which can be complex and confusing. Sometimes it seems impossible to organize them. But there is a way of organizing them in D365 FO. 

###### Topics: [Finance](https://www.cittros.com/insights/topic/finance) [D365FO](https://www.cittros.com/insights/topic/d365fo) [Workspace](https://www.cittros.com/insights/topic/workspace)

###### 3 min read

## [Azure AI services - Machine Learning](https://www.cittros.com/insights/azure-ai-services-machine-learning)

 By [Vera Temkov](https://www.cittros.com/insights/author/vera-temkov) on 12 September 2023

[![](https://www.cittros.com/hubfs/artificial-intelligence-7730758_1280.jpg) ](https://www.cittros.com/insights/azure-ai-services-machine-learning)

Welcome back to our series of blog posts for #AI and the services provided by Microsoft to support artificial intelligence in Azure and Power Platform. In this article, we will delve into the foundation of every artificial intelligence software, Machine learning.

###### Topics: [D365FO](https://www.cittros.com/insights/topic/d365fo) [Azure](https://www.cittros.com/insights/topic/azure) [Reporting tuesdays](https://www.cittros.com/insights/topic/reporting-tuesdays) [Artificial intelligent](https://www.cittros.com/insights/topic/artificial-intelligent) [AI](https://www.cittros.com/insights/topic/ai) [Machine learning](https://www.cittros.com/insights/topic/machine-learning)

###### 3 min read

## [Exploring Dynamics 365's Archive Solution: Optimizing Data Management](https://www.cittros.com/insights/exploring-dynamics-365s-archive-solution-optimizing-data-management)

 By [Gjorgji Penkov](https://www.cittros.com/insights/author/gjorgji-penkov) on 08 September 2023

[![](https://www.cittros.com/hubfs/archive-1850170_1280.jpg) ](https://www.cittros.com/insights/exploring-dynamics-365s-archive-solution-optimizing-data-management)

In the dynamic landscape of finance and operations, the relentless generation of data presents a formidable challenge. Medium to upper-mid-market enterprises, over the course of less than five years, amass an astonishing terabyte of data—a growth trajectory intertwined with a company's age and the annual surge of transactions. 

###### Topics: [D365FO](https://www.cittros.com/insights/topic/d365fo)

###### 4 min read

## [Exploring the New FinancialReportVisual in Power BI for BPA](https://www.cittros.com/insights/exploring-the-new-financialreportvisual-in-power-bi-for-business-performance-analytics)

 By [Mads Bender](https://www.cittros.com/insights/author/mads-bender) on 05 September 2023

[![](https://www.cittros.com/hubfs/Picture2.jpg) ](https://www.cittros.com/insights/exploring-the-new-financialreportvisual-in-power-bi-for-business-performance-analytics)

In this article, we're excited to introduce you to the latest addition to Power BI within [Business Performance Analytics (BPA)](https://www.cittros.com/insights/exploring-business-performance-analytics-bpa-in-d365fo). This new visual, called FinancialReportVisual, is a matrix visualization that show promise to be a powerful tool for both reporting and in-depth exploration of financial data. Let's dive into the details and functionalities of this visual.

###### Topics: [D365FO](https://www.cittros.com/insights/topic/d365fo) [BPA](https://www.cittros.com/insights/topic/bpa) [Business Performance Analytics](https://www.cittros.com/insights/topic/business-performance-analytics) [Reporting tuesdays](https://www.cittros.com/insights/topic/reporting-tuesdays)

###### 2 min read

## [Journal control in Dynamics 365 Finance and operations](https://www.cittros.com/insights/journal-control-in-dynamics-365-finance-and-operations)

 By [Daniela Arsovska](https://www.cittros.com/insights/author/daniela-arsovska) on 01 September 2023

[![](https://www.cittros.com/hubfs/control-3312757_1280.png) ](https://www.cittros.com/insights/journal-control-in-dynamics-365-finance-and-operations)

It can take a long time to correct mistakes that are made when journals are posted in the wrong company or the wrong ledger accounts and dimensions. D365 FO offers a great way to prevent this from happening by using journal control.

###### Topics: [Finance](https://www.cittros.com/insights/topic/finance) [D365FO](https://www.cittros.com/insights/topic/d365fo)

###### 3 min read

## [AI Fundamentals](https://www.cittros.com/insights/ai-fundamentals)

 By [Vera Temkov](https://www.cittros.com/insights/author/vera-temkov) on 29 August 2023

[![](https://www.cittros.com/hubfs/artificial-intelligence-3706562_1920.jpg) ](https://www.cittros.com/insights/ai-fundamentals)

**Understanding the concept of Artificial Intelligence #AI**

Get on board with the revolutionary digital transformation that everyone is talking about - *Artificial Intelligence* *#AI*. In this post we will try to bring this subject closer to the end users by explaining what is #AI and the different concepts that #AI is based on.

###### Topics: [D365FO](https://www.cittros.com/insights/topic/d365fo) [Reporting tuesdays](https://www.cittros.com/insights/topic/reporting-tuesdays) [Artificial intelligent](https://www.cittros.com/insights/topic/artificial-intelligent) [AI](https://www.cittros.com/insights/topic/ai)

###### 2 min read

## [Financial tags for journals](https://www.cittros.com/insights/financial-tags-for-journals)

 By [Clara Seijo Blanque](https://www.cittros.com/insights/author/clara-seijo-blanque) on 25 August 2023

[![](https://www.cittros.com/hubfs/Knowledge%20base/tags-gf712a7b8a_1280.png) ](https://www.cittros.com/insights/financial-tags-for-journals)

A few months ago we [discover ](https://www.cittros.com/insights/financial-tags-discovering)the new functionality included in Microsoft Dynamics 365 Finance, Financial Tags, and as I was expecting this great tool is growing, nice!!

###### Topics: [Finance](https://www.cittros.com/insights/topic/finance) [D365FO](https://www.cittros.com/insights/topic/d365fo)

###### 3 min read

## [Exploring Business Performance Analytics (BPA) in D365FO](https://www.cittros.com/insights/exploring-business-performance-analytics-bpa-in-d365fo)

 By [Mads Bender](https://www.cittros.com/insights/author/mads-bender) on 22 August 2023

[![](https://www.cittros.com/hubfs/Picture2.jpg) ](https://www.cittros.com/insights/exploring-business-performance-analytics-bpa-in-d365fo)

In this post, we will delve into the intriguing realm of Business Performance Analytics (BPA), a promising new feature that holds the potential to revolutionize reporting within D365FO. BPA aims to provide profound insights into various business processes, all within the confines of D365FO. Microsoft has intelligently transformed the application's data into an intuitive dimensional data model, promising an enriching experience for users.

###### Topics: [D365FO](https://www.cittros.com/insights/topic/d365fo) [BPA](https://www.cittros.com/insights/topic/bpa) [Business Performance Analytics](https://www.cittros.com/insights/topic/business-performance-analytics) [Reporting tuesdays](https://www.cittros.com/insights/topic/reporting-tuesdays)

###### 2 min read

## [Assigning any workflow to a position hierarchy](https://www.cittros.com/insights/assigning-any-workflow-to-a-position-hierarchy)

 By [Daniela Arsovska](https://www.cittros.com/insights/author/daniela-arsovska) on 28 July 2023

[![](https://www.cittros.com/hubfs/silhouettes-g767453937_1280.jpg) ](https://www.cittros.com/insights/assigning-any-workflow-to-a-position-hierarchy)

In Microsoft Dynamics 365 Finance, there are multiple ways to setup workflow and sometimes it is confusing which type to use. In our everyday life we have cases where one employee needs to submit, let say his timesheet for approval to a reporting manager, but expense report to a project manager, for the specific project he is working on.

###### Topics: [Finance](https://www.cittros.com/insights/topic/finance) [D365FO](https://www.cittros.com/insights/topic/d365fo) [D365 Supply Chain Management](https://www.cittros.com/insights/topic/d365-supply-chain-management) [Workflows](https://www.cittros.com/insights/topic/workflows)

###### 2 min read

## [Workflow item delegation](https://www.cittros.com/insights/workflow-item-delegation)

 By [Daniela Arsovska](https://www.cittros.com/insights/author/daniela-arsovska) on 21 July 2023

[![](https://www.cittros.com/hubfs/passport-g007054bb8_1280.jpg) ](https://www.cittros.com/insights/workflow-item-delegation)

We are in the period of holidays, but there is still a need to pay invoices and normal business continues. People will therefore be delegating their tasks to other people in this period. Instead of reassigning the whole workflow in D365, which will have a huge impact, you can delegate it to another person while you are on vacation, or you can delegate a workflow on another person’s behalf.

###### Topics: [Finance](https://www.cittros.com/insights/topic/finance) [D365FO](https://www.cittros.com/insights/topic/d365fo) [D365 Supply Chain Management](https://www.cittros.com/insights/topic/d365-supply-chain-management) [Workflows](https://www.cittros.com/insights/topic/workflows)

###### 2 min read

## [How to select the best billing approach](https://www.cittros.com/insights/how-to-select-the-best-billing-approach)

 By [Clara Seijo Blanque](https://www.cittros.com/insights/author/clara-seijo-blanque) on 14 July 2023

[![](https://www.cittros.com/hubfs/2023-06-26_13-57-14.jpg) ](https://www.cittros.com/insights/how-to-select-the-best-billing-approach)

Once you start to define and configure your ERP Microsoft Dynamics 365 Finance, related to customer billing, there are several different options you can use to get a similar result. You can use free text invoices as a simple billing option, sales orders if you manage inventory or even project invoices if you want to control the WIP and revenues.

###### Topics: [Finance](https://www.cittros.com/insights/topic/finance) [D365FO](https://www.cittros.com/insights/topic/d365fo)

###### 1 min read

## [Batch job error after moving to version 10.0.34](https://www.cittros.com/insights/batch-job-error-after-moving-to-version-10.0.34)

 By [Vladimir Danoski](https://www.cittros.com/insights/author/vladimir-danoski) on 12 July 2023

[![](https://www.cittros.com/hubfs/404-error-gb9e78427e_1280.png) ](https://www.cittros.com/insights/batch-job-error-after-moving-to-version-10.0.34)

If you are a customer which is currently moving or planning to move to version 10.0.34 for Dynamics 365 F&O, you might experience the following error on your environments:

###### Topics: [Finance](https://www.cittros.com/insights/topic/finance) [D365FO](https://www.cittros.com/insights/topic/d365fo) [ALM](https://www.cittros.com/insights/topic/alm)

###### 3 min read

## [Automated testing of business processes with RSAT](https://www.cittros.com/insights/automated-testing-of-business-processes-with-rsat)

 By [Daniela Arsovska](https://www.cittros.com/insights/author/daniela-arsovska) on 07 July 2023

[![](https://www.cittros.com/hubfs/factory-g116c065cb_1280.png) ](https://www.cittros.com/insights/automated-testing-of-business-processes-with-rsat)

Regression Suite Automation Tool (RSAT) allows us to automate the validation of business processes in D365 Finance and Operations. The recordings used in RSAT are made with Task Recorder, a tool in D365, and then converted into a suite of automated tests. These automated tests are used for validation of data, elements, and business processes.

###### Topics: [Finance](https://www.cittros.com/insights/topic/finance) [D365FO](https://www.cittros.com/insights/topic/d365fo) [D365 Supply Chain Management](https://www.cittros.com/insights/topic/d365-supply-chain-management) [RSAT](https://www.cittros.com/insights/topic/rsat)

###### 4 min read

## [Credit & collections workspaces](https://www.cittros.com/insights/credit-collections-workspaces)

 By [Clara Seijo Blanque](https://www.cittros.com/insights/author/clara-seijo-blanque) on 30 June 2023

[![](https://www.cittros.com/hubfs/secretary-6613931_1280.jpg) ](https://www.cittros.com/insights/credit-collections-workspaces)

Work with the customer debt and manage all the collections has never been an easy task:  a customer agent usually controls multiple customers and every day execute several calls, emails, notes... related of each one of the invoices and contacted customers. For this reason in Microsoft Dynamics 365 Finance one of the most powerful workspaces is Customer credit and collections that includes all the information related to the customers that the agent control (*customer pool*) in one single place that the clerk can use for the daily work with the ability to do multiple tasks, as example:

###### Topics: [Finance](https://www.cittros.com/insights/topic/finance) [D365FO](https://www.cittros.com/insights/topic/d365fo) [Workspace](https://www.cittros.com/insights/topic/workspace)

###### 2 min read

## [A quick introduction to Microsoft Fabric](https://www.cittros.com/insights/a-quick-introduction-to-microsoft-fabric)

 By [Mads Bender](https://www.cittros.com/insights/author/mads-bender) on 27 June 2023

[![](https://www.cittros.com/hubfs/image1.jpg) ](https://www.cittros.com/insights/a-quick-introduction-to-microsoft-fabric)

Welcome back to a new Reporting Tuesday blog post, where we explore Microsoft Fabric—a platform that has the potential to take your data processing to the next level. 

###### Topics: [D365FO](https://www.cittros.com/insights/topic/d365fo) [PowerBI](https://www.cittros.com/insights/topic/powerbi) [Fabric](https://www.cittros.com/insights/topic/fabric)

###### 2 min read

## [Product variants... finally with their own sales tax groups!!](https://www.cittros.com/insights/product-variants...-finally-with-their-own-sales-tax-groups)

 By [Clara Seijo Blanque](https://www.cittros.com/insights/author/clara-seijo-blanque) on 23 June 2023

[![](https://www.cittros.com/hubfs/t-shirt-181707_1280.png) ](https://www.cittros.com/insights/product-variants...-finally-with-their-own-sales-tax-groups)

The use of product variants in Microsoft Dynamics 365 Finance is a must for some business' where the same product can have multiple sizes, colors, configurations... because you need to create a Product Master and assign a Product dimension group with all the options available for the product without creating the same product multiple times.

###### Topics: [Finance](https://www.cittros.com/insights/topic/finance) [D365FO](https://www.cittros.com/insights/topic/d365fo) [D365 Commerce](https://www.cittros.com/insights/topic/d365-commerce) [D365 Supply Chain Management](https://www.cittros.com/insights/topic/d365-supply-chain-management) [Retail](https://www.cittros.com/insights/topic/retail)

###### 3 min read

## [Subscription billing (part 3)](https://www.cittros.com/insights/subscription-billing-part-3)

 By [Clara Seijo Blanque](https://www.cittros.com/insights/author/clara-seijo-blanque) on 16 June 2023

[![](https://www.cittros.com/hubfs/project-management-7446587_1280.jpg) ](https://www.cittros.com/insights/subscription-billing-part-3)

Subscription billing is a relatively new feature in Microsoft Dynamics 365 Finance and is a separate module, which also covers the old Revenue recognition module.  This module is really powerful for all types of subscriptions scenarios as we explained in this [overview ](https://www.cittros.com/insights/subscription-billing-part-1)and [example](https://www.cittros.com/insights/subscription-billingpart-2), but as we were expecting and really looking for, since the version 10.0.32 the new Subscription billing module is linked to the Project management and accounting. Finally the circle is closed, fantastic!!! 😍😍

###### Topics: [Finance](https://www.cittros.com/insights/topic/finance) [D365FO](https://www.cittros.com/insights/topic/d365fo)

###### 3 min read

## [How to use & Ampersand in your number sequence](https://www.cittros.com/insights/how-to-use-ampersand-in-your-number-sequence)

 By [Mads Bender](https://www.cittros.com/insights/author/mads-bender) on 02 June 2023

[![](https://www.cittros.com/hubfs/pay-gf34206d73_1920.jpg) ](https://www.cittros.com/insights/how-to-use-ampersand-in-your-number-sequence)

This post will explore the setup of number sequence in Dynamics 365 (D365), and how to use Ampersand (&) in the setup of a number sequence in D365 and its limitations. First, we will delve into what number sequences are and why they are important in D365.

###### Topics: [Finance](https://www.cittros.com/insights/topic/finance) [D365FO](https://www.cittros.com/insights/topic/d365fo)

###### 4 min read

## [Exploring the Key Influencers visual](https://www.cittros.com/insights/exploring-the-key-influencers-visual)

 By [Mads Bender](https://www.cittros.com/insights/author/mads-bender) on 30 May 2023

[![](https://www.cittros.com/hubfs/computer-g4931b0c8a_1280.jpg) ](https://www.cittros.com/insights/exploring-the-key-influencers-visual)

Welcome back to a new Reporting Tuesday blog post, in this post we will explore the Key Influencers visual. This is exciting because it allows you to rapidly find statistical trends in your data. Enjoy! 

###### Topics: [D365FO](https://www.cittros.com/insights/topic/d365fo) [PowerBI](https://www.cittros.com/insights/topic/powerbi)

###### 12 min read

## [Financial tags - discovering](https://www.cittros.com/insights/financial-tags-discovering)

 By [Clara Seijo Blanque](https://www.cittros.com/insights/author/clara-seijo-blanque) on 26 May 2023

[![](https://www.cittros.com/hubfs/tags-gf712a7b8a_1280.png) ](https://www.cittros.com/insights/financial-tags-discovering)

I love to check the every month the [What's new in Dynamics 365 Finance ](https://learn.microsoft.com/en-us/dynamics365/finance/get-started/whats-new-home-page)to review the new features, modules and changes that Microsoft applies to the ERP, an one of the most expecting ones this year has been the Financial tags. I read several posts and articles about it, all super interesting and really promising, because it can be used in the financial reporting as a complement for the financial dimensions (my passion...) but you can edit the values after transactions are posted what it's not possible with the dimensions. If you want to learn more, you can check all the difference between the tags and dimensions in this [link. ](https://learn.microsoft.com/en-us/dynamics365/finance/general-ledger/financial-tag-financial-dimension)

###### Topics: [Finance](https://www.cittros.com/insights/topic/finance) [D365FO](https://www.cittros.com/insights/topic/d365fo)

###### 2 min read

## [Application Insights in Dynamics 365 for Finance and Operations](https://www.cittros.com/insights/application-insights-in-dynamics-365-for-finance-and-operations)

 By [Vladimir Danoski](https://www.cittros.com/insights/author/vladimir-danoski) on 19 May 2023

[![](https://www.cittros.com/hubfs/speed-g028fdc5cd_1920.jpg) ](https://www.cittros.com/insights/application-insights-in-dynamics-365-for-finance-and-operations)

Application Insights is an extension of [Azure Monitor](https://learn.microsoft.com/en-us/azure/azure-monitor/overview) and provides application performance monitoring (APM) features. APM tools are useful to monitor applications from development, through test, and into production in the following ways:

###### Topics: [D365FO](https://www.cittros.com/insights/topic/d365fo) [Azure](https://www.cittros.com/insights/topic/azure)

###### 3 min read

## [Introduction to Smart Narrative in Power BI](https://www.cittros.com/insights/introduction-to-smart-narrative-in-power-bi)

 By [Mads Bender](https://www.cittros.com/insights/author/mads-bender) on 16 May 2023

[![](https://www.cittros.com/hubfs/online-gc9bc7e3ca_1280.jpg) ](https://www.cittros.com/insights/introduction-to-smart-narrative-in-power-bi)

Welcome back to a new Reporting Tuesday blog post, in this post we will explore Smart Narrative in Power BI. This is exciting because Smart Narrative provides a quick interpretation of your data that you can share with others. It can help you make sense of complex information and explain it in a way that everyone can understand. Enjoy! 

###### Topics: [D365FO](https://www.cittros.com/insights/topic/d365fo) [PowerBI](https://www.cittros.com/insights/topic/powerbi)

###### 1 min read

## [Extensible controls in D365 for Finance](https://www.cittros.com/insights/extensible-controls-in-d365-for-finance)

 By [Vera Temkov](https://www.cittros.com/insights/author/vera-temkov) on 12 May 2023

[![](https://www.cittros.com/hubfs/smartphone-g8c2d73bc4_1280.jpg) ](https://www.cittros.com/insights/extensible-controls-in-d365-for-finance)

D365 for Finance can represent data in many ways, such as in tables or charts. But sometimes customer wishes more specific user interface for certain processes, or we have a business requirement to be achieved in a certain way.

###### Topics: [D365FO](https://www.cittros.com/insights/topic/d365fo)

###### 3 min read

## [Close a period for posting in D365 Finance](https://www.cittros.com/insights/close-a-period-for-posting-in-d365-finance)

 By [Cittros team](https://www.cittros.com/insights/author/cittros-team) on 05 May 2023

[![](https://www.cittros.com/hubfs/CLEAN-images/heros/password-bg.jpg) ](https://www.cittros.com/insights/close-a-period-for-posting-in-d365-finance)

After a month closing is recommended to set the ledger period to On hold, so that no further posting occurs. This is also recommended for previous year periods and future periods.

###### Topics: [Finance](https://www.cittros.com/insights/topic/finance) [D365FO](https://www.cittros.com/insights/topic/d365fo)

###### 4 min read

## [Create a Navigation/Filter bar in Power BI](https://www.cittros.com/insights/create-a-navigation/filter-bar-in-power-bi)

 By [Mads Bender](https://www.cittros.com/insights/author/mads-bender) on 02 May 2023

[![](https://www.cittros.com/hubfs/analysis-g9bcff8e96_1280.jpg) ](https://www.cittros.com/insights/create-a-navigation/filter-bar-in-power-bi)

Welcome back to a new Reporting Tuesday blog post, in this post we will explore how to create a navigation bar in Power BI. This is exciting because it allows you to add user interface to your reports without losing reporting area. Enjoy! 

###### Topics: [D365FO](https://www.cittros.com/insights/topic/d365fo) [PowerBI](https://www.cittros.com/insights/topic/powerbi)

###### 3 min read

## [Excel workbook designer](https://www.cittros.com/insights/excel-workbook-designer)

 By [Clara Seijo Blanque](https://www.cittros.com/insights/author/clara-seijo-blanque) on 28 April 2023

[![](https://www.cittros.com/hubfs/excel-g279c626d5_1280.jpg) ](https://www.cittros.com/insights/excel-workbook-designer)

The total integration with Excel for Dynamics 365 Finance is one is the powerful tools that as user, consultant or technical we can use. I think it's amazing but, are you really using all the possibilities that the system offers? I wasn't until I read this great article [Make your own Open in Excel Designer.](https://msdynamicmillennial.wordpress.com/2023/02/11/make-your-own-open-in-excel-designer/)

Since I read about this, I'm using it as much as I can, maybe too much 😅 but I'm really impress. Let me show you the step by step with one example:

###### 3 min read

## [Vendor postings reconciliation](https://www.cittros.com/insights/vendor-postings-reconciliation)

 By [Clara Seijo Blanque](https://www.cittros.com/insights/author/clara-seijo-blanque) on 21 April 2023

[![](https://www.cittros.com/hubfs/puzzle-g7d25a57b1_640.png) ](https://www.cittros.com/insights/vendor-postings-reconciliation)

Vendor ledger accounts in Dynamics 365 Finance are based on the "Posting profiles" that determine the balance account where the transaction, based on the type of movement and vendor group, is posted.

###### Topics: [Finance](https://www.cittros.com/insights/topic/finance) [D365FO](https://www.cittros.com/insights/topic/d365fo)

###### 6 min read

## [Combine multiple web sources to one dataset](https://www.cittros.com/insights/combine-multiple-web-sources-to-one-dataset)

 By [Mads Bender](https://www.cittros.com/insights/author/mads-bender) on 18 April 2023

[![](https://www.cittros.com/hubfs/browser-gc944b8476_1280.png) ](https://www.cittros.com/insights/combine-multiple-web-sources-to-one-dataset)

Welcome back to a new Reporting Tuesday blog post, in this post we will explore how to combine multiple web sources to one dataset in Power query. This is exciting because it allows you to mark comprehensive datasets using web sources. Enjoy! 

In this blog post we are going to look at how to make a dataset in excel power query that combines data from multiple web sources. For this specifically we will look at how to get data from several stocks into excel and return it to one table. 

Here when we talk about a web source, we refer to a source of data that can be accessed over the internet using a web browser or a programming language. Web sources can include websites, databases, and other online resources that provide data in a structured format, such as HTML, XML, or JSON. For this we will make a list of stocks to track and retrieve the data from yahoo finance. 

First, we need to open a new excel document, and make a table with the following column headers: Ticker name, From, To, Interval, URL_hist, URL_summary and months of data. These will be used to collect data, and with proper setup you only need to fill in the ticker and the rest is done by formulars. 

This is how we will fill in the table:

###### Topics: [D365FO](https://www.cittros.com/insights/topic/d365fo) [PowerBI](https://www.cittros.com/insights/topic/powerbi)

###### 3 min read

## [It's possible to update a voucher. Yes! But only The description](https://www.cittros.com/insights/its-possible-to-update-a-voucher-yes-the-internal-data)

 By [Clara Seijo Blanque](https://www.cittros.com/insights/author/clara-seijo-blanque) on 14 April 2023

[![](https://www.cittros.com/hubfs/impossible-g27eb1a946_1280.jpg) ](https://www.cittros.com/insights/its-possible-to-update-a-voucher-yes-the-internal-data)

How many times you experience, hear and read about "*once you post a journal in Dynamics 365 Finance, it's not possible to change it or deleted, you need to post a voucher to reverse the entry*"?? As a user this can generates a lot frustration and more when the data you need to change is internal, for example the voucher description. 

###### Topics: [Finance](https://www.cittros.com/insights/topic/finance) [D365FO](https://www.cittros.com/insights/topic/d365fo)

###### 6 min read

## [Financial reports – View and export](https://www.cittros.com/insights/financial-reports-view-and-export)

 By [Inga Numadottir](https://www.cittros.com/insights/author/inga-numadottir) on 07 April 2023

[![](https://www.cittros.com/hubfs/frontimage.jpg) ](https://www.cittros.com/insights/financial-reports-view-and-export)

Financial reports are now an integrated feature of D365FO.The creation of reports is flexible and can include different hierarchiesof companies, which enables a view across companies.Once the reports are generated, the user can view the reports in different ways, as well as drill into the details, publish, print, and export. This article will focus on the options for export to Excel.

###### Topics: [Finance](https://www.cittros.com/insights/topic/finance) [D365FO](https://www.cittros.com/insights/topic/d365fo) [Reporting](https://www.cittros.com/insights/topic/reporting)

###### 4 min read

## [Create custom toggle buttons in power BI](https://www.cittros.com/insights/create-custom-toggle-buttons-in-power-bi)

 By [Mads Bender](https://www.cittros.com/insights/author/mads-bender) on 04 April 2023

[![](https://www.cittros.com/hubfs/powerbi5.jpg) ](https://www.cittros.com/insights/create-custom-toggle-buttons-in-power-bi)

Power BI is a very powerful tool, however making a report that looks clean and still have usability in center can be difficult. In this article we will look at the possibility for using toggle buttons to help keep a report clean and simple, and still pack advanced features into it.

###### 5 min read

## [Fixed assets – Depreciation across companies](https://www.cittros.com/insights/fixed-assets-depreciation-across-companies)

 By [Inga Numadottir](https://www.cittros.com/insights/author/inga-numadottir) on 31 March 2023

[![](https://www.cittros.com/hubfs/hourglass-g859794acc_1280%20(1).jpg) ](https://www.cittros.com/insights/fixed-assets-depreciation-across-companies)

When managing multiple companies, monthly tasks such as depreciation can take time. D365FO enables depreciation across multiple companies. This feature can be setup to run in batch every month, if wanted. It is also possible to add workflow and post the journals automatically once generated. This article will walk through how to configure and run depreciation across companies. 

###### Topics: [Finance](https://www.cittros.com/insights/topic/finance) [D365FO](https://www.cittros.com/insights/topic/d365fo)

###### 1 min read

## [Retail ERP excellence delivered by Cittros](https://www.cittros.com/insights/retail-erp-excellence-delivered-by-cittros)

 By [Cittros team](https://www.cittros.com/insights/author/cittros-team) on 24 March 2023

[![](https://www.cittros.com/hubfs/victor-garcia-UoIiVYka3VY-unsplash.jpeg) ](https://www.cittros.com/insights/retail-erp-excellence-delivered-by-cittros)

Microsoft Dynamics Retail (now Dynamics 365 Commerce) is the ERP solution that offers retailers the efficiency and flexibility they need. It delivers a fully integrated, mobile-optimized, omni-channel shopping experience. From point-of-sale (POS) store operations, merchandising, e-commerce, and marketing to customer care, supply chain, and financials, the modular solution can meet the needs of virtually any size retail business.

###### Topics: [Insider](https://www.cittros.com/insights/topic/insider) [D365FO](https://www.cittros.com/insights/topic/d365fo) [D365 Commerce](https://www.cittros.com/insights/topic/d365-commerce) [Retail](https://www.cittros.com/insights/topic/retail)

###### 5 min read

## [Create buttons in Power BI](https://www.cittros.com/insights/create-buttons-in-power-bi)

 By [Mads Bender](https://www.cittros.com/insights/author/mads-bender) on 21 March 2023

[![](https://www.cittros.com/hubfs/accountant-g35c350232_1280.png) ](https://www.cittros.com/insights/create-buttons-in-power-bi)

Welcome back to a new Reporting Tuesday blog post, in this post we will explore the creation of buttons in Power BI. This is exciting because buttons make your Power BI reports more interactive and give your users more control over what they see. Enjoy! 

###### Topics: [D365FO](https://www.cittros.com/insights/topic/d365fo) [PowerBI](https://www.cittros.com/insights/topic/powerbi)

###### 2 min read

## [Period close – why use it?](https://www.cittros.com/insights/period-close-why-use-it)

 By [Inga Numadottir](https://www.cittros.com/insights/author/inga-numadottir) on 17 March 2023

[![](https://www.cittros.com/hubfs/calendar-g17788cdd4_1280.jpg) ](https://www.cittros.com/insights/period-close-why-use-it)

Periodcloseis an integrated part of General ledger. This used to be a separate module, but has been moved to General Ledger. This feature will help you keep track of all tasks that are related to closing a period. No matter if it is month, quarterly or year-end close, this feature can help reduce the number of days it takes to close periods. The setup is a one time and can then be copied to the next period.

###### Topics: [Finance](https://www.cittros.com/insights/topic/finance) [D365FO](https://www.cittros.com/insights/topic/d365fo)

###### 7 min read

## [Prepayments](https://www.cittros.com/insights/prepayments)

 By [Inga Numadottir](https://www.cittros.com/insights/author/inga-numadottir) on 10 March 2023

[![](https://www.cittros.com/hubfs/money-gc2496a617_1280.png) ](https://www.cittros.com/insights/prepayments)

Prepayment is a great feature in D365FO, but often customers and even partners are not aware of this feature. Prepayments are typically used when buyingabroad, where prepayments are required. In this article we will go through the prepayment in connection with the purchase order.This minimizes the risk of double paying vendor. 

###### Topics: [Finance](https://www.cittros.com/insights/topic/finance) [D365FO](https://www.cittros.com/insights/topic/d365fo)

###### 5 min read

## [Working with bookmarks in Power BI](https://www.cittros.com/insights/working-with-bookmarks-in-power-bi)

 By [Mads Bender](https://www.cittros.com/insights/author/mads-bender) on 07 March 2023

[![](https://www.cittros.com/hubfs/organizer-g88239421a_1280.png) ](https://www.cittros.com/insights/working-with-bookmarks-in-power-bi)

Welcome back to a new Reporting Tuesday blog post, in this post we will explore bookmarks in Power BI. This is exciting because bookmarks are a great way to quickly access different parts or views of a report in Power BI. They can save you a lot of time and make it easier to explore and understand your data. Enjoy! 

###### Topics: [D365FO](https://www.cittros.com/insights/topic/d365fo) [PowerBI](https://www.cittros.com/insights/topic/powerbi)

###### 1 min read

## [ERP solution implementations: the solution architecture phase](https://www.cittros.com/insights/erp-solution-implementations-the-solution-architecture-phase-1)

 By [Cittros team](https://www.cittros.com/insights/author/cittros-team) on 03 March 2023

[![](https://www.cittros.com/hubfs/alain-pham-P_qvsF7Yodw-unsplash.jpg) ](https://www.cittros.com/insights/erp-solution-implementations-the-solution-architecture-phase-1)

The architect role in an ERP implementation ensures that the overall process is on track and that the strategy laid out by top-level decision makers is followed at all levels of the organization. Thus, Cittros architects work with the finance and functional decision makers in your organization to provide both strategic and operational insights and advice.

###### Topics: [Insider](https://www.cittros.com/insights/topic/insider) [D365FO](https://www.cittros.com/insights/topic/d365fo)

###### 10 min read

## [Currency types in D365 Finance](https://www.cittros.com/insights/currency-types-in-d365-finance)

 By [Cittros team](https://www.cittros.com/insights/author/cittros-team) on 24 February 2023

[![](https://www.cittros.com/hubfs/currency-g883ffc335_1280.png) ](https://www.cittros.com/insights/currency-types-in-d365-finance)

One of the first and most important steps of implementing Dynamics 365 Finance is currency setup for accounting and reporting currency. Let's understand the use and setup options.

###### Topics: [Finance](https://www.cittros.com/insights/topic/finance) [D365FO](https://www.cittros.com/insights/topic/d365fo)

###### 6 min read

## [Power BI web sources Part 3 – Partner API and python](https://www.cittros.com/insights/power-bi-web-sources-part-3-partner-api-and-python)

 By [Mads Bender](https://www.cittros.com/insights/author/mads-bender) on 21 February 2023

[![](https://www.cittros.com/hubfs/powerbi5.jpg) ](https://www.cittros.com/insights/power-bi-web-sources-part-3-partner-api-and-python)

For this third part of Power BI Web sources, we will explore the use of Partner API in Power BI. This can be done in multiple ways;however, you must add code to your solution. Since, this relies on code no matter what I want to take this opportunity to combine Power BI with python query. Doing this demands that you have a python client installed on the computer and that you have installed the libraries Requests and Pandas.

###### Topics: [PowerBI](https://www.cittros.com/insights/topic/powerbi)

###### 1 min read

## [The importance of ERP solution enablement](https://www.cittros.com/insights/the-importance-of-erp-solution-enablement)

 By [Cittros team](https://www.cittros.com/insights/author/cittros-team) on 17 February 2023

[![](https://www.cittros.com/hubfs/victor-garcia-2PJMDIgK9EA-unsplash.jpeg) ](https://www.cittros.com/insights/the-importance-of-erp-solution-enablement)

An important, but often overlooked part of incorporating new IT solutions in an organization is user readiness and adoption of the new solution. Whether you are moving to an entirely new ERP system or going through a Dynamics AX/D365 version upgrade, having a well-defined plan for preparing, training and enabling users is essential to a successful solution adoption.

###### Topics: [Insider](https://www.cittros.com/insights/topic/insider) [D365FO](https://www.cittros.com/insights/topic/d365fo)

###### 6 min read

## [Cittros Task Recordings Tricks and Tips!](https://www.cittros.com/insights/cittros-tricks-and-tips)

 By [Cittros team](https://www.cittros.com/insights/author/cittros-team) on 10 February 2023

[![](https://www.cittros.com/hubfs/CLEAN-images/heros/sub-pref-bg.jpg) ](https://www.cittros.com/insights/cittros-tricks-and-tips)

We will share the most useful tricks and tips that you can take advantage of within Dynamics AX or D365FO.

This guide provides instructions on how to ensure that your implementation project provides the necessary input for any subsequent automated regression test as part of the on-going continuous updates of D365 One Version.

Prior to any automated regression testing, the following manually elements needs to be in place and approved as part of a go-live quality assurance process.

###### 3 min read

## [Power BI web sources Part 2 – API](https://www.cittros.com/insights/power-bi-web-sources-part-2-api)

 By [Mads Bender](https://www.cittros.com/insights/author/mads-bender) on 07 February 2023

[![](https://www.cittros.com/hubfs/powerbi5.jpg) ](https://www.cittros.com/insights/power-bi-web-sources-part-2-api)

In the [first part](https://www.cittros.com/insights/power-bi-web-sources-part-1-web-pages?hs_preview=VuemPZbN-95346042964) we looked at how to extract Stock data for Microsoft using Yahoo Finance. Yahoo Finance used to have their own API, today you can find third party APIs. However, because I want to go into the logic of an API, we will change to a different data set. First, we will look at covid tracking, that is an opensource dataset, and the process is exactly as we saw it from yahoo finance. 

###### Topics: [D365FO](https://www.cittros.com/insights/topic/d365fo) [PowerBI](https://www.cittros.com/insights/topic/powerbi)

###### 4 min read

## [Financial reports – using default reports](https://www.cittros.com/insights/financial-reports-using-default-reports)

 By [Inga Numadottir](https://www.cittros.com/insights/author/inga-numadottir) on 03 February 2023

[![](https://www.cittros.com/hubfs/businessman-g0d1399743_1280.jpg) ](https://www.cittros.com/insights/financial-reports-using-default-reports)

Financial reports are now an integrated feature of D365FO.The creation of reports is flexible and can include different hierarchiesof companies, which enables a view across companies. There are multiple default reports delivered with D365FO.The following will provide an overview to enable you to start using these default financial reports in D365.

###### Topics: [Finance](https://www.cittros.com/insights/topic/finance) [D365FO](https://www.cittros.com/insights/topic/d365fo) [Reporting](https://www.cittros.com/insights/topic/reporting)

###### 4 min read

## [Working with data on sharepoint](https://www.cittros.com/insights/working-with-data-on-sharepoint)

 By [Mads Bender](https://www.cittros.com/insights/author/mads-bender) on 27 January 2023

[![](https://www.cittros.com/hubfs/consulting-g7205d070d_1920.png) ](https://www.cittros.com/insights/working-with-data-on-sharepoint)

Personal experience working with data in larger projects with SharePoint.

More and more of our daily operation centers on data, and the aspect of sharing data is of great value. As a business professional you most likely use Microsoft office problems in your daily operations, and if you work on projects, you are likely to also use SharePoint to manage the sharing of documents.

###### 4 min read

## [Power BI web sources Part 1 – Web pages](https://www.cittros.com/insights/power-bi-web-sources-part-1-web-pages)

 By [Mads Bender](https://www.cittros.com/insights/author/mads-bender) on 24 January 2023

[![](https://www.cittros.com/hubfs/powerbi5.jpg) ](https://www.cittros.com/insights/power-bi-web-sources-part-1-web-pages)

Web scraping and using data from the internet open a whole new aspect of analysis. This open the option for adding real time data to your reports, web-based data sources can be either APIs or source code for a webpage.

###### 10 min read

## [Subscription billing (part 2)](https://www.cittros.com/insights/subscription-billingpart-2)

 By [Inga Numadottir](https://www.cittros.com/insights/author/inga-numadottir) on 20 January 2023

[![](https://www.cittros.com/hubfs/filing-cabinet-gc040baaea_1280.jpg) ](https://www.cittros.com/insights/subscription-billingpart-2)

Subscription billing is a relatively new feature in D365FO and is a separatemodule, which also covers the old revenue recognition module. This module is really powerful for all types of subscriptions scenarios.This document covers just a simple example of using the Subscription billing. You can see an overview of scenarios in [previous](https://www.cittros.com/insights/subscription-billing-part-1)[ article](https://www.cittros.com/insights/subscription-billing-part-1). 

###### Topics: [Finance](https://www.cittros.com/insights/topic/finance) [D365FO](https://www.cittros.com/insights/topic/d365fo)

###### 3 min read

## [Subscription billing (part 1)](https://www.cittros.com/insights/subscription-billing-part-1)

 By [Inga Numadottir](https://www.cittros.com/insights/author/inga-numadottir) on 13 January 2023

[![](https://www.cittros.com/hubfs/subscribe-gb385324d8_1280.png) ](https://www.cittros.com/insights/subscription-billing-part-1)

Subscription billing is a relatively new feature in D365FO and is a separate module, which also covers the old revenue recognition module. There are now multiple scenarios covered in Subscription billing and more scenarios will be added in near future. The subscription economy has exploded in the last years with growing need to manage subscription unique demands. This document provides a quick overview of the new subscription module.

###### Topics: [Finance](https://www.cittros.com/insights/topic/finance) [D365FO](https://www.cittros.com/insights/topic/d365fo)

###### 2 min read

## [Transform data in Power BI](https://www.cittros.com/insights/transform-data-in-power-bi)

 By [Mads Bender](https://www.cittros.com/insights/author/mads-bender) on 10 January 2023

[![](https://www.cittros.com/hubfs/powerbi5.jpg) ](https://www.cittros.com/insights/transform-data-in-power-bi)

After loading data to Power BI, you have the option to transform the data, for some queries you might not use this at all and for other you might use it extensively. One of the things you can do here is to normalize a data source. You can duplicate a query and then remove redundant data to decrease the size of you report. It is also possible to add calculated columns, let say you have the value in local currency and the exchange rate to your reporting currency. Then you can make an extra column with the value in reporting currency.

###### Topics: [D365FO](https://www.cittros.com/insights/topic/d365fo) [PowerBI](https://www.cittros.com/insights/topic/powerbi)

###### 2 min read

## [Auditors Reports for Fixed Assets in D365 Finance](https://www.cittros.com/insights/auditors-reports-for-fixed-assets-in-d365-finance)

 By [Clara Seijo Blanque](https://www.cittros.com/insights/author/clara-seijo-blanque) on 06 January 2023

[![](https://www.cittros.com/hubfs/image-png-Jan-03-2023-02-26-20-2258-PM.png) ](https://www.cittros.com/insights/auditors-reports-for-fixed-assets-in-d365-finance)

In the previous [post ](https://www.cittros.com/insights/auditors-reports-in-d365-finance)we saw how to obtain reports for general ledger directly in Excel from D365 Finance using the reports defined as Electronic Reports. In the Fixed Asset module, we have similar reports that can be used for the year end close or the auditors´ requirements.  Obtain these reports can save a lot of manual preparation because the reports include all the key information about the fixed asset transactions and their status.

###### Topics: [Finance](https://www.cittros.com/insights/topic/finance) [D365FO](https://www.cittros.com/insights/topic/d365fo) [Reporting](https://www.cittros.com/insights/topic/reporting)

###### 2 min read

## [Power BI: my first impressions](https://www.cittros.com/insights/power-bi-my-first-impressions)

 By [Mads Bender](https://www.cittros.com/insights/author/mads-bender) on 27 December 2022

[![](https://www.cittros.com/hubfs/powerbi5.jpg) ](https://www.cittros.com/insights/power-bi-my-first-impressions)

Most people today know of or have heard of Power BI. Power BI is a simple software and with limited introduction you will be able to produce meaningful reports. It is then possible to dive deeper into the software and create very complex and beautiful reports, again with limited effort. This is one of the things I really enjoy with Power BI. It is an extremely powerful visualization tool.

###### Topics: [D365FO](https://www.cittros.com/insights/topic/d365fo) [PowerBI](https://www.cittros.com/insights/topic/powerbi)

###### 3 min read

## [Modify a form in D365 Finance for multiple users](https://www.cittros.com/insights/modify-a-form-in-d365-finance-for-multiple-users)

 By [Cittros team](https://www.cittros.com/insights/author/cittros-team) on 16 December 2022

[![](https://www.cittros.com/hubfs/CLEAN-images/heros/careers-bg.jpg) ](https://www.cittros.com/insights/modify-a-form-in-d365-finance-for-multiple-users)

In D365 Finance it’s possible to define mandatory fields for all the users in an existing form without development required, for example, for the users that will create vendors in the vendor master, modify the form to have all the required fields defined as mandatory by default to avoid errors and missing information.

###### Topics: [Finance](https://www.cittros.com/insights/topic/finance) [D365FO](https://www.cittros.com/insights/topic/d365fo)

###### 4 min read

## [Introduction to Power BI](https://www.cittros.com/insights/introduction-to-power-bi)

 By [Mads Bender](https://www.cittros.com/insights/author/mads-bender) on 13 December 2022

[![](https://www.cittros.com/hubfs/powerbi5.jpg) ](https://www.cittros.com/insights/introduction-to-power-bi)

Power BI is built up with a similar layout to Microsoft other products and when you open a power BI desktop session you will have the following 7 modules:

###### Topics: [D365FO](https://www.cittros.com/insights/topic/d365fo) [PowerBI](https://www.cittros.com/insights/topic/powerbi)

###### 1 min read

## [ERP solutions for the professional services industry](https://www.cittros.com/insights/erp-solutions-for-the-professional-services-industry)

 By [Cittros team](https://www.cittros.com/insights/author/cittros-team) on 09 December 2022

[![](https://www.cittros.com/hubfs/hector-j-rivas-1FxMET2U5dU-unsplash.jpg) ](https://www.cittros.com/insights/erp-solutions-for-the-professional-services-industry)

Cittros has a long-standing focus on the professional services industry. Our team understands the requirements of professional services organizations and the environment in which they operate, allowing us to deliver significant value to your business.

###### Topics: [Insider](https://www.cittros.com/insights/topic/insider)

###### 2 min read

## [The importance of performance optimization, health checks and governance audits](https://www.cittros.com/insights/the-importance-of-performance-optimization-health-checks-and-governance-audits)

 By [Cittros team](https://www.cittros.com/insights/author/cittros-team) on 02 December 2022

[![](https://www.cittros.com/hubfs/hush-naidoo-yo01Z-9HQAw-unsplash.jpg) ](https://www.cittros.com/insights/the-importance-of-performance-optimization-health-checks-and-governance-audits)

##### Why you should invest in solution audits

Cittros performs solution governance and performance reviews on behalf of Microsoft and directly for Microsoft Dynamics AX/D365 ERP clients.

###### Topics: [Insider](https://www.cittros.com/insights/topic/insider)

###### 5 min read

## [Create a Power BI report using D365FO data from Azure Data Lake](https://www.cittros.com/insights/create-a-power-bi-report-using-d365fo-data-from-azure-data-lake)

 By [Mads Bender](https://www.cittros.com/insights/author/mads-bender) on 29 November 2022

[![](https://www.cittros.com/hubfs/powerbi5.jpg) ](https://www.cittros.com/insights/create-a-power-bi-report-using-d365fo-data-from-azure-data-lake)

Power BI is one of the biggest and most popular BI tools today and it is a central part of many companies’ business intelligence toolbox. Therefore, it is essential to integrate your ERP solution with your Power BI. This post will explore the method for retrieving D365FO data from Azure Data Lake.

###### Topics: [D365FO](https://www.cittros.com/insights/topic/d365fo) [PowerBI](https://www.cittros.com/insights/topic/powerbi) [Azure](https://www.cittros.com/insights/topic/azure)

###### 4 min read

## [Auditors Reports in D365 Finance](https://www.cittros.com/insights/auditors-reports-in-d365-finance)

 By [Clara Seijo Blanque](https://www.cittros.com/insights/author/clara-seijo-blanque) on 25 November 2022

[![](https://www.cittros.com/hubfs/CLEAN-images/photos/team-working.jpg) ](https://www.cittros.com/insights/auditors-reports-in-d365-finance)

We can generate from D365 Finance some standard reports really useful, printed in Excel with the required format for using during the month closing and even generate it for the internal audits.

There are two key reports in General Ledger that I recommend you configure and use it for your month closing or daily validations, let's see the details about the required setup and how to generate it.

###### Topics: [Finance](https://www.cittros.com/insights/topic/finance) [D365FO](https://www.cittros.com/insights/topic/d365fo) [Reporting](https://www.cittros.com/insights/topic/reporting)

###### 1 min read

## [Maximize the potential of your ERP solution](https://www.cittros.com/insights/maximize-the-potential-of-your-erp-solution)

 By [Cittros team](https://www.cittros.com/insights/author/cittros-team) on 18 November 2022

[![](https://www.cittros.com/hubfs/sean-pollock-PhYq704ffdA-unsplash.jpg) ](https://www.cittros.com/insights/maximize-the-potential-of-your-erp-solution)

Today, Microsoft Dynamics AX and D365 are gaining a continuously larger share in the ERP market for large, international enterprises. The complexity of implementing a new ERP system or upgrading an older version of Microsoft Dynamics in such multi-country organizations is not a challenge to be taken lightly. Although AX/D365 provides the functionality, stability and flexibility to support large enterprises, without having the right team, cost estimate, and time-to-deployment, the entire implementation process can quickly spin out of control.

###### Topics: [Insider](https://www.cittros.com/insights/topic/insider)

###### 1 min read

## [Adapting to change with Azure DevOps](https://www.cittros.com/insights/adapting-to-change-with-azure-devops)

 By [Anja Hilt](https://www.cittros.com/insights/author/anja-hilt) on 15 September 2020

[![](https://www.cittros.com/hubfs/ADO%20Board.jpg) ](https://www.cittros.com/insights/adapting-to-change-with-azure-devops)

Working within the area of business applications, such as Microsoft D365, keeps you on your toes all the time. New versions, multiple new features, unpredictable market changes year after year. On top of all these challenges, new approaches and methodologies emerge to challenge us as Microsoft solution partners on how we deliver the best solution for our customers. At Cittros, we constantly adapt to changes as well.

The latest wave of changes in managing D365 implementation projects, builds on concepts from lean-agile frameworks. In the world of Microsoft and D365, this typically means using Azure DevOps to manage the continuous stream of new features, like Power BI, Common Data Storage and new updates versions, dual-write, etc. We, at Cittros are still focused on our customers’ requirements. We keep the solution as closely tied in with the latest version from Microsoft, ensuring that no opportunities are missed – but also that no unnecessary hurdles are introduced. Azure DevOps serves as a tool and a way of working when we track progress on our joint journey. Leaving you to focus on how your organization adapt to future business processes and deliver on promise.

We put our long experience of working within Finance, Retail, Warehouse Management and Supply Chain into the equation as we move along. Using an approach for continuous deliveries and improvements we stay flexible, yet predictable. We have wrapped it up in a tailored, lean-agile approach to ensure a high-quality, continuous delivery. We call it Agility-on-Demand. We even used Azure DevOps and Agility-on-Demand to deliver our own solution, Contract Management by Cittros.

If you are about to embark on your own journey of upgrade to D365, please do not hesitate to contact us, should you wish an informal introduction to how we work.

###### Topics: [Insider](https://www.cittros.com/insights/topic/insider) [Azure](https://www.cittros.com/insights/topic/azure)

###### 1 min read

## [Prepare for a video recording](https://www.cittros.com/insights/prepare-for-a-video-recording)

 By [Inga Numadottir](https://www.cittros.com/insights/author/inga-numadottir) on 27 August 2020

[![](https://www.cittros.com/hubfs/IMG_20200827.jpg) ](https://www.cittros.com/insights/prepare-for-a-video-recording)

When I was asked to record a session for [DynamicsCon](https://dynamicscon.com/agenda/?session=inga-numadottir&time=ct), I felt it was no big deal. However, as the timeslot for my recording approached, it was all I could think about. Was I prepared? Was everything working as it should? I started thinking about what I can do to make sure I was prepared and here are my tips I would like to share with you.

###### Topics: [DynamicsCon](https://www.cittros.com/insights/topic/dynamicscon)

###### 1 min read

## [First steps to a successful ERP implementation: analysis and design](https://www.cittros.com/insights/erp-solution-implementations-the-solution-architecture-phase)

 By [Cittros team](https://www.cittros.com/insights/author/cittros-team) on 09 May 2020

[![](https://www.cittros.com/hubfs/isis-franca-hsPFuudRg5I-unsplash.jpg) ](https://www.cittros.com/insights/erp-solution-implementations-the-solution-architecture-phase)

Great consultancy is all about knowing and understanding a client’s business, as well as ability to reimagine their business processes in the context of Dynamics AX/D365 features and modules.

###### Topics: [Insider](https://www.cittros.com/insights/topic/insider)

### Posts by Tag

- [D365FO (82)](https://www.cittros.com/insights/tag/d365fo)
- [Finance (50)](https://www.cittros.com/insights/tag/finance)
- [PowerBI (18)](https://www.cittros.com/insights/tag/powerbi)
- [D365 Supply Chain Management (15)](https://www.cittros.com/insights/tag/d365-supply-chain-management)
- [D365 Commerce (14)](https://www.cittros.com/insights/tag/d365-commerce)
- [Retail (12)](https://www.cittros.com/insights/tag/retail)
- [Reporting tuesdays (9)](https://www.cittros.com/insights/tag/reporting-tuesdays)
- [Insider (8)](https://www.cittros.com/insights/tag/insider)
- [Reporting (8)](https://www.cittros.com/insights/tag/reporting)
- [AI (6)](https://www.cittros.com/insights/tag/ai)
- [Workspace (5)](https://www.cittros.com/insights/tag/workspace)
- [Azure (4)](https://www.cittros.com/insights/tag/azure)
- [POS (4)](https://www.cittros.com/insights/tag/pos)
- [Artificial intelligent (3)](https://www.cittros.com/insights/tag/artificial-intelligent)
- [Copilot (3)](https://www.cittros.com/insights/tag/copilot)
- [ALM (2)](https://www.cittros.com/insights/tag/alm)
- [BPA (2)](https://www.cittros.com/insights/tag/bpa)
- [Business Performance Analytics (2)](https://www.cittros.com/insights/tag/business-performance-analytics)
- [DAX (2)](https://www.cittros.com/insights/tag/dax)
- [Machine learning (2)](https://www.cittros.com/insights/tag/machine-learning)
- [Power Platform (2)](https://www.cittros.com/insights/tag/power-platform)
- [Workflows (2)](https://www.cittros.com/insights/tag/workflows)
- [DynamicsCon (1)](https://www.cittros.com/insights/tag/dynamicscon)
- [Excel (1)](https://www.cittros.com/insights/tag/excel)
- [Fabric (1)](https://www.cittros.com/insights/tag/fabric)
- [OCR (1)](https://www.cittros.com/insights/tag/ocr)
- [Outlook (1)](https://www.cittros.com/insights/tag/outlook)
- [PowerApps (1)](https://www.cittros.com/insights/tag/powerapps)
- [RSAT (1)](https://www.cittros.com/insights/tag/rsat)

[See all](https://www.cittros.com/insights/all#)

### Subscribe for our insights

[**](https://www.linkedin.com/company/cittros)

[![cittros_white_200x40](https://www.cittros.com/hs-fs/hubfs/LOGO%20CITTROS/cittros_white_200x40.png?width=100&height=19&name=cittros_white_200x40.png "cittros_white_200x40")](https://www.cittros.com)

Copyright © 2025 Cittros

**