Each time I attempt to export a solution from the source environment to another environment, I receive the following notification “isGlobal information provided True doesn’t match the value stored in DB False.” As a result, importing the solution into the destination environment becomes challenging for the individual. Whenever this kind of error appears, it has to do something with the fields on the form. This happens when you mistakenly make changes in the Production environment instead of making changes in the Developer environment or Vica Versa. Normally, the procedure is to make changes (e.g., Adding fields or any other customizations) in the Developer Environment and then export those changes to the Production Environment. Once those changes are imported into the Production environment, after cross-checking you realize many more fields are to be added. So we started to create and add fields in the Production environment instead of the Dev environment and that is how a mismatch of errors occurs with Fields and thus it gets difficult to export/import a solution in other environments.   To avoid this error, below is the blog you can refer to. Step 1: Log in to Power Apps using your credentials. Try to check both your source environment as well as Destination Environment. Step 2: In order to check the same, Go to Solutions and click on Default Solutions. Step 3: Go onto the table/Entity in which you are currently working. In my case, My table/Entity is Students. Step 4: Try to check the latest field which you have added. In my case, the name of the field is Courses Offered. Step 5: Click on Edit table column. Step 6: As you can see, my Destination environment (Production Environment) consists of the below field (Courses Offered), which is a Global option set Field. Step 7: Whereas my Source Environment (Developer Environment) has the same field name called “Courses Offered” which is an ‘Option Set field’. So, Delete the old option set field from this environment and try again to import this solution to the other environment. Step 8: The Difference between a Global option Set and a normal Option Set is that a global option set can be used globally for all entities/tables. But an option set field can only be used for that specific table. For eg If my entity/table name is “Students”. I can only use my option set for that specific entity. Step 9: In order to avoid the error, download that error log and try to open it via Excel and try to rectify all the fields from that Excel sheet via both environments. 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

Hello everyone, in this series of Blog, we are going to learn about the Advance warehouse management in D365.  In this blog we will learn about the basic setups required for the Advanced Warehouse Management process. These setups may vary depending on the business scenarios. As a continuing blog from https://www.cloudfronts.com/blog/advance-warehouse-management-item-creation-part-1/ and https://www.cloudfronts.com/blog/advance-warehouse-management-warehouses-and-locations-in-microsoft-d365-fo-part-2/, this is will be a part 3 of the series. The following are the setups that we need to configure:  Load:  The loads are useful when we group multiple shipments. So, you can consider load as an object that will be used to transport the material.  Path:   Warehouse Managementà SetupàLoadà Load Templates  I have created two containers here as a load. One is a 20 ft container, and the other is a 40 ft container.  Location Directives:  The Location Directive plays a significant role in inventory movement in advanced warehouses. Location Directives are the set of rules which define the pick and put, Counting, License Plate building, Status change and Quality check etc. for individual warehouse or group of warehouses.  For my current scenario, I will create location Directive for a Purchase Order transaction. In further blogs I will write about other transactions as well.  Select the Work Order type as Purchase Order.  Select the work type as “Put.” For the receipt location, I have mentioned the default receipt location in the warehouse master.  For default receipt location, Go to Warehouse managementà Setupà Warehouse à Warehouses.  Select the default receipt location from the Drop down.  Select the Warehouse for which this “Put” rule going to work. You can group the warehouse and select the warehouses to work similar to the rule.  In the lines I have mentioned the from Quantities and to quantities.  For location directive action, I am using “Only fixed locations for the product.” By this, the system will ask for the location while Putaway operation in the Purchase Order.  Now, the Loads and location directives are ready to use in Advance Warehouse process.  That’s it for this blog!!  How to use these Loads and location directives in actual transaction will be discussed going forward in the blog series.  Keep learning!!!!!  Next in the Blog series:  How to create Work Classes and Work Templates in Advance warehouse management in D365.  How to set up Worker in Advance warehouse management in D365. 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 inventory management, there often arises a need for flexibility, especially when dealing with orders that exceed current stock levels. Dynamics 365 Finance and Operations offers a solution to this challenge through enabling physical negative inventory.   This functionality allows organizations to create sales orders even when inventory levels are insufficient, catering to scenarios where a stock may be incoming or when manufacturing units are involved.  Purpose of Physical Negative Inventory:  Some organizations encounter situations where they must fulfil customer orders despite lacking sufficient inventory on hand. This could be due to various reasons such as pending stock arrivals or the need to initiate manufacturing processes upon order placement.   Enabling physical negative inventory facilitates the creation of sales orders under such circumstances, ensuring business continuity and customer satisfaction.  Process to Enable Negative Inventory:  Enabling physical negative inventory involves configuring settings within Dynamics 365 Finance and Operations. This can be achieved through the following steps:  Navigate to Inventory Management > Setup > Inventory > Item Model Group.  Within the Item Model Group, allow for physical negative inventory.  For further insights into this process, refer to our previous blog post on https://www.cloudfronts.com/blog/d365-enterprise/d365-finance-operations/physical-negative-inventory-dynamics-365-operations/ can provide additional guidance.  Necessary Steps to Manage Physical Negative Inventory:  Once physical negative inventory is enabled, it’s essential to adopt proper procedures for its management to maintain accuracy and efficiency.   • Ensure Availability of Physical Inventory during Shipment: Before shipping any items, verify the presence of physical inventory in stock. Only proceed with the shipment if the required items are physically available.  • Transfer Stock if Necessary: If the required stock is not available at the shipping warehouse but exists in the main warehouse, initiate a transfer process to move the items accordingly and receive that in a shipping warehouse.  • Periodic Inventory Closing: Implement regular inventory closing procedures to ensure accurate inventory valuations.  Issues Faced by Organizations if Proper Procedures Are Not Followed:  Failure to comply with the proper procedures can lead to various issues, including:  Invalid Cost Value of Items: This can result in an inaccurate inventory valuation, subsequently affecting main accounts and profit estimation.  In conclusion, by following these steps, organizations can effectively manage physical negative inventory within Dynamics 365 Finance and Operations, ensuring smooth operations and accurate inventory valuations.  We hope you found this article useful and if you would like to discuss anything you can reach out to us at transform@cloudfonts.com 

Hello everyone, in this series of Blog, we are going to learn about the Advance warehouse management in D365.  In this blog we will learn about the basic setups required for the Advanced Warehouse Management process. These setups may vary depending on the business scenarios. For a Warehouse to work in an Advance warehouse scenario, there are some prerequisites that we need to do first. The following are the setups that we need to configure:  Path: Inventory Management Inventory Breakdown Warehouses.  Click on New. Enter the warehouse and Warehouse name.  Most importantly, for warehouse to work in a advanced warehouse scenario, we have to enable the “Use warehouse management processes”.  For advanced warehouse management, the location plays an important role for better inventory visibility and item tracking. For this, we need to do multiple setups as per below.  In the location type, I have mentioned four main locations. These are Baydoor, Floor, receiving and User.  These locations will increase or decrease as per business scenarios.  Recv: This location I am using primarily for entry of the goods/items in the warehouse.   Floor: This location I am using for storing the goods/items in the warehouse.  Baydoor: This location I am using for exit of the goods/items from the warehouse.  User: This location I am using for default. This user location will be used in the Warehouse management parameter, in User Location profile.  Location formats are used as the naming system by which we can create the unique and consistent names for different locations within the warehouse.  Here, I have mentioned the length as 1.   The location profiles will be used for connection between location type, Location formats and the locations. The location profiles are very important setup because the location capacity can be mentioned here. Also, how the inventory is stored in the location, and how the inventory is getting accessed is also dependent on the location profiles.  Here, I have enabled User license plate tracking, allow mixed items, Allow mixed inventory statuses, Allow mixed inventory batches.  Click New. Select warehouse from the drop-down menu. Enter location name as per requirement. Select the Location profile ID from the drop-down menu.  We can add as many locations as we want.  Now, the warehouse and locations are ready to use in Advance Warehouse process.  That’s it for this blog!!  How to use these warehouses and locations in actual transaction will be discussed going forward in the blog series.  Keep learning!!!!! 

Hello everyone, in this series of Blog, we are going to learn about the Advance warehouse management in D365.  What is Advance Warehousing Process?  The day-to-day transactions in the advanced warehouse are a bit different than in a normal warehouse. Workers in the advanced warehouse use mobile devices to move stock from one location to another. Here location doesn’t mean just the location, we can move it from one warehouse to another. So, instead of sitting in one place, workers can move around the warehouse to pick up or put the stock. In Advance warehouse management, the visibility of the stock is very clear. Workers can see where the stock is in the warehouse and in what quantity. This results in Streamlined warehouse operations, reduced inventory carrying costs, and thus improvement in customer satisfaction through faster and more accurate order fulfillment.  In this blog we will learn about the basic setups required for the Advanced Warehouse Management process. These setups may vary depending on the business scenarios. For an item to work in an Advance warehouse scenario, there are some prerequisites that we need to do first. The following are the setups that we need to configure:  Path: Product Information Managementà Dimension and Variant Groupsà Storage Dimension Groups.  In the Storage dimension group, activate the “Use warehouse management process.”   Once you activate the use warehouse management process, the Location, Inventory Status, License Plate will be automatically activated.   2. Reservation hierarchy   Path: Warehouse Management à Setupà Inventoryà Reservation Hierarchy.  A reservation hierarchy helps delay specific reservation details until after you’ve placed an order. This hierarchy relies on item-related factors like inventory status and license plate for storage and tracking. While it’s essential to have site, warehouse, and inventory status information during the ordering process, certain details like location can be added after making reservations. For instance, the warehouse management system can identify the best locations for picking based on this reservation hierarchy.   3. Unit sequence groups Path: Warehouse Management à Setup à Warehouse à Unit sequence groups.  Unit sequence group is mandatory setup which works when dealing with movement of material. Now take one example: If the Unit sequence group is mentioned as Each and Box, then While making product receipt from a Purchase Order, mobile device will show the options to receive the materials in two different units which are Each and Box.  Here based on my scenario, I have mentioned the default unit for Purchase orders and Transfer Order as Box.  Now, the Item is ready to use in Advance Warehouse process.  That’s it for this blog!!  How to use this item in actual transaction will be discussed going forward in the blog series.  Keep learning!!!!!  Next in the Blog series:  How to create Warehouses in Advance warehouse management in D365.  How to create Locations in Advance warehouse management in D365. 

Introduction In this blog, we’ll be looking into creating a new environment for D365 Finance and Operations or D365 Commerce. Pre-requisites References Configuration Go to Microsoft Dynamics Lifecycle Services and log in with your account. If you select D365 Commerce, you get the following screen. If you select D365 Finance and Operations, you get another screen where you have to specify whether the project is an actual implementation or just for evaluation after which you get the same screen as below. Once the Project is created, we get the following screen. From here, we click on the hamburger menu at the top and then click on Cloud Hosted Environments. Click on Add to create a new environment. If you get the below pop-up asking to configure an Azure Connector, please refer to my blog – “Configure an Azure Connector in LCS”. Once, you have an Azure Connector configured, you can click on Add again and get the following pop-up. After selecting the Application and Platform version, you’ll get the option to select the environment topology. DEMO – A demo environment includes only Microsoft demo data. You can use a demo environment to explore default features and functionality. DEVTEST – A DevTest environment is for development or build. You can use this environment for development or build. Then we get another pop-up to select the environment topology. After that is selected, we decide the environment name and the size of the VM that is to be used for this environment. You can read more about VM sizes here – VM sizes – Azure Virtual Machines | Microsoft Learn Once we click on Next we get the last pop-up after which the environment gets deployed. Once we click on deploy, it takes about 6-8 hours to deploy the environment after which it’ll be available in the cloud-hosted environments section. If, for some reason, you try to create an environment with the latest platform and application version and that deployment fails, you can try to create an environment one platform/application version below that. Conclusion Thus we saw how to create an environment in LCS for either D365 Finance and Operations. Happy Coding!

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!

Introduction: This comprehensive guide provides administrators with a step-by-step process for restoring Microsoft Dynamics 365 Business Central environments to a previous state within the retention period. Users with Restore Permissions: Only specific users, such as internal and delegated administrators, can restore environments. These users must also have the D365 BACKUP/RESTORE permission set in the relevant environment. Considerations and Limitations: Environments can be restored up to 10 times per calendar month. Restoration is limited to the same Azure region and country as the original environment. Preparation before Restoration: Before restoring an environment, it’s essential to communicate the plan within the organization, restrict user access, and consider renaming the environment to avoid conflicts. Restoration Process: 3. Click on Restore 4. In the restore environment window select date and time to which you want to restore the environment. 5. Select the type of environment such as sandbox or production. 6. Name for restored environment. 7. Click on restore. Important point: You can restore your production environment into a new production environment even if doing so results in exceeding your number of environments or database capacity quotas. You can however only exceed this quota by one extra production environment, regardless of how many production environments you have available for your subscription. This capability is provided as an exception, to ensure that you can always restore your production environment in critical situations. You must return within your quota within 30 days following the restore by either removing the original production environment or by purchasing an additional production environment. Once the data in the restored database meets your expectations, activate the users, initiate the work queues, and notify your organization that the environment is once again available for use and that the restoration procedure is now complete. Hope this helps!

Introduction: It is crucial for the management team to track the client’s utilization of the system as a key metric for assessing the project’s success and the value it brings to the client. To facilitate this monitoring process, I have developed a utility that can automatically generate and send reports to the management team, detailing the number of records created in specified tables. For example, during the initial master data upload phase, 1500 data added into the Customer table. Subsequently, over the following month, this figure increased to 1750 and then to 1950. Such trends signify that the client is utilizing the system in line with expectations. Pre-requisites: Configuration: Usage Statistics Setup Page: This page, contains two main fields:- Collect Statistics (Boolean) and Mail Recipients (which contains email id’s to which the report has to be send) and one more field that is primary key field is added in table but not in page and it is set to code due to which the header we get as required in Usage Statistics Setup Page. The datatype of the field primary key is set to header because the default number of code is null. Regex is used for pattern matching. Here, email validation is added on Mail Recipients. User can enter multiple email addresses in this format eg. abc@gmail.com;xyz@gmail.com. If the Collect Statistics is enabled than only you can process further and there should be at-least one mail id present in Mail Recipients. Usage Statistics Configuration Page: This page contains the actual data from which the data will be passed and report will be generated. The list and the card pages are also created with same fields. The “All Object With Caption” is used for viewing all object details in the system. The trigger lookup is used to get the table no. and table name at runtime. After fetching the specific table no. and table name, fields will filter according to the filter field 1 value, same goes for filter field 2 value. (filter field 2 is added according to the requirements.) The FieldsDisplay procedure is used to retrieve field no. and field name of the according to its record. In Filter Field 1 Name any field can be selected and filter field 1 value must be set according to that field. Create Statistics Report: This report is designed to automate the generation of usage statistics based on configurations specified in the “Usage Statistics Configuration” table. The report is flagged as “ProcessingOnly,” indicating it is intended for background processing rather than direct user interaction. The dataset within the report contains a data item with an “OnAfterGetRecord” trigger, which executes after each record is retrieved. This trigger is responsible for processing each configuration record, applying filters, and updating or inserting records into the “UsageStatistics” table. Additionally, the report features an “OnInitReport” trigger that checks the “Usage Statistics Setup” table to ensure that statistics collection is enabled. If this condition is not met, an error message is displayed, and the report exits. In essence, this report streamlines the creation of usage statistics in Business Central, adhering to specified configurations and ensuring the necessary setup conditions are satisfied before processing. Usage Statistics Page: After filter the number of records the data which will be generated will be displayed in this table. List will also be created with same fields. In Record Count the number of values are there which satisfies the filter condition. Send Statistics Report: This report is designed to send usage statistics via email. Let’s break down the code: The report begins with specifications such as its application area, caption, and usage category. Notably, it is marked as a “ProcessingOnly” report, indicating it is intended for background processing rather than direct user interaction. The OnInitReport trigger executes when the report is initialized. It checks settings in the “Usage Statistics Setup” table, ensuring that statistics collection is enabled (“Collect Statistics”) and valid mail recipients are specified (“Mail Recipients”). If these conditions are not met, error messages are displayed, and the report exits. The main functionality is in the OnPostReport trigger, which executes after the report is processed. It performs the following steps: Email Excel Sheet: In this, on 22nd date after applying the filters the output is given and on 24th it again checks by applying same filter since new data was not added in the respective table that’s why it is showing the same data. Conclusion In conclusion, the automated reporting tool plays a pivotal role in monitoring client system utilization, revealing encouraging trends such as the gradual increase in customer records. These insights affirm the project’s success and underline its value to the client, reinforcing our commitment to proactive monitoring for continual optimization and client satisfaction.