D365FO

  There are various setup that you may achieve with the number sequences. Lets get in to detail on what functionalities we may use. Which parameters you can setup in a number sequences:   On number sequences, you may define various parameters; You can setup number sequences as continuous. In case of unexpected issues occur, system cannot recycle numbers automatically for continuous numbers. Run the cleanup process to recover the numbers. You can set up pre allocation for performance, so number sequence will be allocated for use. You can setup constant figures for smart coding. You can define legal entity information for smart coding and it makes easier for reporting purposes (For consolidation etc.) Number Sequences on journals:  You can create several journal names which have different number sequences. So when you post a journal and check from the voucher transactions, you know which type of transaction is being posted. Number sequences with date:  You can setup a number sequence to

  There are various ways to manage currency transactions in Microsoft D365FO. Here you can find the ways that I mostly use. 1. Ledger Transactions:  On Ledger Transactions you can see 3 currency amount. Transaction Currency, Accounting Currency, Reporting Currency. Transaction currency is used for original document currency. Accounting currency is the currency that you place your legal reports on. Reporting Currency is an additional third currency that you want to report on. For example, you want to report your values due to EUR even your accounting currency is CAD while your group company is in Europe. You can revert your values in reporting currency, from transaction or accounting currency due to the selection of a parameter. 2. Management Reporter:  You can prepare the reports due to the selection of the currency. System will revert the balances to the currency you select on the report with the exchange rates. 3. Triangulation:  You can select a currency to report as triangulation.

  You may think why adjusting or cancellation processes are too hard on D365 FO specially when any GL posting occurs.  I also think the same time to time. I always find hard to manage the reversals when a production order is ended and invoice is posted.  For example when an invoice is posted, you can not reverse just the invoice. Users can do mistakes for example when you fill the date. Only date can not be changed for that invoice Also when you end a production order, you can not cancel the production order. I believe this is because there are too many dependecy. For example, invoice date helps calculate the VAT, due date, cash discounts etc. Still in each version there are new features that help us to cancel the transactions easily like cancelling the voucher in most of the transactions or cancelling/correcting packing slip.s

  Why I like  D365 products is that , they care about the users. They generate things that help users. Not just for functionality but the UI. So these are some examples that I like to use below. 1. Saved Queries: You can save your queries and have your reports accordingly without to re-enter same information every time. For example, you want to report invoices from the local customers.You give the filter and save query. Then you only need to select the query you saved. 2.Create Workspaces: Workspaces are also can be created by users. On the work spaces, you can see the forms you selected as links, tiles or in grid view. 3.Change Forms: User can change their own forms. Add totals, hide, add fields. Also you can share your forms around the other users easily. 4. Change size of tiles: As a new functionality, you can even change the tile size.  https://www.linkedin.com/posts/andreadc_configure-your-workspace-of-choice-as-startup-activity-6944520939745230848-JJI0?utm_source=linkedin_share&a

  On the pending invoice posting form, there are different dates that may need to be filled. But there are two fields that may be mixed up. Invoice Date and Posting Date.  -Invoice Date is the date of the real invoice and most of the calculations(cash discount, exchange rates etc.) are using this date. It is optional not to fill this information unless on the parameters it is set to be filled mandatory. (Account payable > Setup > Account payable parameters -> Require document date on vendor invoice) - Posting Date is the date the transaction is posted to GL. This may differ from the invoice date in many circumstances. For example the invoice may arrive to posting user after the invoice date, period is closed etc. This field is used for calculations if invoice date is not filled. To fill the invoice date is mandatory and it is set to today as default when invoice is created but can be changed before posting. In some circumstances, users may need to change or bulk change the pos

 Updates to Dynamics 365 Finance 2022 release wave 2 include general availability of vendor invoice OCR (optical character recognition). This will automate the reading and recognition of vendor invoices by providing OCR capabilities to complete the full end-to-end automation of accounts payable. I was expecting this functionality for a while. I've not set it up or tried before but we were using some third parties to manage this functionality.  According to the documentation, we will be able to Upload vendor invoices to pending invoices as header and lines and related attachments.  Will be managed through data entities. Vendor pending invoice header entity will be change for to add attachment and new entity to be added for attachments. Also for to manage the process UI forms will be added. According to my previous experiences, there is still need to cover the processes below: Use vendor invoice journal for the processes that do not use a PO or a pending invoice. Use vendor approval

  To manage an ERP process with success is not easy at all. Even there has been processes that have been published by companies, it is mostly depend on the people. In this blog , I am going to share the reasons I see as blockers of during the projects. This is not a scientific measure but just my opinions. Sales Team:  ERP project starts from even before the sales documents are finalized. So company needs (not user/not management etc.) need to be understood wisely and to be checked if the tools can manage these needs and details need to be documented in the contract. Expectations:  Unfortunately, ERP is a software but not a hardware. So expectation management is very important. If it was a hardware, then you will be able to return and to document specific details.  Project Team:  By project team, mostly we understand the consultancy firm but project team does consist of also from customer project managers, users, power users etc. All project team need to be well aware, trained and need

 When we say allocations of expenses through accounts and dimension, there are various ways that can be used in D365 FO. In this blog you can find these ways and their differences from one to another. Cost Accounting Module:  If you do not need/require to post any transaction or you think that there will be too many transactions appear on voucher transactions, then you can use cost accounting module to report on your balances. This module works separate from the GL module. Data is transferred from GL module and you prepare your allocation rules in this module and do your reporting. also you can use this module for to report different versions. Allocation Rules : You can define allocation rules and within the period you want to use, system will allocate the balance to the relevant account and dimensions. The pros of this type is that, you can trigger and change the rules whenever you want to . The cons of this type is, you need to trigger each rule one by one, wait for the reporting aft

  This topic may seem like a report or process in D365, actually, I wold like to mention the differences between the roles of to become a consultant, team leader, project manager and solution architect. Why I would like to have this topic to discuss is that I see lots of job opening that requires functionalities of a consultant from a solution architect or via versa. Solution Architect:  "A Solution Architect is responsible for the successful design, implementation, deployment, and adoption of an overall solution. A Solution Architect ensures that the solution meets the customer’s needs now and in the future. While the Solution Architect may not “click the buttons” during a deployment, they are ultimately responsible for the solution and work closely with the deployment team." So a solution architect is placed in the meeting to have a fit gap, need to know the overall solution and project details, is aware of all the D365 solutions to propose and decide when to go for a devel

  When you are in the design phase, you need to decide how many journal names to define. I would advise to use as minimum as you can but it depends on the parameters below with my experience. Which Journal Types are going to be used? Like payment journals, invoice journals etc. How many journals do we need for migration. Are we going to create one of one for each purpose of migration. Do we need separate journals or user groups for reporting purposes? Do we need separate journals for different work flow operations? Are we going to use same journal type but create new ones for managing operations/purposes from the modules like accruals, TMS related journals etc. Do we need to differentiate voucher series for easy reporting? Do we need to auto setup offset account for users not to select? Like bank accounts to be automated directly and not to be selected by the user one by one on each transaction. These questions will help you how many journal names to setup in the system for easy use.

  There is only one inventory dimension that can be linked to a financial dimension: "Site" You may say why site. For my opinion, it is the most common reporting dimension to be used for P&L. So when you link this dimension to a financial dimension, system will automate the financial dimension once the site is selected. How you link these to information is: Create a financial dimension. Create sites. Go to Inventory management > Setup > Posting > Dimension link. In the Reference field, select the financial dimension to link to the site inventory dimension. Click sites.  On the Financial dimensions FastTab, select a financial dimension value for the dimension. Once you have finalised; Activate link Lock the link You can always unlock or deactivate the link.

  In this blog you can find some testing tips that may help. 1. Start with basic testing: If you are testing the invoicing process,use one order one line to test first.  2. Test with multiple transactions. If you are testing the invoicing process and passed the basic testing, test with multiple transactions like multiple lines, multiple orders. 3. Test from the start If any of the cases failed during testing, test from the start. 4. Document Testing Operations You must document the cases before you start the testing, but can be added new ones during testing. Document details. This documentation can be in written or using videos or other tools. 5. Test with different data. Do not test with the same data like to fill qty as  any amount as 100. Use decimals etc for testing purposes.  6. Test to have error messages. Test like users. Test like a user and do incorrect actions to have error messages. Forget to activate the account and see what happens. 7. Do the partial testing. Check if part

 There are different ways to do the integrations. Please find the list below: You need to select the one that is more applicable for your implementation. Power Platform integration OData Batch data API Custom service Consume external web services Excel integration You also need to decide your integration patter to be sync or async. For example, OData is sync but Batch Data API is async integration.If there is too many data which is not required near real time, then async integration is better to use.  On Microsoft page, you can find the offering with examples. For On-premises, while I do not have too many expertise or can not find too many documentation, this blog may not be too helpful. But only supported API is   Data management package REST API . You may find the useful links below: https://www.youtube.com/watch?v=CgYAP4I9yy0 https://docs.microsoft.com/en-us/dynamics365/fin-ops-core/dev-itpro/data-entities/integration-overview https://docs.microsoft.com/en-us/learn/modules/integrati

  This is one of the astonishing integrations that I see in the system. It really excites me. In today's business scenarios, to reach for a data and respond quickly is very important. Especially after the Covid process we faced, we need to reach data without waiting for anyone or a department to supply us the data. So for replying questions from departments, customers etc., we can use teams and integration of D365.  Teams can be integrated with Dynamics 365 Sales, Dynamics 365 Customer Service, Dynamics 365 Field Service, Dynamics 365 Marketing, and Dynamics 365 Project Service Automation. On teams, you can connect the apps and have and share data. For details you may use the link below. https://docs.microsoft.com/en-us/dynamics365/teams-integration/teams-integration For more visualization, I found this videos very helpful. https://www.youtube.com/watch?v=PPt0-9uyM-g  

https://docs.microsoft.com/en-us/dynamics365/fin-ops-core/fin-ops/get-started/shortcut-keys

  In D365 Finance, you can analyse , manage and see your financial insights.  You can manage financials of : General Ledger COA and Dimensions Fixed Assets AR AP Cash and Bank Module Related Financial  Postings like asset management , inventory and production postings etc. It is not a financial software. There is a difference.  You can automatize process with workflows Use analytic reports like embedded Power BI and management reporter Efficiently use consolidation Unified reporting Security and financial control Auditing  Helps Decision making with reports Easily adopt for local and global needs

  In D365 F&O there are ways to manage the descriptions. You may find the list below: Manual:  You may fill the description in the journals per line before you post the transactions. you may fill both for account and offset account. If you define a description before, you may select one from the list. Automatic:  Some transactions are auto created to the journals or on transactions default from the hard coded codes, like asset lease management and some functionalities in TMS management. Default Descriptions:  You can setup default descriptions by transaction type (sales order invoice, Po invoice, revaluation etc). On the transaction types you can use static (constant) text and/or variables. Specific Cases:  There are specific cases like revaluation. If you define the text during to run in revaluation process, system uses that information instead of to use the definition on the default description. Or if there is no setup on default descriptions, cancel operations use the original t

  People mostly think that to invest to ourselves need money or time. But I do not think in that way. There are lots of ways to invest yourself if you are a Microsoft Dynamics related consultant. Some may require money and/or time but some do not. I have listed some options that you can invest yourself by to use tools. Be a MCT (Microsoft Certified Trainer):  This will need some time and money to invest while you have to be educated by a professional. But as a result, you will have lots of side right like discount on the exams and to reach some documents. Use Microsoft Learn:  This is a free tool to educate yourself. In Microsoft Learn, you also have videos and labs which opens VMs. You may give 20 min a day to review the contents. Microsoft Docs:  There are thousand of pages of documentation you can reach and read. Certification:  A certification is a good way to prove your capabilities. Attend meeting as a listener or a speaker:  There are lots of meetings are being placed by Microso