I was doing some data cleansing and data entry I was facing problem for number in such a way 4 digits: 0001, 0002, … , 1000 etc. Now I do not want to type “0001” in excel, instead I wanted to type 1 and I want excel to convert that to 0001 for me. So I started looking for a custom cell format and dug a little deeper to understand those. I thought it would be nice to share them to you all. First take a look at how the cell formatting dialog box – number tab looks like: I found two things for Special: Used for phone number, zipcode, social security number formats depending on the locale yo ..read more

While processing Purchase Invoice I got this error Sale group or item sale group is missing, complete your input. On Release product Item sales group was missing. I update Item sales tax group on Invoice header. After that Invoice is successfully posted ..read more

In this video, is shared How to configure Sales category. How to add Category heriarchy. Tangeble and non tangibal heriarachy. How to add attribute on heriarachy, How to configure posting profile for Heriarachy. How to set Default Sales Category. How use sort order in sales Category heriarchy. How to create a sales order for Sales Category ..read more

I love D365 F&O because every day I have to learn something new. At the same time, D365 F&O was so big that I started to forget things very fast. What I did a year ago is just a vivid memory. Yesterday, an interesting thing happened. During testing for one customisation, I had to deal with batch-enabled items. I have to raise stock on more than 20 items. So I can test sale order scenarios. So instead of creating a purchase order, I decided to make inventory adjustments. And when I post the inventory adjustment journal, it gives me an error message for each batch for each item required ..read more

Hi friends, In this post, I am going to share my notes about consignment inventory in D365 Finance and Operations. So what is consignment inventory? Consignment inventory is stock stored in our warehouse but actually owned by its supplier. If you remember, there is a tracking dimension called “Owner.” In product configuration, we have set this owner as inventory. The complete process is as follows:. While writing this article, I am using Contoso data, the USMF legal entity, and the following version and update of D365. Installed product version: 10.0.37 (10.0.1725.47) Installed platform ..read more

A small tip: I just create a purchase order and register the quantity. Either directly on the purchase order or through the mobile app, advance warehouse in D365 Finance and Operations. Now I want to cancel that line or unregister the quantity for that line. As compared to Ax 2012, it is relatively easy in D365 Finance and Operations. For this, open the purchase order and go to a specific line, click on the update line, and click on registration. From registration form click on ” Add registration line” On clicking add registration line, you will find negative values. Click on Confirm Regist ..read more

We are senior, or senior citizen. Most of the time, young champs do things. And we as senior, just control the situation or communicate. We can not do everything. We need to delegate things. Today I got chance to work with a young champ to import the product attribute in a system. I used following Data Entities Product attribute enumeration types v3 Product attribute integer enumeration types Attribute group Product attributes – Specification of attribute types and attribute name Product category attributes – combination of category and attribute on a product Product attribute values – for att ..read more

Reactive, corrective, or break down maintnenance requires for component that supports the supply chain process in any organization. In this video, I shared the flow of corrective maintenance and with example you can perform corrective maintenance ..read more

In this video, I shared how to create and configure Assets in Asset Management Module in D365 of Finance and Operations ..read more

I walk through the setup and procedure for the Dynamics 365 Advanced Warehouse Purchase order receiving in today’s session. I demonstrate two procedures: a one-step procedure for receiving an item from a pallet directly to a shelf, and a two-step procedure for receiving an item from a pallet to a receiving point before moving it to a shelf ..read more