While electronic methods of payment are becoming increasingly popular everywhere for quick payments, check payments are still popular across the world, especially post dated checks, which can be cashed out only after a specified date, giving them an edge over electronic payment methods. D365 Finance has a very simple process to create post dated checks and account their entries.  Since post dated checks are cleared after a certain date, known as the maturity date, the amount is not directly accounted in the bank account, but to a bridging account instead. A bridging account serves as a ‘bridge’, for the transaction amount between the bank account and the vendor/customer account till the maturity date of the PDC. When a payment entry with a PDC is made, the system will store the amount temporarily in the bridging account till the maturity date. On the maturity date, the system will transfer the amount from the bridging account in the bank account. The accounting process of the PDC is summarized below: – For Vendor:- PDC (Before Maturity) Dr Cr Vendor XX   Bridging Account   XX PDC (After maturity) Dr Cr Bridging Account XX   Bank   XX For Customer: PDC (Before Maturity) Dr Cr Customer   XX Bridging Account XX   PDC (After maturity) Dr Cr Bridging Account   XX Bank XX   The steps to set up and use PDC are as follows: – 7. Select the Account type as Bank. 8. Enable the parameters for Bridging posting and Post Dated check clearing posting. 9. The bridge account gets selected automatically by default based on the one defined in the Cash & Bank management parameters defined earlier. 10. Do the exactly same setup in AR module -> Methods of payment as well. This concludes the setup part. Now we can proceed with the transactions. Process: – Go to Postdated Checks tab and enter the maturity date for the PDC. Until the maturity date is reached, we cannot settle the PDC. So either we can wait till that date or for the sake of testing purposes, we can set the system clock to a future date. This concludes the configuration and process for PDC in D365 Finance.

Personalization stands as a robust feature within Microsoft Dynamics 365 Finance and Operations, significantly enhancing consultants’ and users’ experiences while interacting with the platform. Among these personalization options, the workspace stands out as a feature I routinely recommend to end-users. Its advantages span from streamlining daily business activities, time-saving capabilities, and improved visibility into work items that require attention, to the crucial benefit of reducing clicks and navigation across multiple screens. In this blog, I aim to demonstrate the process of creating a new workspace and sharing it with the necessary users. Creating a Workspace To initiate the personalization of your Dynamics 365 experience, follow these steps to craft a new workspace tailored to your specific requirements: Right-click on the right side blank screen and select “Personalize TitlepageContainer.” Your newly created workspace will now appear on the dashboard. After completing the initial steps, it’s time to fine-tune the configuration to suit your operational needs: Navigate to the required form or list page that you wish to include in the workspace. Select the presentation type: Tile, List, or Link. Additionally, you can create a saved view on the required form by applying filters and then add that saved view to the workspace. For instance, from the “All Sales Order” page, applying a filter for invoiced orders and saving that view to be added to the workspace. For this blog’s demonstration, I’ll illustrate adding the “Sales Order Invoice” to the new workspace. Navigate to the “Open Invoice” page. Click on the “Options” tab within the action tab. Select “Add to Workspace.” Choose the workspace created in the first part of the blog. This showcases the output when you click on the Custom workspace in Dashboard Configure Workspace Post workspace creation and configuration, the subsequent crucial step is sharing it with the relevant user groups: Identify User Groups: Determine the teams or individuals who would benefit from accessing this customized workspace. In conclusion, creating and sharing personalized workspaces in Microsoft Dynamics 365 Finance and Operations empowers users with tailored interfaces, offering enhanced efficiency, streamlined workflows, and a more intuitive user experience. I hope these steps will guide you in optimizing your Dynamics 365 experience, boosting productivity, and attaining better outcomes for your business operations.

In any ERP, any accounting user might want to set up periodic journals on a monthly/quarterly/year basis for recording the costs of any services, like AMC charges, rents, subscription fees, etc. It can get tedious to manually create such entries every single time indefinitely. This can lead to errors and unnecessary time consumption if the entries are very long and made to multiple business partners. Dynamic 365 Finance offers an easy way out through the use of periodic journals. Periodic journals help the user create entries periodically in the system. With periodic journals, users can: The process of configuring and using periodic entries is very simple. Setup 1. First, configure a journal name with the Journal type as ‘Periodic’ as shown below: 2. Then go to General Journal -> Journal Entries -> Periodic Journals Here, we define the template for the periodic journal entry to be created in future. Create a new entry. 3. Select the date on which you want the periodic journal entry to be created. 4. Select the GL accounts and their amounts. You can create a single line journal entry with an offset account or you can create a multi-line entry with as many GL accounts as required. 5. Select the Unit. Unit stands for the period of the journal entry – days, months or years. 6. Enter the number of units. This is the frequency of recurrence of the journal entry. For e.g., if you select Unit as months and enter the number of units as 3, then the periodic journal entry will be set to repeat every 3 months from the beginning date. Working 1. Open a General Journal entry. 2. Create a new entry. 3. On the top, click on Period Journal. 4. There are 2 options – Retrieve Journal and Save Journal. Retrieve journal is used for retrieving a periodic journal that we have just setup. Save journal is used if you want to save any existing journal entry as a template for a future periodic journal entry. 5. We use Retrieve Journal to retrieve the template we have created above. 6. In the ‘To Date’, enter the date of recurrence, i.e., the date for which the entry repeats for the period. In the Periodic Journal number, select the Periodic Journal which was created earlier. In the last field, there are 2 options – Copy or Move. Copy will fetch the periodic journal data into the journal entry and update it for use in the next period. Move will also fetch the journal data but will block the periodic journal from being used in future. Use the move option if you know that the periodic journal is not going to be used anymore. 7. The system will load the data as shown below:- 8. As you may notice, the date field is as per the date selected in the Retrieve Periodic Journal, while all the other details like the GL account and amounts are fetched exactly as per the template. 9. Once you post this journal entry, the journal date in the periodic journal template will be updated to the next period, in this case, to 1st of December. 10. In order to check if the date has been updated or not, simply go to the Periodic Journal once more and check the date. As you may have noticed, the date got updated to the next period of recurrence. So when you retrieve this journal for the next time, it will fetch the journal based on this date. This can go on as many times until you select the option to Move instead of Copy. After that, the periodic journal will stop updating and won’t be able to be used again. Through this process, the user can fetch the journal entries periodically instead of creating them manually every time. While the fetching of the data is automatic, the user will have to make sure to run the periodic journals as per their dates. There is an option to automatically generate the entries in the system through Power Automate but that is a separate Add-on to be setup and configured. The standard process is just as good enough to reduce the hassle for making entries manually every period.

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 →

Introduction Activities are tasks or sorts of homework that we as a team perform when contacting a customer for example making a phone call, making an appointment or calls, and so on. You can set the status of this activity to complete pending or in progress. For more details, please follow the link: Activity entities (Developer Guide for Dynamics 365 Customer Engagement … Steps to create and add/attach a custom activity entity in D365 CRM Step 1: Log in to the required D365 CRM environment using the URL https://home.dynamics.com. by providing a username and password and selecting your environment accordingly. Step 2: Once logging into your Dynamics 365 CRM, select the model-driven app you are currently working on. In my case, it’s Sales Team Member. Step 3: Once you are in your app, Click on the Settings icon and select [Advanced Settings]. Step 4: Click on Solutions. Create a solution or go to an existing solution. Click on Entities once inside the solution and Click on New. Once you name your entity don’t forget to tick on the [Define as an activity entity] checkbox. You can also check boxes on other options according to your need. Step 5: You can also notice the other checkboxes in Communication & Collaboration column, most of the options are non-editable.It’s because we are enabling it as an activity entity. Hence, all the checkboxes related to the Custom Activity Entity get non-editable. Step 6: Now we have to add the custom activity which we created. Click on the entity with which you are working. Then go onto the Forms inside that Entity in which you are working. Step 7: In Forms, once you have done your customizations, Add the activity timeline by enabling it during the entity creation on which you are currently working (checkbox those 2 columns and that’s how you can view the activities timeline in Form). Step 8: Once done with the above step, click on Activities & Notes and you can view the Activities & Notes Timeline. Step 9: Double tap on the Notes timeline and go to Activities. Step 10: Select the custom activity which you created. In my case, it was Order Review. Step 11: Click Ok. Save and Close and don’t forget to Publish the Customizations. Once this is done navigate to the Dynamics 365 CRM Main Form. As you Can the custom entity which we created has been added. Step 12: Click on ‘Order Review’ and add the details. Also, remember you can add many fields to this custom entity as per your requirements. How to do that is by going back to the Solution and navigating to this entity(Order Review). Create or add a new field and then add the Field to the Form. Save and Publish the Customizations. Hope this Helps.!!!

Introduction Global Search for Microsoft Dynamics 365 is a custom module, which allows you to search across all CRM entities at the same time, providing results in a single-view convenient layout. For more details please follow the link: Global Search for Microsoft Dynamics CRM Online User Manual Adding an Entity and fields in Global Search On Dynamics 365 CRM Step 1: Log in to the required Power Apps environment using the URL https://home.dynamics.com. by providing a username and password and select your environment accordingly. Step 2: Once you have logged into your environment, click on the Settings Icon and select Advanced Settings. Step 3: Drop down Settings and then click on Administration. Step 4: After clicking on Administration, select System Settings. Step 5: Go onto the option Set up Search and then click on Select. Step 6: For FYI, you can select 10 Entities at a time for Global Search. So Select the 10 Entities according to your requirements. We can even sort the Entities using the options Move up and Move down. Step 7: As I have said in Step 5, the maximum number of entities that can be added is 10. Step 8: Once the above steps are done, Return to the below page and click on [Solutions]. Create a solution and add the required table which you wanted to show in Global Search. In my case, the table name is Order Fulfillment. So accordingly add your Entity/Tables. Step 9: Click on the Entity in which you are working inside the solution and click on Views. Step 10: Typically, the global search option in D365 CRM is associated with Quick Find View. Select the Quick Find Active Order Fulfilments view. Step 11: Add the Fields which are needed for View and Find Columns. FYI, in the main D365 CRM Form, the global search has the feature of displaying only the first 3 fields of that view. So insert the important 3 fields in the view first. Step 12: Once all the customizations are done, Save and publish the solution. Step 13: Return to the D365 CRM Main page of our Model Driven App and as highlighted below, click on that icon and try searching for the value of the field. For example, If you have added a field named ‘Order Number’, Try searching the value of that field. Step 14: Once I type the value, the entity in which the value has been present has shown up. For your information, only three fields will be visible once you do the global search and 10 Entities can be visible during the global search. Hope this Helps!!!

What is a SharePoint site? Sharepoint site is an application which is provided by Microsoft which can be used to store information and content. This may include documents, images videos, tasks, and so many things. For more details please follow the link Steps to create a site and integrate your SharePoint with D365 CRM Step 1: Log in to Office 365 login and open SharePoint. Step 2: Once you click on Sharepoint, go onto the Home icon and click on +Create site. Step 3: Click on Team site. My requirement is to track my project status and to share team resources and co-author content. So that’s why I select the Team site. Step 4: Enter your details for your new site and once done, click on Next. Step 5: You can also add specific members for your site(not necessary). Once done click on Finish. Step 6: Once you click on Finish, it will redirect it to your site which you created. Just copy the above link of your site which I highlighted. Just copy the link to your site. It will be used later. Step 7: Go into Dynamics 365 CRM and login in with your credentials OR mention your URL for e.g. abcde.crm.dynamics.com and then login. Once done, click on the ellipses(3 dots) and select Advanced Settings. Step 8: Drop down the Settings icon and click on Document Management. Step 9: Click on Enable Server-Based Sharepoint Integration. Step 10: In simple terms, what we are doing is integrating and validating the configuration of SharePoint. Click on Next. Step 11:  Select Online and then click on Next. Step 12: Enter the URL I previously asked to copy and paste(In Step 6). Paste that link here and click on Next. In the Next Step, it will validate that site. After that click on Finish and wait for 3-4 mins. Step 13: After Refreshing you will observe that Enable Server-Based Sharepoint Integration section has changed to One Note Integration. This means that your SharePoint has been enabled and what’s remaining is to add the entities which need to be stored in Sharepoint. Step 14: In Order to do that, click on Document Management Settings. Step 15: Select the entities which you want to enable for the Document Management System. Step 16: If you want a folder structure based on a certain entity you can check the option Based on entity and select the entity you want. Step 17: Click OK to continue. Step 18: FYI the status is showing me cancelled since I have already created the document management system for these selected entities previously. In your case, the status will show completed if you are doing it for the first time. Step 19: Go onto your SharePoint site and click on Site contents Step 20: Here you can view all the entities which were selected for the Document Management System. Hope this Helps!!!

Introduction In my previous blog, I explained the required Quality Management setups. In this blog, I will execute the Quality Management process with two scenarios; in the first scenario the Products passes all the Quality Control process, and in the second scenario will be where the Products fail a Quality Control Process. To address the Second scenario, two products will be selected, specifically Brake Pads from two distinct manufacturers. All the setups that I showed in my previous blog will remain the same. To execute the second scenario, I will take two products from two different manufacturers. And an additional Item Sampling has been created for the second product. Execution: (Scenario 1) As all the necessary setups are completed let’s test this by creating a Purchase Order for quantity 10. As per the Quality Association setup the Quality Order has been created after product receipt generation. So now until the Product passes the Quality Test, the Purchase order cannot be Invoiced since the Event Block is set to Invoice. Here the Quality Order is generated for 5 qty since the Item Sampling is 50% so the entire 5 qty needs to pass the Quality Test as the acceptable level is 100. Select the Test and then click on Results to fill in the Test Results for the Product: Brake Pads. In the Results Page, in the Results Quantity enter the Quantity which passed the quality test. Then select the Outcome and you can see a right tick in the Test Result column which means that the product has passed that particular Quality Test. Repeat this process for all the Tests. The Next step is to validate the Quality Order. For that click on Validate from the top of the screen. Here I have disabled the Quarantine upon Validation failure because my product has passed all the Quality Tests so there is no need to enable that parameter unless it fails the Quality Tests. Now since my Product has passed the quality order, I will now be able to generate the Purchase Order Invoice.   Notice how the Quality Order status changes from “Open Quality Order” to “Closed Quality Order”. Scenario 2 As I explained at the beginning of my blog, in this scenario, I will take two products from two different manufacturers (P-000017 and P-000018) and one of them fails the Quality Tests. The products that failed to pass the Quality Order will be transferred to the Quarantine Warehouse for further processing. The Quality Association has been set up for both the Products. For Product P-000017 the Item Sampling is set to 50% and the AQL is set to 100 and for Product P-000018 the Item Sampling is set to 100% with Full Blocking Parameter enabled. Quality Order Processing As per the Tests defined for both Items, the product P-000017 has failed the test as the acceptable quantity defined is 100 for all the tests. And for the other Product that is P-000018 has passed all the Quality Order tests. Refer below screenshot to view the failed Tests of product P-000017. In the above screenshot, you can see that only 1 quantity of product P-000017 has passed the test and the other 2 quantity has failed to pass that particular quality test which ultimately leads to Quality Order failure. Same is the case with the other two tests as well, which clearly state that Product P-000017 has failed the Quality Order process. Now you can see that Product P-000017 has failed the Quality Order process so it is necessary to move this stock to a different location where it will be further inspected. This process of segregating stock is referred to as Quarantine. Quarantine Management Quarantine management in Dynamics 365 Finance and Operations refers to the process of isolating and controlling items that are suspected of having quality issues or non-conformities. The quarantine management system helps track and manage these items, allowing for proper inspection, testing, and disposition decisions. It ensures that only items meeting quality standards are released for further use or shipment, while those in quarantine undergo necessary actions, such as testing, repair, or disposal, to address any identified issues. A new separate Warehouse should be created in the system to transfer the products that fail the Quality Order process. This warehouse is called a Quarantine Warehouse. Attach this warehouse with a warehouse that you are going to use for transactions under the Quarantine Warehouse drop-down option. Quarantine Process As the Product P-000017 has failed the test it needs to be transferred to the Quarantine Warehouse. To do that click on Validate from the top of the screen and then enable the Quarantine upon Validation Failure parameter and then click on OK. In the below screenshot, you can see that as I clicked on OK, the System automatically generated a Quarantine Order. Now if you go to that released product and click on Transactions under the Manage Inventory Fast Tab you can see that the Product P-000017 has been deducted from W1 and has been received in the Quarantine Warehouse. Depending on the product type and inspection results, an item can be repaired to make it acceptable or returned to the vendor if it is deemed unfit for use. If there is an agreement with the vendor, and permission is granted, the item can be directly scrapped from the quarantine warehouse using the Scrap functionality. If the items are to be returned back to the Vendor in such a case the inventory must be first returned to the default warehouse. A specific location can be defined in the Default Warehouse for this purpose. In this scenario, I am assuming that the product was repaired and deemed fit for use after Quarantine Inspection. Now in order to receive this inventory in the Main Warehouse(W1) we need to use the Item Arrival Journal. 1. The first step is to open that Quarantine Order. 2. Click on Report as Finished from the top of the screen. 3. Click on End from … Continue reading Quality Management Process in Dynamics 365 Supply Chain Management – Part 2 →

Introduction Hello Everyone! In this blog, I will explain the Quality Management Process in Dynamics 365 Supply Chain Management and cover all the necessary setups required for Quality Management. Imagine a supply chain where every component, every process, and every product meets or exceeds customer expectations. Where defects and delays are minimized, and customer satisfaction soars. This is the power of quality management in Dynamics 365 Finance and Operations. For this blog, I have taken the example of an Automobile company that purchases the Product Brake Pads from the Vendor. When car brake pads are received in a warehouse against a purchase order, they undergo specific quality checks, similar to other products. Setup required for Quality Management Process in Dynamics 365 SCM The first step is to enable the Quality Management parameter. The pathway for that is: Inventory Management>Set Up>Inventory and Warehouse Management Parameters. Step 1: Creation of Test Instruments: Depending on the Product Type we must create different Test Instruments to conduct quality tests on the Product. So here I need to create these instruments for my Product Brake Pads. To create Test Instruments, Go to Inventory Management>Set Up>Quality Control>Test Instruments. Now click on New from the top of the screen then enter the Name, Description, and Unit of the Instrument. Here I have created three different Test Instruments for the product Brake Pads. The Precision here is linked to the Unit which can be edited in the unit setup. Step 2: Creation of Tests: Now, the next step is to create the Tests in the system which I will use to check the Quality of the product Brake Pads. So as per my requirement Brake pads will be Tested for the following tests. Note: There are two types of tests: To create Tests in the system, go to Inventory Management>Set up>Quality Control>Tests. To create a Test click NEW from the top of the screen. Then enter the name and description of the Test. Then select the Type and Test Instrument. Follow these steps to create all the required Tests in the system. Step 3: Creation of Test Variables: The Test Variables page allows you to configure, modify, and observe the potential results for a test variable linked to a qualitative test. When selecting an outcome as a test result, you assign a Pass or Fail status to each outcome to indicate whether the test has been passed or failed. It is always better to define a minimum of two outcomes that is one with a Pass status and one with a Fail status for each variable. There are no restrictions on the maximum number of variables or outcomes that can be specified. Moreover, multiple tests can utilize the same test variables to record results. To create Test Variables, go to Inventory Management>Set Up >Quality Control>Test Variables. Step 1: Click on NEW from the Action Pane at the top of the screen, then enter the name and description of the Variable. To make it easy to understand here the Variables are created similar to the Test name. Step 2: The next step is to enter the Outcomes. For that select the Variable and then click on Outcomes from the Action Pane which is at the Top of the screen. Step 3: In the Test Variable Outcomes page click on NEW from the top of the screen. Then enter the Name and Description of the Outcome. When the outcome is selected as a test result, choose either Pass or Fail to indicate whether the test has been passed or failed. Repeat Steps 1, 2, and 3 to create multiple Test Variables and their Outcomes. Item Sampling According to the Business Requirement you must specify the sample size for testing which can be indicated as a percentage or a fixed quantity. In this scenario, the entire quantity received in the stock from the Purchase Order will be selected for testing. So in this case I will establish item sampling for the entire quantity, representing 100% of the items. Full Blocking Parameter under Item Sampling The Full Blocking parameter is enabled on the basis of business requirements. For example, if I create the item sampling as 10% and if I receive 100 qty so among them only 10% qty will be taken for testing. In such a case if I enable the full blocking parameter, even though I will be testing only 10% of 100 qty the system will automatically block the rest of the 90% of the quantity as this option is enabled. But if this parameter is disabled then only 10% of the qty will be blocked for quality inspection and the rest of the 90% qty can be used for consumption. Per Updated Quantity Parameter under Item Sampling Enabling this feature ensures that a Quality order will be generated specifically for the quantity received in a Purchase Order, whether it is a complete or partial quantity. For example, Item sampling is set to 100%, If the Purchase Order quantity is 100 and the Per Updated Quantity parameter is enabled and if I received a partial quantity that is 50, in such a case the Quality Order will be generated for 50 quantity and not for 100 quantity as the Per Updated Quantity parameter is enabled. But if this parameter is disabled and if I receive a partial quantity of 50 the Quality Order will be generated for the entire 100 quantity. Now to Create Item sampling the pathway is Inventory Management>Set up>Quality Control>Item sampling. In the Item Sampling page click NEW from the Top of the screen. Then enter the name and description of the sampling that you want to create. In the above screenshot, you can see that I have created an Item sampling of 100%. Under the name and description field, you can see the Sampling Quantity field in which I have selected the Quantity Specification as Percent. You can either select Percent or Fixed Quantity depending on the business requirement. Here I have defined the value … Continue reading Quality Management Process in Dynamics 365 Supply Chain Management (SCM) – Part 1 →

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!