#D365 #D365FO #D365FSC #ERP #Accounting #Setup #WhatsNew #2022Wave2 Microsoft periodically delivers automatic Dynamics 365 Updates. This keeps your ERP system up to date with the latest and greatest software. There are several new features, particularly the Finance features, that I find interesting with Dynamics 365 Finance & Industry clouds: 2022 Release Wave2. Overview: The 2022 release wave 2 for Dynamics 365 and industry clouds brings new innovations that provide you wi

#D365 #Microsoft #ChartofAccounts #Intercompany #Setup #Strategy Are you dreading the financial month end process of reconciling the intercompany accounts? No problem for D365. Here is a strategy for creating Main Accounts in a D365 Chart of Accounts the simplifies the reconciliation process. The numbering convention results in a visually easy to reconcile trial balance in your consolidation Legal Entity. The strategy for an numbering convention in your chart of accounts al

#Microsoft #D365F #AgingBuckets #Config #Setup Have you ever wondered why the Aging Buckets are not appearing empty wrong Exhibit: Collection Aged Balances Today we will show Aging Period setups to generate accurate balances. 1. Credit and Collection Parameters Note: If the setup of more than six periods [buckets], the definition cannot be used on the Collections Aged Balances screen. Aging period definitions are defined on the following exhibited setup menu. Credit and Colle

#D365 #D365FSC #Setup #FinancialDimensions Have you ever wanted to run a trial balance by Customer, Item, Vendor, Projects, etc. ? There are a lot of benefits to doing this, but the challenge is automating the process. D365 can do this, and the setup is easy. Today, we will use "Projects" as an example. 1. Create a entity backed Financial Dimension General ledger > Chart of Accounts > Dimensions > Financial dimensions Select "New" and choose the desired table. Note: Do not ch

#D365 #D365FSC #FinancialDimensions #Setup #Activate #MaintenanceMode You have created new Financial Dimensions, want to activate them, and system says you must be in maintenance mode. To perform the following steps, you must have access to Life Cycle Services for your environment. 1. Enabling Maintenance Mode Login to Life Cycle Services Choose your project on the front page On the right side click “Full details” for your environment Note: It may take a minute or so for the

#Miscrosoft #D365FS #D365FSC #Setup #CurrencyRates #Import Tired of keypunching Currency Exchange rates? Even more tired of researching keypunch errors? Replace those tedious keypunch activities with automated import of Currency Exchange rates in Microsoft D365 ERP. Today I will use Oanda as an example. 1. Create currencies Many implementations that I have seen, have all the currencies already created and ready for use. If you need to create some, use standard ISO naming for

#D365 #D365FO #Setup #Configuration #Automation #AccountsPayableParameters #NumberSequences #VendorGroups Have you ever wanted to have some intelligence for your vendor numbers? In D365 you can automate that ! I usually number my Vendors as V######, as opposed to C###### for Customers. Occasionally I like a little more information in my Vendor number, and I can get that automatically by leveraging the Vendor Group setup. I have the following Vendor Groups created that I want

#Microsoft #D365 #D365FO #DefaultDescriptions #JournalDescriptions #Setup #Configuration #Automation Do you ever wish the out of the box journal entries had more information? Well... D365 Finance and Operations can do just that. The features we are going to explore today are customizable in the Journal Setup section of the General Ledger module. General ledger > Journal setup > Journal descriptions General ledger > Journal setup > Default descriptions General ledger > Journal

#D365 #D365FSC #D365FO #Microsoft #ChartofAccounts #Setup #Design #Architecture Overview A Chart of Accounts is the backbone of a financial system. It is a core setup in D365 Finance ERP system. A best of breed, thoughtful, Chart of Accounts will benefit financial reporting, facilitate validations, and streamline accounting and review. Optimizing your new Chart of Accounts will use a combination of some, or all of the following strategies. These strategies are best practic

#D365 #D365FO #D365FSC #Setup #InventoryClose #InventoryRecalc #InventoryRecalculation #FIFO Why should I? It is too much work. I am afraid of it. I don't know what it does. For this blog, I will focus on Inventory Recalculation and Inventory Closing. I will use FIFO costing as an example for Recalculation. 1. Definitions Inventory Recalculation: Changes Dynamics native costing 'average' to your chosen method (i.e. FIFO). Is a prerequisite to Inventory Close Is not require

#D365 #D365FO #D365FSC #Setup #Workflow #Journals #Posting #Automate You have already created your General Journal and submitted to to applicable Work Flow for Approval. Now you patiently, or not, wait for approval so you can post your journal. Wait no more ! Just schedule your approved workflow journals to autopost. The following defines the process to automate the posting of the approved General Journal. Post Journals Define the parameters that you are going to use. All of

#D365 #D365FO #D365FSC #ERP #Accounting #Setup #WhatsNew #2021Wave2 Microsoft periodically delivers automatic Dynamics 365 Updates. This keeps your ERP system up to date with the latest and greatest software. There are several new features, particularly the Finance features, that I find interesting with Dynamics 365 Finance 2021 Release Wave2. My new feature highlights: General Ledger Year End Enhancements This feature comprises a number of enhancements that give you more c

#Dynamics365, #D365FSC, #D365FO, #AssetLeasing, #Setup, #Accounting, #IFRS16, #ASC842, #Configuration, #PostingProfiles, #Vouchers, #Bug, #KnownError In the previous blog we discussed Microsoft D365 Asset Leasing vouchers. D365 Asset Leasing (IFRS16) (365financearchitect.com) Today we will review the related setups and posting process for Asset Leasing. 1. Asset Leasing Parameters (Leases, Accounts, and Number sequences) Create and assign the exhibited Journal Names. Asset le

#Dynamics365, #D365FSC, #D365FO, #AssetLeasing, #Setup, #Accounting, #IFRS16, #ASC842, #Configuration, #PostingProfiles, #Vouchers Dynamics 365 Finance and Supply Chain automates Lease Accounting. D365 will process transactions for both ASC 842 and IFRS 16 Today we will cover the process related to IFRS 16. 1. Chart of Accounts Create the exhibited Main Accounts. General ledger > Chart of accounts > Accounts > Main accounts 2. Posting Profiles Assign Main Accounts per the tab

#D365 #D365FO #D365FSC #PPV #PurchasePriceVariance #Setup #Reporting #VarianceAnalysisStatement #ItemModelGroup #PostingProfiles Purchase Price Variance (PPV) is the difference between the Standard Cost of a product vs. the Purchase Order pricing. D365 will automatically record the PPV when posting a Purchase Order Receipt and also when posting the Purchase Order Invoice. In today's scenario we will demonstrate the following: Item # #1 Standard Cost $1,000.00 ea Purchase O

#D365 #D365FO #Accounting #Setup #Consolidations #Eliminations #Net Processing Eliminations for Consolidated Trial Balance in D365 is rather straight forward. The concept is that if you have transactions with the various companies that you own, those transactions need to be eliminated so that their balance is zero. Today we will demonstrate an example where we have moved $1,000,000 USD of Prepaid Insurance from Contoso company USSI to USMF. We will have consolidated in GLMF

#D365 #D365FO #Accounting #Consolidation #FinancialDimensions #LegalEntity #Setup When you setup your Consolidation, Online in Dynamics 365 FO, there is an easy trick to identify what Legal Entity (LE) the Trial Balance values come from. 1. Financial Dimensions Create a Financial Dimension and point it to the Legal Entity table. I usually name the Financial Dimension "LE". General ledger > Chart of Accounts > Dimensions > Financial dimensions Note: You will probably need to p

#D365 #Consolidation #ConsolidateOnline #Configuration #Accounting #Setup #CurrencyTranslationAdjustment If you have D365 ERP system, you probably have multiple companies and the need to publish consolidated financial statements. The following process outlines how to perform Consolidate, Online to achieve a Consolidated Trial Balance. 1. Chart of Accounts. Create a Main Account to store the Currency Translation Adjustment (CTA) General ledger > Chart of accounts > Main accoun

#D365 #Setup #Override #ChartofAccounts #LegalEntityOverride #FinancialDimensions #FinancialDimensionValues Did you ever want to force the Financial Dimension Values that appear in your Trial Balance. Today we will show you how. Our goal today will be to input some random Financial Dimension Values and force them to be a fixed value. I will use Main Account 201110 for the demonstration. We can choose any fixed value from our Financial Dimension Values, including "Blanks". We

#D365 #ChartOfAccounts #Setup #Configuration #ConsolidationAccount #ConsolidationAccountGroup #AdditionalAccountsforConsolidation #ConsolidateOnline Today we will consolidate Legal Entities (LE) with different Chart Of Accounts. Scenario LE Chart Of Accounts Name Country US01 COA_USA USA FR01 COA_FRA FRA CON COA_USA USA The France LE is using a French Statutory Chart of Accounts. The USA Consolidation LE (CON) is using a different Chart of Accounts. Assumption You