💁Agenda of the Video▶️: To share the another different version of Calculating Inventory into two parts using Physical Inventory Journal in D365BC. ------- ➡️Other Related Information: To ensure that your quantities are correct, physically count all of the items in your inventory. Some businesses do an annual physical count, and others count all or only some items more often. After you count items, use journals to post the actual quantities to the general ledger. For example, when you valuate inventory at the end of a period.
✅To Count some items more often than others, perhaps because of their value, use cycle counts. For cycle counts, assign special counting periods to the items.
✅To Adjust quantities after a physical count or other purposes, use an item journal to change the inventory ledger entries without posting transactions. You can also adjust the quantity for a single item on an item card.
✅To Change Attributes on item ledger entries, use an item reclassification journal. Typical attributes to reclassify include dimensions and sales campaign codes. You can also use reclassification journals for transfers by reclassifying bin and location codes.
✅Special steps apply when you want to reclassify serial or lot numbers and their expiration dates.
00:00Now we will do it here as I had made other calculations
00:30So what we can do is we're going to start this calculation, I'll show you from the beginning how to get started
00:50And there is a Manage button here, you can relate bulk lines like this
00:55Let's start from the beginning, open Physical Inventory General, when it is done then you have to run a report or a batch program
01:08You will get the inventory which is available from two or three other places, it is also inside the function, so you have to clip on it, now the system will ask you a question that it has to be run on the state, document number, if you and up and generator number
01:38You stay on this when you want to see two cliffs and better naked also then you have to clip on that entry so I can use it as a particular entry I have to apply its filter it, any location near you, this is also near you
02:08So you can clear it, or if you want to take multiple, then you will have to give different numbers by putting pi sign, though I have shown you only one number, so you can take multiple items by giving different item numbers, but if you want to take the whole system, then you have to keep this item number blank, and here
02:38It can be location-wise, if location was not mandatory, then it can be blank location-wise, then all those items will come to you, so you have to check them, like you have to check the date, then it is showing you under which entry type they come, so the document number will be the same for all, because this is for physical inventory journal.
03:08You have to show the location, if location was not mandatory, then the post would be blank, and after that, all the locations with which the post will be done, it is happening with locations, then you have a field, quantity calculated, specifies the quantity on hand of the item, so what was the on hand quantity, you can check the on hand quantity, if it is location-wise, then you can check the location-wise, that the on hand quantity is showing 200.
03:38specifies the quantity on hand of the item, as determined from the count, now if you compare, then I would just like to say that the comparison is this, whatever location name is coming, match this column with it, quantity, physical inventory, now the one which is ND location, now it is telling that 1100 quantity is at ND location, the quantity which is negative, means negative adjustment or cell agera must have been passed in it
04:08That positive quantity is available, now it is saying of ND location, I have to choose the name of the item, which item it is, front wheel, but we will search, we will search item number wise, now this item which is number 1100, and I have to check that it is saying it is for system's 1100, system wise what is calculated, means location wise, ND location wise what is calculated, that is 1100, and other than ND location, if
04:38If the warehouse system is working, then it is as per 1100 on all of them also, or these entries will not be used for that, warehouse entries will not be used on this, warehouse activation at ND location, which we enable, warehouse related, pick and receive documents, receive and ship warehouse document, all that will not be activated, so there will be no link to the warehouse, so its
05:03What happens is that the location wise count is the same as the actual count. All right, so now we can check this as well, that what the system is saying, now you can go to the item availability by option and directly check what it is according to the location. You should know the number of the item. Now, if you have come by clicking on the item number, then it is directly showing the item number, all right.
05:33You can apply it, if the location filter is not showing, any other thing, let's check it from here, andy took the location, use the tab, click here again, and click and you have to reach, till here, inventory, okay, now this is 1100 inventory, 1100 is showing you how it came into the system, see the filters are applied,
06:03There is an increase, now how did the 1100 increase come here, on which date did it come, there was prayer in positive purchase, purchase was made, purchase received, through which documents was it made, whatever is your document number, all of that is coming, and it is telling you how it became 1100, initially there was 1000 quantity, positive
06:22Out of which it came from purchase received in the second time, okay, so this gyros is for you like this, we have checked it this way, now we have come to know that, in this column of physical account, you can check it location-wise, okay, but now it is left about this column, so the data which is coming in both the columns, is it in both the columns
06:52We will apply it because if there is a difference in calculated and physical quantity, then we will find it in the quantity field. But before applying it, I am showing you that this is the quantity field. 0-0-0 will come in all of them only when both of them are same, identical. Now, quantity calculated and physical inventory, now wherever there will be a difference, you will get it.
07:22There are items on which this difference is coming, C, there are such items on which difference is coming, where the quantity is not 0, see, it is coming now like this is 38, 96, there is a difference of 58, here it is 6, calculated, and physical count wise, location wise, it is 28, and here it will be adjusted, it is 22, because this is the remaining quantity,
07:52So now let's check, what we need to do is we need to apply a simple logic,
08:03see, greater than zero, whatever is greater than zero, we will see it, so now wherever it is not there, zero was coming on all of them, now we will get greater than zero on these only when there is a difference,
08:20In quantity calculated and physical inventory, see the difference has started coming, you got so many, now take any one of these, any one,
08:30Let's take the last one, in this 60 calculated, 72 like I said it will be item wise, location wise,
08:38So location wise it will be 72, and we have to check 60, that 60 is coming according to this, why is there this difference of 12,
08:45So we need to check the white location, and let's see the item name, number, there are positive adjustments, and this is it, this much,
08:54Okay, LS, S15, and for this, the quantity remaining is 12, out of which its location wise is 72,
09:07But the actual calculate is saying that it is 60, which means it might be being used somewhere, so let us check that first,
09:14Item Bhai, after going to this location, we will check at the location,
09:18LS, S15, in which location it is available, you have to scroll a little, you have to scroll a little and see, from below
09:35This one might have been down, this one, has been found, now look, inventory 60, okay, this is 60, you have to grab the inventory column only,
09:47Go to this column and click on it, now it will tell you the remaining quantity, what happened on 26th,
09:59There is 60 quantity in it, the remaining quantity is left in the white space, okay, if there is no invoicing for it yet, it is not used, so like this you can do this one,
10:11I came from positive adjustments, and after so many positive adjustments, so many remaining are digesting this, it is open entry, yes,
10:21So this is the positive adjustments you got. Now we will go back. We have checked this. Now we can also check the course. Its name is inventory value channel report.
10:41Let's enter the start date, add key, and we can preview it with a single item,
10:5660, okay, 60 is coming, and we are checking it like this, you can see this, this is the quantity of increase decrease, but the main quantity is 60,
11:16So if you include expected cost here, then it also shows the quantity related to ship and receive, if it will be received then its expected,
11:26So we will make it right away, we just have to see the actual things, see the ship and receive, so see in actual, according to 60,
11:36We will see the closing date, closing, closing p is showing 60, okay, so if closing p is showing 60, it means 60 quantity,
11:48Right now it is remaining, we will see the closing, after this,
11:56Now what else do we have to check in this, how many differences did we find,
12:02Now we have to pick up any one item and see the reason for it, what is the reason for the difference,
12:09First we will check if there is any warehouse setup activated or not on the location,
12:16First, we will check the location.
12:20Now, directly put it away,
12:26This is activated,
12:30and we check if there is any on it,
12:34Is the entry made, warehouse entry,
12:38For this we will check the laser entry of the item,
12:44negative, positive, negative,
12:48which increased, decreased,
12:52There will be plus or minus, it is set,
12:54increase, decrease, and the last 60 remains,
12:56okay, and by the way she was from another location,
13:00I'm coming from yellow, there will be plus minus at the yellow location,
13:06and 60 on white, still save 60 on white,
13:10Now the question was whether it has any warehouse entries or not,
13:14Why is there a difference in this,
13:1672, this is the quantity, right?
13:20Because of the difference, now we,
13:24If there are no previous entries left, do one thing,
13:31I would also like to see other entries,
13:40Apart from this there are no entries,
13:42Now these are laser entries, but I have to check,
13:46Apart from this, are there any entries of this,
13:54Inside History Relate,
14:04Inside the history,
14:06Inside the history,
14:08I want to check if it has any warehouse entries,
14:12We,
14:14In this,
14:16Direct pick and putway was activated,
14:18Look, there is an issue,
14:20Pick, Bulk, Adjustment,
14:22and in the,
14:24We have,
14:26How much inventory is there,
14:30warehouse document type,
14:32channel warehouse,
14:34channel warehouse,
14:36From,
14:38The entry has been posted,
14:40source document,
14:46If you look carefully here,
14:48You will get it,
14:50why the count is 72,
14:54Isn't it,
14:56So the issue is,
14:58That would be available in the count of 72,
15:00Now like this is positive adjustment,
15:04Its source is item channel,
15:06We can see it clearly there,
15:08It's right there,
15:10and this one there is 60 quantity,
15:12so we'll just check which one,
15:16We will just check the movement,
15:18which is done through the warehouse adjustment channel,
15:22Now if we look carefully here,
15:26So we have the quantity,
15:2872 plus 72 minus,
15:30It is a trick,
15:32warehouse adjustment channel,
15:38You can also say warehouse general,
15:40And this is the passcode from this document,
15:44If there is a trick, then this movement has happened,
15:46In which,
15:48pick and bulk and adjustments related entries were,
15:52So, you can check this,
16:00The actual count is,
16:02According to him,
16:04You can post this,
16:06You need to update it in the system.
16:08So you can use it,
16:10After cross checking like this,
16:12The quantity which is this,
16:14You can update these,
16:16You can update it,
16:18To update,
16:20What you need to do,
16:22You can update it,
16:24Whatever has been calculated and seen,
16:26There is nothing you can do about this,
16:28So you can just update it,
16:30Now it is a normal thing,
16:32You can update it,
16:34which has been calculated and seen,
16:36There is nothing you can do about this,
16:38which is seen in this quantity,
16:40There is nothing you can do about this,
16:42You can just update it,
16:44Now it is a normal thing,
16:46that he was coming as a physical count,
16:50Jadha and you have 58,
16:54So now you own it,
17:04What you need to do is to post on this,
17:14do you do taxes?
17:22Where taxes are levied,
17:24On Friday some food will come to you
17:26I am also wondering what is your concern,
17:31At least something about you, this is yours, why is this your behavior
17:35Jhaal Jhaal
18:05Jhaal Jhaal
18:35Jhaal
19:05Jhaal
19:35or do a search for it
19:40Or else check the physical input entry ledger
19:43or jhal
19:51ya ya ya dya ya.
19:52ya ya new jaan.
19:54ya ya aaaaat leigh.
20:04upsl to sethiyu
20:07Kike
20:17So many entries were generated
20:20There is so much entry in the entry that it is a kick trio
20:24After so much entry in one go
20:34You can check which posts are posted
21:04you can check this
21:34Jhaal Jhaal
22:04Jhaal Jhaal
22:34You can check this entire list like this and download it on Excel
