Skip to playerSkip to main contentSkip to footer
  • 6/17/2025
💁Agenda of the Video▶️: To share the Online Query's Answer.
🔰Question: How can I get a Report of List of Items which are differentiated by Consumable or Inventory?
📝Answer : Inventory Valuation Report. This is an inbuilt / standard report (and the... Report id is, 1001).
✅ GRN / Shipment (Received Not Invoiced / Shipped Not Invoiced)= Expected or Estimated Cost of Inventory.
➡️Related to Item Ledger Entries (in short; ILE, table).
✅ Invoice = Actual Values or Inventory Cost Posting to G/L (associated General Ledger of Items/Inventory/Stock).
➡️Related to Value Entries (table).
🔸🔸🔸🔸🔸🔸🔸🔸🔸🔸🔸🔸🔸🔸🔸🔸
📍Hint: Closing Stock = Opening Stock / Inputs / GRN + Purchase (increase in the Year) + Positive Adjustment [Less (-) Dispatch + Sales (Decrease in the Year) + Negative Adjustment]. ✅
🔸🔸🔸🔸🔸🔸🔸🔸🔸🔸🔸🔸🔸🔸🔸🔸

Category

📚
Learning
Transcript
00:00Hello friends, welcome to my channel. I am Vilan Sarmavi and today we are going to discuss a question about my website NavigationFunctionalExpert.com
00:26We are going to discuss how to differentiate items according to items like consumables and other inventory.
00:42So, first of all, we are going to talk about inventory report, which is the best report.
00:48Inventory Valuation Report. We are going to take the screen to the inventory report.
00:571001 table ID. Report ID, sorry. 1001 report ID. Check also.
01:06We are going to get the report ID. Help button. Help and support.
01:15SPAC.
01:18So, we are going to get the report ID. Yeah, right. I am right. 1001.
01:25Now, report request. This dialog box is open before the report.
01:30So, we are going to call the report request page. Now, on this report request page,
01:35we are going to mention the starting date. You want to see where to where to where to.
01:400101. How do we say?
01:4425.
01:47If you want to see where to where to where to where to where to where to where.
01:52So, expected cost.
01:54The interest cost, that means the interest values. Estimated cost.
01:57cost, like shipped but not invoices, goods received, GRN but not invoices, actual value
02:05generated, invoices not created, that value is expected cost, so that you can activate
02:12it, but now the main question is how we can see categories wise, so you have a filter
02:21here is the item number, if you want to see a number, 3 or 4, you want to see a pie sign
02:28if you want to see a blank, you want to see a blank, you want to see a filter here, there is a filter
02:34here is the filter, finished goods, resale, and if you want to see a blank, you can also
02:49see a blank, so if you want to see a blank, then you want to see everything here, but you
02:53need to be made here, if you want to see consumables or others, if you want to click on it, just
03:02I want to see raw material, so raw material, plus if you want to create a category, if you
03:09see, item category, whatever you want to see, item category, item category code, item category code,
03:16you can see item category code, next filter, item category code, this is what you want to see,
03:26furniture, decks, chairs, office supplies, this way, if you want to see category, category
03:37element category code, inventory posting group, choose a group, keep it in any subdivision,
03:43even if there is a subdivision, then take that khác, Now have you to have a raw material now,
03:46Só Rodanty Posting Group, as I have put a raw material,
03:49just review it and I will just show you to have a filter, if you want to click the blank,
03:53if you want to make the blank, so they will create three groups, RM,
03:59WebG and others there will be resale, then the report generated, so you want to generate reporting,
04:03and you can see the look and feel report.
04:06Now you can see the look and feel report.
04:09Raw metal is written.
04:10This is raw metal.
04:11Page 1 and 2.
04:12So, go to the last page.
04:14Raw metal total.
04:16So, the raw metal,
04:17the raw metal system,
04:19the inventory posting group will come.
04:22So, if you have a category or category
04:25or product group,
04:27then put it in the filter.
04:29Otherwise, the inventory posting group is also a filter.
04:33Now, we can check the report and request pages
04:38that there is a different group of items.
04:43There is another filter.
04:48Item group.
04:50This is the inventory posting group.
04:54This is the same thing.
04:55This is the same thing.
04:56It will be a subgroup or some type of filter.
05:00You can check the filter.
05:03You can check the filter
05:04that you can see the subdivisions.
05:06So, you can see the filter
05:08that you can find the filter.
05:10The things you can find.
05:11Like I have put category code.
05:13It is the item discount group.
05:16So, you can see the item pricing.
05:22You can find the category.
05:24You can find a postgroup.
05:26Next must be done.
05:28We will click next.
05:33Automultical, 9.
05:38For this,
05:40if you has any other subdivisions,
05:43If you find the best filter, you can take it.
05:50I have checked all of them.
05:55If you think best or filter, you can also take it.
06:02Just standard cost or static group filter.
06:07If you think next filter, you can choose the next filter.
06:17Now, if I blanked the item in the inventory posting group.
06:22In this finished goods, raw material, and resale.
06:26You can also make a consumable.
06:29If you blanked it, you can take all the categories.
06:36And I just said that the interim expected, not invoiced category.
06:44If you want to include expected, you can also take it.
06:48Now, you can click on it and preview it.
06:50Now, all the categories, all the groups.
06:54All the inventory posting groups are made.
06:58If you want to make extra or consumable, then you can also take it.
07:05Now, if you want to see expected cost line, you can get horizontal.
07:12You can create a GRN.
07:15Now, how does this report work?
07:17You can take the posting group.
07:19First of all, we have finished posting group.
07:22The item number is finished.
07:24The item number starts with finished group.
07:27Inventory posting group finished.
07:31So, finished.
07:32In finished, there will be a number series that will come.
07:35There will be a description.
07:36Based Inuit of Major, Quantity, Value.
07:38Now, you can see here.
07:40As of 31, 12, 24.
07:42This is the closing group.
07:43This is the closing group.
07:45This is the closing group.
07:46Because I had the first January of 2025.
07:49I was showing last closing.
07:51This is the opening group.
07:53Then, the increase.
07:55This is the next group.
07:56What you purchased?
07:58This column is the section.
08:00Increase.
08:01The input and purchase.
08:03The quantity and value.
08:05The decrease.
08:07The sales.
08:08The sales.
08:09The negative.
08:10The increase.
08:11The positive adjustment.
08:12The input.
08:13The purchase.
08:14The decrease.
08:15The sales.
08:16The negative adjustment.
08:17The adjustment.
08:18The closing.
08:19As of 17, 625.
08:21As of 17, 625.
08:22This will show you.
08:23As of 17, 625.
08:24This will show you.
08:26The formula's coming.
08:29Opening.
08:30Increase.
08:32Increase.
08:33Minus.
08:34Decrease.
08:35Dequease.
08:36Equal to closing.
08:37Quantity.
08:38Value.
08:39If you divide the value value by quantity.
08:42You will find the rate of closing.
08:46Couples.
08:47Opening.
08:48Increase.
08:49increase and decrease check and lastly if you are in inventory set-up
08:57automatically you don't use batch program manually and periodically
09:03if cost posted to jl is automatic or unit cost automatically
09:08you have to increase automatically and cost posted to jl is automatic
09:18So this will be updated when you run the batch program and post it to JL.
09:23The associated JL of Inventory Accounts or Inventory Posting Group JL is the JL that is set up through the Invent item card.
09:38That will be posted in the data.
09:40So this evaluation report will help you very well in understanding everything.
09:47We will match the values.
09:50You will easily match the physical quantity.
09:54Values match your unit cost, item increase, update and cost posted to JL.
10:02We will run the 3 batch program.
10:04We will set up the Inventory Posting and Automatic Adjustment.
10:09We will set up your bulletin and options.
10:12Now this is finished.
10:14We have finished.
10:16Now click on the next page.
10:19Click on the next page.
10:21Next.
10:23Now finished here.
10:25You will clearly see finished.
10:27This is 26, 28, 978.79.
10:30You will notice down the page in the Cardinals.
10:32It will need to identify your� or as expected cost.
10:33So for the next page, it will be added to the Cardinals.
10:34I will see the Cardinals with the Cardinals as well as expected.
10:36My name is no longer than the Cardinals.
10:37It's also in the Cardinals as well as the Cardinals.
10:39It will be added to the Cardinals since the Cardinals.
10:40so this way you can check your values and expected values
10:48because the actual posting is invoiced after the actual posting
10:55what happens if you think about the purchase order and sales order
10:59you put an estimated value
11:02and when you create GRN, the quantity means that you have received goods
11:11value is not a good job
11:13value is a good job when you make invoice
11:17when the invoice is posted, you can change the order
11:22and you can also change the order
11:25so if you change, the variance will be used if you use standard costing
11:31but before you use it
11:33so there are no options of variance
11:35but when you post the actual value of invoice
11:39the value will be updated
11:41and the expected value will be shown
11:44that it was only for GRN
11:46the amount of quantity
11:47the purchase order
11:49the purchase receipt
11:51the purchase receipt document
11:53and the sale shipment
11:55which you are receiving
11:57in the degrees
11:59so increase, decrease
12:01and the closing opening
12:03this column
12:05so as I have said
12:07closing opening is the first column
12:09then increase
12:11input, purchase
12:13these things
12:15positive adjustments
12:16and decrease
12:18negative adjustments
12:19sales
12:20these things
12:21you can check
12:23all these things
12:24you can check
12:25all these
12:26negative and positive adjustments
12:27you can check
12:28so increase
12:29and decrease
12:30you can check
12:31so this
12:32you can get
12:33next
12:34we have started
12:35this
12:36this
12:37number
12:38number
12:39number
12:40number
12:41code
12:42item
12:43number
12:44after
12:45number
12:46the
12:47residential
12:59mod
13:00number
13:01you can search
13:03for yourreport request page
13:05which manual
13:08give you
13:10Next, click on the next category, and then click on the next category, what do we have to do next category?
13:17Results are starting. Okay, it can be consumable.
13:21Now, its code, description, base unit of measure, last year closing,
13:29opening plus increase plus minus decrease, opening plus increase minus decrease equal to
13:40closing. So, you get the closing stock and that value will be updated to your cost posted to GL.
13:49So, if you have a difference in values, you can check the batch program,
13:58that the unit cost will be updated or not, the item entries will be updated or not,
14:04and the cost posted to GL update or not.
14:07And the item cards are also made that the cost is auto-update or not,
14:12and you can also check the inventory setup.
14:14Next, click on the resale, which is the last category.
14:18Resale is the individual inventory posting group total.
14:25First, it was finished, then raw material, then resale.
14:29This is the result.
14:31Now, one is the final total.
14:33Final total means,
14:35whatever the inventory posting group had,
14:38first finished, then raw material, then resale,
14:43then total total.
14:44Yaani, inventory posting group finished plus raw material plus resale equal to
14:55this is the main total.
14:57This is the main total including three inventory posting group.
15:03Each individual total is the final total of three of all existing categories in your system.
15:14This is the last.
15:16So, if you don't see this expected value,
15:18then you have to click on the option.
15:20If you want to click on the option,
15:21you can click on the option.
15:22This is the option include expected cost.
15:25So, you don't see expected cost,
15:29you'll see the cost of the price and you can see it.
15:33For the expected cost,
15:34one page is less than the cost.
15:36This is the details,
15:37and this is the last total.
15:39Now, here I see the last total.
15:40The final total.
15:42The resale total.
15:44Here is the raw material total.
15:47And here is the individual total.
15:49The individual total is the finished total.
15:51And finally,
15:54the main total.
15:57total sub-categories.
15:59This way, you can check this.
16:01And when your cost is posted to GL,
16:03you think it's mismatched,
16:05then what do we do?
16:07We do value match for physical quantity
16:09and values.
16:11We do a reconciliation.
16:13You do a reconciliation item
16:15and GL reconciliation
16:17and we do a process.
16:19You can see why the value is not matching.
16:21We do a detailed exercise.
16:23We do a physical quantity, values,
16:25and cost posted to GL values
16:27and cost posted to GL
16:29is not matching.
16:31For that, I will tell you a few reasons.
16:33Sometimes you have a set up
16:35laser
16:37which has a master card
16:39or an item card.
16:41Inventory posting group
16:43such as raw metal.
16:45There is a whole inventory posting group
16:47which is in your balance sheet
16:49and current access
16:51Inventory
16:53as a raw metal
16:55as a raw metal.
16:57It is called GL
16:59and the item is called raw metal.
17:01And the balance sheet
17:03and current access
17:05Inventory group
17:07in the inventory group
17:09which is made
17:11laser.
17:13You can say that current access group
17:15which is made of inventory
17:17in the inventory
17:19in the inventory group
17:21which is made of RM
17:23which is made of GL
17:25in the inventory group
17:27which is RM
17:28which is FG
17:29which is Consumable
17:31which is also available
17:32like spares
17:33and scrapes
17:35which is made of GL
17:37Inventory posting group
17:39If it is a posting GL
17:41but it is a posting GL
17:43then in a strong account
17:45which is a full account
17:46and the value is a
17:47source
17:49For more than just that
17:51the quality of the value
17:53that you have
17:55in the inventory group
17:56which is in a group
17:57and division
17:58that you have
17:59in a posting GL
18:00as you have
18:01the problem
18:02that you can't even post
18:03direct post
18:04direct post
18:05direct post
18:06direct post
18:07by any general entry
18:08which is also
18:10in the master's invoicing tab, the item card's invoicing tab, you can assign it to a GL
18:17and it's called direct posting. This will be posted.
18:23Whenever the item posts, it will be value in the post.
18:30If you take directly GL and activate direct posting, you can post it.
18:36There are many people who make a chat app account and keep the direct posting.
18:41If you have a set up GL, you should not be able to post it.
18:48They work on the back end and they are placed in the master's.
18:55If you have a different item card, you can also post it.
19:01If you have a direct posting, you can activate a journal, other journal or JV,
19:08you can post it.
19:09What will happen?
19:10You will have a double-double value.
19:12There will be a card, item card, and GL value.
19:16This is also a reason.
19:18You will have to see the exercise that you don't do this.
19:21So I will tell you the main reason.
19:22I will tell you the main reason.
19:23Other reasons are also there.
19:27You have to check that ILEE and value entries post.
19:32Inventory posting group-wise, date-wise,
19:35we match the month-wise.
19:38If you have a big date, you will check the year.
19:44After that, you have a division, month, quarter, half year, quarter, month,
19:51and then 15 days, and then 11 days.
19:56You can also check that the values are not matched.
19:59So you have to see the values match,
20:01and you get to know where it is wrong.
20:03You can correct it.
20:04If you have a problem with the values,
20:06you can also correct it.
20:07You can also correct it.
20:08If you have a problem with the values and values,
20:10we can also correct it.
20:12If you don't know directly,
20:13then we can also correct it.
20:15We can also correct the data to the table.
20:17We can also correct the data to the Excel.
20:19So that was a very detailed exercise.
20:21I was going to explain the first briefing
20:22to explain the report,
20:23which I have explained.
20:25Thanks for watching.
20:34Thanks, for describing the report.
20:39Thanks.
20:43I'll see you next time.
20:45Here.
20:48Take care.
20:54Here.

Recommended