In the previous part of my blog, I explained about the Credit Only process. In this part of my blog, I will go through the Physical Return process. The Physical return process is determined based on the Disposition Code that is assigned to that Return Order. Disposition Codes in D365 Finance and Operations: Disposition codes in Dynamics 365 Finance and Operations (D365FO) are essential tools used to categorize and manage returned items. These codes help businesses decide what to do with products that customers send back, whether it’s restocking, repairing, or scrapping them. By using disposition codes, companies can streamline their return processes, maintain accurate inventory records, and ensure that returned items are handled efficiently and appropriately. This not only enhances operational efficiency but also helps in improving customer satisfaction by managing returns in a clear and organized manner. Below is the List of Dispositions Codes that are available in D365 FNO: These Disposition codes are available as Standard Functionality in D365 FNO.  You can also create new codes based on the business requirements. In this part of the blog, I will walk you through the Replace Item and Credit Customer scenario. Let’s take a scenario where we have sold 5 items to the customer and after delivery the customer does the Quality check in which 2 products fail due to quality issues. The customer has Scrapped those products on our behalf and now we will provide the customer with the replacement items. For that: Go to Sales and Marketing>Sales Returns>All Return Orders. On the All return orders page click New to create a New Sales Return Order. Select the Customer for which the Return Order is to be created. Enter the Site, Warehouse, RMA number and other details and click OK. In the first part of the blog I created the Return order using the Find Sales Order function so in this part I will directly add the line with negative quantity. In the below screenshot you can see that I have added a line for the Product P-000015 with negative quantity. The next step is to register the Line with the Replace and Credit customer Disposition code. For that click on the Update Line option in the Lines tab then from the drop down click on the Registration option. Then from the Disposition Code drop down select the Replace and Credit Customer option. Then add the registration line then click on Confirm Registration. In the below screenshot you can see the Line status is changed to Registered and the Return order status is changed to Open. Now if you go to the All-Sales Order Page you can see that a New Sales Order is created with the Order type as Returned Order with the Status as Open Order. Now if you open the Sales Order and check the lines the quantity of the line will be exactly same as that of the Return order. The next step is to create a Replacement order as we have selected the Disposition Code of Replace and Credit. For that click on Update Line and Click Registration which will change the Line status from Registered to Expected. As you do this you will notice that the Post Packing Slip button is now disabled, and you can see that the Replacement Order button is now available. As our disposition code is Replace and credit Customer the next step is to create a Replacement Order. For that click on the New Replacement Order button. Add the same site and Warehouse as Return order and click Ok this will create a Replacement Order. After Replacement Order is created go back to the Return Order again and Click Registration and select the Credit disposition code which will Credit the Amount back into the Customer’s account. Now after that Post the Packing slip for the Return order which will change the Return Order status to Received. Then go ahead and Invoice the Return Order from the All-Sales Order page which will again change the Return Order status to Closed. Then go ahead and process the Replacement Sales Order. If you go to the Customer transaction and check, you can see that the Amount is credited back in to the Customer Account. So, this completes the Sales Return Process of Return and Credit to customer. We hope you found this article useful, and if you would like to discuss anything, you can reach out to us at transform@cloudfronts.com

In D365 Finance and Operations, managing transfer orders is a crucial aspect of maintaining efficient inventory operations. However, there may be instances where you need to cancel a transfer order shipment due to various reasons such as changes in demand, inventory discrepancies, or operational adjustments. In such cases, it is essential to understand the process of cancelling the transfer order shipment to ensure accurate inventory management and smooth operations. Here are the steps to cancel the transfer order shipment in D365 Finance and Operations: Go to Inventory Management>Out Bound Orders>Transfer Order. Here, I have already created the Transfer Order which is in Created State. Here, I am transferring the Items from (Warehouse W1 to Warehouse W2). The next step is to ship the Transfer Order. In the below screenshot you can see that the Transfer Order has been Shipped. As the Transfer Order is shipped the following Transactions are posted. Now to Cancel the Transfer Order Shipment. In the Transfer Order tab click on Transfer Order History which is under the View Action tab. Here you can see the Transfer Order Shipment. Select that and then click on the Cancel Button from the top of the screen. By clicking this the system will automatically reverse the Transaction. You will see that a Reverse entry is posted with negative quantity and there will be a right tick under the Cancelled Shipment column. Now if I go to Transactions, I can see that the entry has been reversed and the Transfer Order status has been reverted back to Created. Note: The Transfer Order which has been received cannot be Reversed by this process. Transfer Orders which are only in Shipped state or transfer orders where in Shipment has been sent can only be cancelled or Reversed. Depending on your system configuration you may need to manually adjust the Inventory. That’s it for this blog! Hope that helps, thank you for reading!!

In Dynamics 365 Finance and Operations (D365 F&O), the use of batch numbers is a common practice to manage and trace items with specific characteristics. Batch numbers are typically assigned to groups of items produced or received together, allowing for better control, tracking, and compliance with industry regulations. In this blog I will explain how to solve the expiration date issue while registering a Batch and Serial number tracked product. In the above screenshot you can see that the Batch Number 23010-CM-000088 has been assigned for my Item P-000014. Here, the Expiration Date is 08-04-2023. Now if I try to register this Item with the same Batch Number, I will get the Batch Number Expiration Date being past the Required Date error. Now to solve this error go to Inventory Management>Enquiries and Reports>Tracking Dimensions>Batches. Now on the Batch Number page go to Reset Tab then under the Reset tab click on Reset Shelf-Life Dates. The next step is to select the New Expiration Date and then Click Ok. This will Update the Expiiration Date of that Batch Number. In the above screenshot you can see that the Expiration Date has been changed. Now we will be able to register the Item. Here, you can see that now I am able to register the Item successfully. That’s it for this blog. Hope this helps you! Thank You!

Hello Everyone!!! In this blog I will explain the Quarantine Management process in Dynamics 365 Supply Chain Management.  Here the Product was first received in the Main warehouse and then it was moved to Quarantine Warehouse for further inspection as the Product failed to clear the Quality Test. In this blog I will explain a scenario where the Products should be directly received in the Quarantine Warehouse for inspection and after final inspection it turns out that all the products fail the inspection so, a few products will be scrapped and the rest will be returned back to vendor. What is Quarantine Management? The quarantine management process in D365 aims to effectively manage and control quality issues, ensuring that only items meeting the required standards are released for use or distribution. The quarantine management process in Dynamics 365 is a systematic approach to handling items that are suspected of having quality issues or non-conformities. When an item is flagged for quarantine, it is physically segregated from the regular inventory and moved to a designated quarantine location. The quarantined item undergoes thorough inspection and testing to assess the extent of the quality issue. Based on the evaluation, decisions are made regarding the item’s disposition, which may include repair, return to the vendor, or scrapping. If the item is repairable, necessary actions are taken to rectify the identified issues. In cases where the vendor is responsible, the item can be returned for resolution. Once the necessary actions are completed, and the item meets the required quality standards, it is released from quarantine and reintegrated into the regular inventory for use or distribution. This process ensures that only items meeting quality criteria are allowed for further processing, while mitigating the risk of non-conforming products entering the supply chain Let’s start with the setups first: Step 1: Map the Quarantine Warehouse to the Main Warehouse. For that the Pathway is: Go to Inventory Management>Set Up>Inventory Breakdown>Warehouses. Step 2: The next step is to Enable the “Quarantine Management” parameter in the Item Model Group Quarantine Management Process: The below Purchase Order CM-PO-0000137 has been received in the Quarantine Warehouse as per the setup, hence a Quarantine Order CM-0000142 with 9 quantities has been created. Now if I go to the Quarantine Orders page, I can see that a new Quarantine Order has been created. The below screenshot shows the Transactions that took place after the Product Receipt was posted. After Inspection it was found out that 5 quantities were damaged, 4 quantities were to be returned back to the Vendor which means that all the 9 quantities failed to pass the Quality Inspection. So, what I will do is Scrap the 5 quantities and return back the 4 quantities to the Vendor by creating a Purchase Return Order.  Now I will split the Quarantine Order CM-0000142 into 2 separate Quarantine Orders. For that I will use the Split function which is available at the Top of the screen under the Functions Tab. In the above image you can see that I have split the Quarantine Order CM-0000142 into 2 different Quarantine Orders that is CM-0000143 and CM-0000144 for further processing. Now let’s begin the further processing. To scrap this order, I will use the Scrap functionality. To Scrap this order, click on Function and then select Scrap. Here, you can see that the Quarantine Order CM-000143 has been ended as it has been scrapped. 2.  Return the Items back to vendor: Now in order to return the Items back to vendor I will first the Invoice the existing Purchase Order which is CM-PO-0000137. Then I will receive the Items from the Quarantine warehouse to the W3 warehouse. Below you can see that I have invoiced the purchase order CM-PO-0000137. Now let’s receive the items from the Quarantine Warehouse to the Central Warehouse, for that I will use the Arrival Journal. As you can see that a New Arrival Journal has been created. Validate and Post the Journal. Vendor Return Process: After posting the Journal create a New Purchase Order with the type as Return Order.  For that go to Procurement and Sourcing>Purchase Orders>All Purchase Orders. Then select the Vendor to whom the Items will be returned and select the Purchase Type as Return Order. Enter the Site and Warehouse from which the Items will be returned back to the Vendor. Then enter the RMA number provided by the Vendor and then Click OK. Click on the Purchase Order line, select Credit Note, choose the specific invoice, input the quantity as a negative value, and then click OK. In my case the Invoice Number was 311711, so I will select that and then click OK. Then proceed with the normal purchase order processing which will be Product Receipt and Invoicing. After Invoicing the Return Order aa credit note will be  created which will be  deducted from the Vendor Balance. The below screenshot represents the On hand List before and after posting the Return Order Invoice. In the above screenshot you can see that the On hand Quantity changed from 26 to 22 since 4 quantities have been returned back to vendor. That’s it for this blog. Hope this helps you! Thank You!

In today’s fast-paced business environment, efficient workflow management is essential for organizations to stay competitive.  Workflow email alerts help organizations stay on top of important business processes by automatically notifying designated individuals when certain tasks are completed or when specific conditions are met.  In this article, we will provide a step-by-step guide for setting up workflow email alerts in D365 FO. Before getting started, it’s important to ensure that email parameters are configured correctly and that you are able to receive test emails from D365 in your inbox.  To check this, navigate to System Administration> Setup > Email > Email Parameters.  1. In the configuration, Enable the email provider as per your requirement.  2. If your using the SMTP setting then enter the outgoing server information, and SMTP port and enable SSL/TLS required button. Set up an email address for the user who will receive alerts and enable workflow email alerts for that user. To accomplish this, go to the System Administration section, select Users, and then click on Users. Highlight and click on the user you wish to enable email alerts for.  If no email address is attached, enter the user’s email address. To enable email notifications, go to ‘User options’ on the ribbon, then click on ‘Workflow’ on the left side and set the option to ‘Send notifications in email’ to Yes. Create an email template or email message. Templates are generic and can be configured while configuring workflows.  Navigate to System Administration> Setup > Email> System email templates. Here you can create a template, such as “Workflow emails.” Assign your email template to the specific workflow. To configure the workflow email alerts, you can navigate to the workflow for which you want to send email notifications, Open that workflow access the basic settings, and choose the relevant workflow template from the dropdown menu. Configure the necessary notifications for the particular task, control, or approval while setting up the workflow steps. Here, you will specify the notification content which will be sent to the user in the email. Configure the batch job to distribute the email notifications. Navigate to System administration > Periodic tasks > Email processing > Email distributor batch.  Since we are now adding a batch job, it can be scheduled to run automatically at specified intervals. To schedule autorun, adjust the ‘Recurrence’ settings as per the requirements. Monitor email sending status. To access the E-mail Sending Status page, go to System administration > Periodic tasks > Email processing > Batch email sending status.  Here, you can monitor successfully sent, pending, or failed email messages. In conclusion, configuring workflow email notification alerts can be a simple yet effective way to stay on top of important business processes.  By following the above steps, you can set up workflow email alerts in D365 FO and start reaping the benefits of streamlined workflow management. Thank you for reading my blog!

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 In any business organization, financial dimensions play a crucial role in identifying the posting routine of payments, sales, purchases, and other transactions in the ledger account.  Microsoft Dynamics 365 Finance and Operations (D365 F&O) provides the functionality of financial dimensions to help users identify the posting routine with details of the transaction.  However, in the retail industry, financial dimensions need to be configured differently as compared to other industries.  In this blog, we will discuss the importance of financial dimensions in the retail industry and the steps to configure financial dimensions for retail stores and payment methods. Importance of Financial Dimensions in the Retail Industry In the retail industry, financial dimensions are used to categorize transactions such as sales, refunds, discounts, and payment methods.  These financial dimensions help the finance department to analyze the financial data and create reports to monitor the financial health of the retail store.  For example, a retail store can create financial dimensions for different payment methods like credit card, cash, and check.  This will help them to identify which payment method is used the most and which payment method is generating more revenue for the store. Another use of financial dimensions in the retail industry is to track sales by product category.  A retail store can create financial dimensions for product categories like electronics, clothing, and accessories.  This will help them to analyze which product category is selling the most and which product category needs more attention from the store. Steps to Configure Financial Dimensions for Retail Stores and Payment Methods Payment Methods To configure financial dimensions for payment methods in retail stores, follow the below steps: Step 1: Go to Retail and Commerce > Channels > Stores. Step 2: Click on the Action tab and select Set Up > Payment Methods. Step 3: Select the desired payment method, and in the details tab, you can find financial dimensions. Step 4: Map the financial dimensions to the payment method and save the changes. Stores To configure financial dimensions for retail stores, follow the below steps: Step 1: Go to Retail and Commerce > Channels > Stores > All stores.Step 2: Select the desired store that you want to set the default dimensions on the bottom as shown in the image. Step 3: Enabling this will overwrite the financial dimensions that were enabled on payment methods as this will be set as default dimensions for all types of transactions. Conclusion In conclusion, financial dimensions play a crucial role in the retail industry, and configuring them properly is essential for the finance department to analyze financial data accurately.  Microsoft Dynamics 365 for Finance and Operations provides the functionality of financial dimensions for retail stores and payment methods, and configuring them is a straightforward process. By following the above steps, a retail store can easily configure financial dimensions for their stores and payment methods and analyze their financial data accurately.

Introduction Any product that is manufactured has a Manufacturing date as one of the important aspects, as based on manufacturing date many other parameters are defined. i.e. Warranty date, Expiry date, etc. In our day-to-day life, there are many items for which expiry date is very important. i.e. dairy products, packed food items, medicines, etc. While for other items expiry date is not important but warranty date is important. i.e. Electronic items, any other products having warranty, etc. Hence, manufacturing date plays an important role for both consumer as well as manufacturer. Problem Statement In scenario where batch no. need to create in advance before actual receipt. & while creating batch no., Manufacturing date (25 May) is assigned but once saved it can’t be changed from same screen. Solution Steps It can be changed from registration screen. To do that need to do below 1 step setup. 1. Setup -> Released item -> Manage inventory (Tab) -> Batch number group -> Remove (To avoid automatic batch creation) Setup -> Released item -> Item model group -> Edit -> Inventory policies (Tab) -> Purchase registration -> Tick mark -> Save 2. Create PO -> Add line 3. Select line -> Update line -> Registration 4. Add registration line 5. Batch number -> Select above created batch number -> Confirm registration 6. New form of Vendor batch details will open – Batch details (Tab) -> Vendor batch date -> Can select Today’s or past date (Selected 28 May) -> Use as manufacturing date -> Tick mark (Then manufacturing date will be overwritten) -> Save. 7. Now all dates will change accordingly. We can go in respective batch & check, new manufacturing date (28 May) is reflecting. And we can receive the material as per updated manufacturing date.