Tag Archives: Dynamics 365
Advanced & Auto Bank Reconciliation in Dynamics 365 Finance
Introduction In any accounting software, it is always important to keep track of all real-time bank transactions and record them in the ERP. Since bank transactions are booked manually in the ERP, it is necessary to ensure that the bank statements and ERP records are matched on any given date. This is where bank reconciliation comes into play. Bank Reconciliation Bank reconciliation is an activity done by any finance user for the purpose of reconciling book transactions w.r.t bank statements and ensuring that both are as closely matched as possible. D365 Finance offers two ways of performing bank reconciliations. One is by entering the bank statement amount manually and reconciling the ERP statements for each record against the amount. The other is by importing the bank statement into the system and letting the system match the records of the statement against the ERP based on a certain criteria. The blog is made with the assumption that the reader is already aware of the manual bank reconciliation process in D365 Finance. The second method is undoubtedly easier, flexible, and time-saving for any user. While there are several widely used bank statement format types which can be processed in D365 Finance like MT490, CAMT.054, BAI2 and others, this blog post will be focused on the MT490 format only. Moreover, D365 Finance also enables the user to reconcile not only payments/receipts, but also transactions from the bank’s side, like bank charges, interest fees or reversals and post those entries into the ledger automatically. There is also a flexibility to create a set of rules that can allow for minor amount/date variations of the system w.r.t the bank statement. Steps to perform the bank reconciliation in an automated manner Setup We have to enable the system to accept bank statements in MT940 statement first. In order to do that, navigate to, Organization Administration > Workspaces > Electronic Reporting Click on Repositories. Select Global and click Open on top. Filter the Configuration name by searching for ‘MT940’. The above list of formats will be displayed. Select them all and click on Import. The system will import the bank formats in D365 Finance. Next, we have to map the format in a setup. Go to Cash & Bank Management > Advanced Bank Reconciliation Setup > Bank Statement Format Create a new record and specify the Statement Code, Name and map the Import format which was imported in the previous step. Now this is done, the only part left is to configure the Bank master to enable advanced bank reconciliations for any transactions. Open the Bank Account Master. Turn on ‘Advanced Bank Reconciliation’ and select MT940 in the field Statement format. Once this is done, we are ready to use Advanced Bank Reconciliation. Working To start with advanced reconciliation, we will take a scenario of a bank where the following transactions have occurred: The above 3 transactions are created in the system and will be reconciled with the use of a bank statement. The bank statement will be a notepad file that will be imported in the system. While the bank statement is always provided by the bank, it is important to know the bank statement format so we can setup and test any scenario with dummy records. The above screenshot specifies the structure in which the bank statement is accepted by the system. We will be using this format to import bank records and reconcile them with the system records. From the above image, 3 types of bank transactions have been made in the system with the respective amounts and dates. Now the bank statement file for the above transactions is as follows: As you may observe, all three transactions are recorded one below the other, and the opening and closing figures are manually entered here. In real-time scenarios, this is provided by the bank and the user does not open or make any changes to the file. In order to import the file, go to Bank Account > Bank Statements > Import Statement In the parameters, select the bank account, browse the text file from your PC and click on upload, then click on OK. The bank statement is imported with the above transactions. Select the transactions and click on Validate on top. Now we proceed with the reconciliation. Go back and click on Bank Reconciliation in the Bank Account screen. Create a new reconciliation. Then click on Worksheet at the top. The reconciliation screen is opened. Here, the user is presented with the option to manually match any record to reconcile or let the system match the records based on a certain matching rule. While any variation of rules can be defined, the most commonly used rules are: Based on the above, we will define a matching rule based on date and amount difference and re-import the statement. To define a matching rule, navigate to Cash & Bank Management > Advanced Bank Reconciliation Setup > Reconciliation Matching Rules Based on the above image, the criteria for the match amount and match date is defined where a variation of 2 INR and 3 days will be allowed in reconciliation. Once it is saved, click on Activate. Next, navigate to Cash & Bank Management > Advanced Bank Reconciliation Setup > Reconciliation Matching Rule Sets Create a new rule set and link the matching rule that was created earlier. As you may observe, we can link multiple rules here. This is useful when it is necessary to reconcile statements with a variety of rules instead of a single rule. Next, go to Bank Account > Scroll down to Reconcilation section and link the matching rule set in the Default Matching Rule Set Now we are ready to run the reconciliation once more with some variations of amounts and days in the bank statement. Import the statement once more and validate it. The bank statement is imported as follows: Now create a reconciliation worksheet. On the top, select the option ‘Run Matching Rules’. Once the matching rules … Continue reading Advanced & Auto Bank Reconciliation in Dynamics 365 Finance
Posting Restriction in Business Central for different users for Purchase and Sales documents
Introduction Invoices and shipments are frequently handled differently by different businesses. Processes, for example, can range from one person posting everything on a purchase order to numerous employees working on their own sites. On the User Setup page, you can now select how each user can handle invoices. Steps to achieve the goal 1. Go to User Setup select the users you want to give this restriction and then there are two columns Sales Invoice publishing Policy and Purch. Invoice Posting Policy 2. There are three values in these options Below is the impact of the above three options in different documents of purchase and Sales transactions. Document Option 1: Allow Option 2: Prohibited Option 3: Mandatory Displays a series of options Confirmation dialog Confirmation dialog Sales Order Ship Do you want to post the shipment? Do you want to post the shipment and invoice? Invoice Ship and Invoice Sales Return Order Receive Do you want to post the receipt? Do you want to post the receipt and invoice? Invoice Receive and Invoice Inventory Pick Ship Do you want to post the shipment? Do you want to post the shipment and invoice? Ship and Invoice Purchase Order Receive Do you want to post the receipt? Do you want to post the receipt and invoice? Invoice Receive and Invoice Purchase Return Order Ship Do you want to post the shipment? Do you want to post the shipment and invoice? Invoice Ship and Invoice Inventory Put-away Receive Do you want to post the receipt? Do you want to post the receipt and invoice? Receive and Invoice Warehouse Shipment Ship Do you want to post the shipment? Do you want to post the shipment and invoice? Ship and Invoice Note: If you are trying to post invoice transactions from the general journal the above restriction would not be used in the General journal table. Conclusion Thus we saw how we can restrict the users to post the purchase and sales transactions. Thank you very much for reading my work. I hope this helps!
How to display Media (Picture) Data from one table to another table and display it on the RDLC report
References FlowFields – Business Central | Microsoft Learn Creating an RDL Layout Report – Business Central | Microsoft Learn Pre-requisites Microsoft Dynamics 365 Business Central Cloud/On-Premises Introduction In this blog, I am going to showcase how to flow Media (Picture) from one table to another and how to display it on the RDLC report. Flow Media data from one table to another table For this example, I’ve made a simple Mediadatatype table with a few fields and kept the ‘Image’ field as a Media data type. Additionally, I created the ‘Image’ field as a Media datatype to the Purchase header table extension and used the Fieldclass property as a flowfield and the Calcformula for the flow Image on the ‘Image’ field. The Image flows on the Purchase order ‘Image’ field, where my assigned user Id is PD, thus the image will appear on the Image field. How to display Media data type (Image) on RDLC report. In the following example, I’ve added an Image column to the MediaDatatype report Open the report on RDLC layout. On an Image property, select the image source as a database, use an ‘Image/bmp MIME type, and set the Image expression. Output Conclusion Thus, we saw how to flow Media datatype from one table to another and how to display it on the RDLC report. I hope this helps!
How to create entity specific Purchase requisition in multi entity environment in D365 Finance and Operations
Introduction In multi entity environment having separate legal entities for head quarter & regional entities, having separate sets of employees for each legal entity. & only head quarter employees taking decisions for which & how much inventory to be maintained at regional level & same employee having purchasing authority for all regional entities. In this case to keep track, post & report of what & how much purchase made for respective regional entity, need to create Purchase requisition for respective buying legal entity. i.e. USMF is headquarter entity & PM is regional entity. Problem Statement While creating Purchase requisition from headquarter employee’s login, it is created with buying legal entity as headquarter entity. i.e. Julia is employee of Headquarter USMF entity who will be going to issue Purchase requisition for regional entity PM. When Julia login in PM entity & create Purchase requisition then entity will automatically change to USMF. Solution Steps Follow below steps, in order to create Purchase requisition with buying legal entity as respective regional entity & to maintain all details on respective entity. 1. Select employee of headquarter which is going to issue Purchase requisition. i.e. select Julia in USMF entity – Go to Human resource -> Workers -> Employees -> 2. Select required employee. i.e. Julia – 3. Go to Work History 4. Click on Add employment to add respective entity to history. i.e. Add PM entity in Julia’s history 5. Add details of Legal entity i.e. Entity PM, Employment start date & click on Create employment. 6. History is added of PM entity Create Purchase Requisition Go to Procurement & sourcing -> Purchase requisitions -> All purchase requisitions & create new Purchase requisition from PM entity then Purchase requisition will be created for PM entity & window will not switch back to USMF. Now all Items added in this Purchase requisition will be ordered & maintained for PM entity.
Transfer Order/ Stock transfer Tax Information not showing for many users in Dynamics 365 Supply Chain Management
In this blog, we are going to address the issue that can be seen in the recent update in Microsoft Dynamics 365 Finance & Supply Chain Management. To solve this issue please follow below steps. Currently If we see before the setup there is no tax information showing in Stock Transfer Transaction. Only the Administrator can see this Tax information. To overcome this issue, in Dynamics 365 F&SCM new update we have to enable “Private” field in the warehouse address tab. For this, Go to Inventory Management Setup->Inventory Breakdown->Warehouses. Go to Address. Click on Advanced. Right click In Address section and Click Add field. Add a field as “Private”. Once it is on the address section just disable the private field. By this every user will be able to see the Tax information on the Stock Transfer. After this, the user will be able to see the Tax Information on the Stock Transfer. That’s it for this blog. Thank you!!!
Copy data between different companies using Configuration Worksheet
Introduction In this blog, I will demonstrate how to copy data between different companies using configuration worksheet. Previously we could only use Configuration packages or copy the company to copy data between companies. By using the Configuration worksheet users can copy data from specific tables in companies to their respective table in the current company. Pre-requisite Microsoft Dynamics 365 Business Central (On-premise/SaaS) Steps Globally search for “Configuration Worksheet” and click on the related link. Configuration Worksheet page opens up. Fill in the table you want to copy. Then click the ‘Copy Data from Company’ button on the action bar as shown in the below screenshot. Also, to use this function the ‘copy data from’ company table must have records and the ‘copy data to’ company table must have no records. A Pop- up page appears allowing the user to select the company from which data will be copied. The no. of records will be shown of the selected table. If the table selected has no records then the line won’t appear. If there are no issues, click on ‘Copy data’ action and a confirmation message will pop up before proceeding. A confirmation message pops up mentioning the data has been copied successfully. Other Actions Get Tables: Click on ‘Prepare’ on the action bar, there you will find the ‘Get Tables’ button. This lets the user add tables by using filters as shown in the below screenshot. Get related tables: User can find another button by clicking ‘Prepare’ and in that ‘Get related Tables’. This function adds all Vendor-related tables and fields anchored on other tables. Please note: Table relation with filtered view and conditional table relations are not considered here. Delete Duplicate lines: Users will find this button under the ‘Prepare’ action. This function deletes duplicated lines as shown in the below screenshot. The vendor line was repeated, by using this function it deleted duplicate lines. Conclusion: In this blog, we learned about copying data from multiple companies into the current company by using a configuration worksheet. Hope this helps!
Trigger Power Automate Flow using JavaScript – Uni-Directional
Hi All, Did you know you can use JavaScript to trigger Power Automate flows and pass input data? So, I’ll show you how to do that, as well as how to pass strict structured data and dynamic schema in Power Automate. In the next blog, I’ll talk about Trigger Power Automate Flow using JavaScript – Bi-Directional Steps to follow for Initial Setup Step 1: Let’s create a Power Automate Flow and define the input JSON schema.Go to: Power Automate Create an Instant Flow with the trigger ‘When a HTTP request is received‘ Step 2: Let’s outline the input schema and then focus on the output in a ‘Compose’ block. I’ll describe two types of inputs. (Strict and Dynamic).Our strict schema will be identified by a specific pattern indicating how the input should be given.Our dynamic schema will be recognised by an unknown pattern, and input will not always be fixed. Click on ‘Use sample payload to generate schema’. Apply the following code, click on Done and you will see the schema in ‘Request Body JSON Schema’. Add a Compose Block to check the output of the request and save the Flow. URL will be generated and is ready to be used. Let’s now proceed to create JavaScript to trigger this flow Steps to follow for calling Flow using JavaScript Since I’ll show the code snippet, adjust it as per your use case. Note: Copy your HTTP Post URL from the trigger as it will be used in the JavaScript Step 1: Type the following code Step 2: Execute the JS with ‘TriggerFlow.Main()‘. Note: Make sure you pass Execution Context to the JS Step 3: Check your Power Automate Flow History and open the Run. That’s how Power Automate is triggered using JavaScript. Hope this has helped you 🙂 Next blog – Trigger Power Automate Flow using JavaScript – Bi-Directional
Business Central 2023 wave 1 (BC22) new features: AL Explorer and AL Home in Visual Studio Code AL extension
Introduction: Business Central 2023 wave 1 (BC22) new features: AL Explorer and AL Home in Visual Studio Code AL extension Steps : 1. Download and install the next major version of the AL Language extension. (v11). 2. Below is the download link of the AL Language below to experience the new features of the development. Click on this link Link: ALLanguage v11.0.759316. Extract that folder and we can see there is a VSIX extension file. 3. Uninstall your previous AL language extension from the visual code marketplace. 4: Go to visual studio code extension marketplace, then click on 3 dots -> click on-> Install from VSIX. 5 : Select vsix extension file, and click on Install. Here, we have successfully installed the AL language extension. 6. First of all, when we open the VS Code, we will see the AL Home below. 7. Another shortcut key for this AL Explorer: AL: Explorer: Ctrl + Shift + F12 Below is the AL: Explorer page. 8. We can View, search, and filter objects: a. Group By: b. Module c. Go to Source Code For a selected object, we can quickly jump to source code, whether to develop or read. d. Bookmark: We can bookmark objects. Below is the Bookmark object. e. API: AL Explorer also allows an overview of all APIs. f. Events: AL Explorer also allows an overview of all Events. g. Extensible Enums: AL Explorer also allows an overview of all Extensible enums. Thank you, I hope this helps!
Error on POS Payment method ” The payment information is either missing information or it is incorrect
In this blog, I will show you how to resolve the below error Popping up on the POS screen while paying through the payment method Customer Account. The following Screenshot shows the Actual error. Here’s the Solution for the Above error. Step 1: Copy the Customer No (In this case SS-276508) Step 2: Open HQ and Search All Customers. Step 3: On the All customers page, Please press the 3 dots as shown in Below Screen Shots . Step 4: Search “nonChargeableAccount” in filter , Select the Check Box and Click Update Step 5 : Click Edit , and Select the Desired customer and untick the Non chargeable Account option. Step 6 Run 1010 1070 1090 job and Recheck on POS . Hope this Helps
How to Create Inventory Period in Business Central.
Inventory periods are used to keep track of when inventory adjusting entries are posted. Unless inventory periods are closed on a monthly basis, adjusting entries will post in the same period as the original transaction. Inventory adjustments will not be posted in that period if you create and close inventory periods. If the initial transaction was posted during a closed inventory period, the adjustments’ value is posted on the first day of the first open inventory period. This ensures that once the financial statements have been printed for a month, the G/L value of inventories, costs, and cost of goods sold do not change. CREATING INVENTORY PERIOD Many companies manage inventory the same time they manage accounting Period. Steps to access inventory period: Go to ‘Accounting Period’ Click on ‘Process’, there you find ‘inventory period’ OR You can simply Go to ‘Inventory Period’ from Global Search. STEPS TO CREATE AN INVENTORY PERIOD. Click On the search icon and enter Inventory Period, select relevant link. Create a new line In the Ending Date Field, enter the last date in the inventory period that you want to define. When the period is closed, you will not be able to post inventory changes before this date. Enter a descriptive name in the Name field. CLOSING INVENTORY PERIOD. The Closed parameter specifies whether the inventory period is closed to changes in inventory value. This field is not editable. You can close any inventory period if the following conditions are met In that time period, there are no open outbound item ledger entries, showing negative inventory. The Adjust Cost – Item Entries batch job was used to adjust the cost of all goods. This means that any outbound transaction quantities must be applied to existing inventory numbers, such as those from sales orders, outbound transfers, sales invoices, buy returns, or purchase credit notes. TO CLOSE AN INVENTORY PERIOD Before closing an inventory period, choose the Adjust Cost – Item Entries action to ensure that all cost adjustments are posted.Run the Close Inventory Period – Test report to determine if there are any open outbound item entries within the inventory period or any items whose cost has not yet been adjusted. Choose the Close Inventory Period – Test action.Run the Post Inventory Cost to G/L batch job to ensure that all costs are posted to the general ledger. Choose the Post Inventory to G/L action. On the Inventory Periods page, select the inventory period you want to close. Choose the Close Period action. After the inventory period has been closed, you cannot post inventory changes before the ending date. The cost of all items must be adjusted with the Adjust Cost – Item Entries batch job before you close the inventory period. Choose the Yes button to confirm that you want to close the period, or choose No to cancel the closing. The inventory period is closed and a confirmation message is displayed when it is finished. REOPEN INVENTORY PERIOD It is not possible to delete an inventory period once it has been closed. You can, however, reopen it if you want to allow posting before the inventory period’s expiration date. When you reopen a period, it also reopens other inventory periods with ending dates later than the reopened period. TO REOPEN AN INVENTORY PERIOD Choose the icon, enter Inventory Periods, and then choose the related link. Select the inventory period you want to reopen. Choose the Reopen Period action. Confirm that you want to reopen the period. All inventory periods with ending dates later than the period you selected are reopened. Thank you for reading. Hope this helped. 🙂