Skip to main content

Posts

Showing posts with the label Microsoft Dynamics 365 Finance

Number Sequences

  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 ...

Currency Management

  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...

UI- User Interface

  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=li...

Vendor Invoice Posting Date (Pending Invoices)

  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 ...

OCR - Optical Character Recognition Service - Invoice Automation for Scanned Documents

 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...

How to Decide How Many Journal Names to Define

  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 ea...

Microsoft Dynamics 365 Finance

  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