Adjust Inventory: We adjust inventory primarily through Item Journals for bulk or specific changes (positive/negative adjustments)... OR directly on an Item Card/List for single-item updates, recording physical counts or correcting discrepancies by entering the new, actual quantity, which updates ledger entries and costs. Key methods include using the Item Journal (type: Adjustment, Entry Type: Positive/Negative) or the direct Item --- Adjust Inventory action for quick single-item fixes after a physical count.
00:00Hello friends, welcome to my channel, I am Finansir Madhvi and we are going to discuss
00:29today about the adjust inventory feature, so you need to click on the item list, you
00:36can choose any item, see this is the first item, I am going to use it, you can use, first
00:47you need to check all the things and all the tabs like items, this is the first tab then
00:53inventory and you can check one by one all the tabs, so the feature which I am talking
01:04about the name of the feature is adjust inventory, what is the use of this feature, we can increase
01:17or decrease the items inventory quantity manually by entering a new quantity, adjusting the
01:23inventory quantity manually may be relevant after a physical count or if you do not record
01:29purchase quantities, it means you do not need to create and post any item journal lines,
01:40if you are in hurry, you do not have so much time to create any positive adjustment for
01:47this item, you just click on the adjust inventory feature and you can create item but before using
01:56this I am showing you the quantity of the item, this is the main actual quantity and this is
02:05showing zero, zero for all locations, all locations or all warehouses okay this is the three dots
02:14you can check by clicking on this the system will show you all the related locations, it's showing
02:26zero for all locations right okay so if I need a 100 bicycle or 10 or 20 bicycle for right now to sail or to
02:41to dispatch or ship to any city how can I do it so just click on here click on adjust inventory
02:55and you need to select the location see the arrow sign indicating the I am selecting the location of new
03:03Delhi just put the number of bicycle what you need I need 50 bicycles right now and system will work for
03:15it click on ok system will generating the lines the item journal or positive lines so you need to click
03:24click here to ensure you this will work or not how system will generate this 50 so you can check
03:34these are the item leisure entries item leisure entries and see this is the positive adjustment lines and
03:43this is why the item journal but this is in the background you need not to create open create and post any item
03:58journal line entries system will automatically done for you location code the quantity is 50 invoice quantity
04:06is 50 remaining quantity is still 50 so you can dispatch and you can sale it and other information will get from the item card like the cost price and other things right
04:19so this is the positive adjustment i have done uh two more entries for this see uh the date
04:27so i have posted uh one another increase earlier or this is
04:33this same for the nd location and quantity was 10 this is the positive adjustment and after doing this i just want to check
04:43if i want to remove uh the same quantity from the adjusting inventory function or from the location area what a system will do
04:54so i remove the 10 quantity for this and system will generate the negative adjustment for the positive adjustment when
05:06you want to remove manually system will generate the negative adjustment entry for the same quantity or
05:17or that or the modified or the modified or changed quantity so i first i i posted a uh i adjust 10 quantity
05:29and then i remove the 10 quantity with the negative adjustment so system will generate first the positive
05:36adjustments and next the negative adjustment but i haven't create and post any item journal lines or positive
05:45entry i have just used the feature of the adjust inventory
05:53see if you want to remove the 50 quantity just use the backspace or just use zero system will work and system will
06:09work for you and system will show you the zero quantity for the nd location and now the best part is the conclusion of the story
06:23the negative adjustment system will justify the answer that if you post 50 quantity as a positive adjustment and if
06:33you want to remove that quantity it will also pass the negative adjustment lines for the same quantity or the modified quantity if you want
06:43so system will post the 50 quantity again for the negative adjustment this will work for you but use it wisely use it
06:56as i use it as i use it if you want to track the actual quantity if you want to uh if you want to track the actual quantity and if you want to run your system
07:12so system to update the quantity accordingly
07:18see this is the effect and
07:23we can again use it we can again use it via here or
07:29you can use it via here
07:32the same functionality works
07:35for both the way so 20 quantity this is a positive
07:42system will work and system will work for the
07:46location system will showing this quantity for this location you can check item by location also
07:54checking line posting lines working on it
07:58the general batch name this includes all the process of item general positive adjustment entries
08:04so you can check the ile for this item laser entries the generated item laser entries via
08:13item entries laser page laser entry page or via here or using the item by location
08:27you can get this entry right
08:30the positive adjustment entry the entry number and all the useful details
08:39now the system is working on it when the system is working on it automatically
08:52when the entry is created we can check it
08:54so you have to click on it open details for inventory quantity
08:59which we have to check the latest quantity
09:02we have to check it
09:04now the single line which is the first line
09:07is that I have no negative adjustment
09:09so this is the positive line
09:11so what are we going to do
09:13what are we going to do
09:15what are we going to do
09:16now we are going to check to check it
09:17what are we going to do
09:19find entry
09:20If you want to find entry, you can see all of the entries in today's date, all of the entries are negative and positive.
09:28You can see total 10 entries.
09:30So, we don't need that.
09:32We go to value entries.
09:34Entry button here.
09:36Value entries.
09:38Single line selection, which is the latest entry.
09:42Positive adjustment.
09:44Direct cost entry type.
09:46I put a quantity to 20.
09:48Because in item card, it has per unit cost.
09:54The quantity is per unit cost.
09:56The cost amount is actual.
09:58So, if cost per unit is equal to 20 quantity,
10:02we multiply the cost amount is actual.
10:06But I just mean that the quantity is 20 quantity.
10:10So, this is remaining.
10:12What do I do?
10:14You can see entry in the system.
10:16What do I do?
10:18What do I do?
10:20Cost per unit is this.
10:22Okay?
10:24This is the cost per unit.
10:26350.595 into 20.
10:28So, the system has multiplied by cost per unit.
10:32The cost per unit has made the cost points.
10:34So, the cost of costing makes the cost cost.
10:36So, the cost equity is used.
10:38Okay?
10:40So, 20 into 350.595.
10:44This will generate.
10:46So, this is all about item card.
10:48This will generate.
10:49The cost of adding item card.
10:50I wanted to create it on quantity.
10:52The cost of adding condition.
10:54The cost of adding value.
10:56What do I do?
10:58Now, what should I do? I have an entry. This entry has been posted. It has been posted in jail.
11:06It has been a lot of value and remaining quantity. I can dispatch it. I can use it in sale or production.
11:14Because it has been generated systematically. Now, if I want to see how the voucher entry system has been posted,
11:22it has not been reversed. It is in open condition.
11:28Plus, the G L account is positive and negative.
11:35The minus sign is on credit side.
11:41So, the minus sign is on credit.
11:43So, the finish is stable.
11:45The G L account is 2120.
11:47You can see the name inside.
11:49The name is shown here.
11:51So, if you want to go to 2120, you can navigate it.
11:56You can keep the setting.
11:58So, the setting is the item card.
12:00Inventory, Posting, Setup.
12:02It will generate everything.
12:04So, the G L number according to its name is finished goods.
12:08And 7170, Inventory Adjustment, Retail.
12:13So, this is the name of your account.
12:16So, 2120 finished goods account debit amount is 7011.90.
12:21And the second one is 7170 Inventory Adjustment.
12:27Which is credit.
12:28It is 7011.90.
12:31The same amount as debit credit.
12:33Which is no sign with which there is no sign.
12:35The debit and which minus sign is credit.
12:37I am talking clearly here.
12:38Debit and credit.
12:40So, you can see the details in this way.
12:43After this, you also think that I have a voucher entry.
12:46So, there is a process button.
12:48I think there is Print voucher option.
12:50In the process button.
12:51Check the transaction number.
12:52It will automatically take it.
12:54You don't need to get it.
12:55Preview and Close.
12:56Now, you can add it to its name.
12:58You need to scroll down and scroll up and this way you can see this entry.
Be the first to comment