Supply Chain Management & Accounts Payable
  1. Help and Support Center
  2. Supply Chain Management & Accounts Payable

Inventory Stock Screen, What do the columns mean? Jerry Jerome

This video explains what each column means in the inventory stock screen.


Today we're going to go over the inventory stock screen. So, we're going to head over here to the left-hand side to our SCM, go to inventory stock, and see here we've got a list of inventory items. 

Okay, the first column right here is the Item Name that is going to be the name of the material item that you've entered in at any point throughout the lifespan of your Arborgold database. You can easily just search and it'll filter down based on what you're typing in. We're going to focus on one material today. It's going to be our triple 10 fertilizer. 

This first column is Stocked. This is a summary of all of your entries for this inventory item ranging from a combination of purchase orders, bills, manual adjustments, and jobs. Then we go over here to the next column, the red C column and C stands for Completed and this number is going to represent inventory items that have been completed on services. The next column is going to be the Blue S column, Blue S is going to represent inventory on scheduled jobs. So, we’ve got Completed, we've got Scheduled and the last one is, you probably can guess is P for Pending. So, this is going to represent any inventory on a pending job. So, anything that has been approved but not yet scheduled. So essentially the right-hand side of your work scheduler screen, that list of work to be scheduled is going to be represented here if there's a material item on that list. So, you've got Completed, Scheduled, and Pending. 

Next, we're going to go over the Stocked C, stock CS and stocked CSP columns. Stocked C, you can use this as a true representation of the material on hand for this item. So what stock C is going to be, Stocked C is going to be stocked minus C equals Stocked C, So 2000 - 702 = 1298. 

Next column is going to be stocked CS.  And stock CS is going to be a combination of Stocked 2000 minus column C and column S together. So, 2000 - 702 and then minus 701.75. And that's going to give us a total of 596.25.

Then the last one, as you can probably guess just like you did over here, stocked CSP is going to be your Stocked number minus the sum of these three numbers here of stock of C, S,& P. All three of those added together, minus 2000 and we actually get for this inventory representation is -33.75 pounds.

Now the next two columns we just want to talk about are the RO levels for C, CS, & CSP. So, RO is your Reorder Level. So, reorder level for C means once the completed amount of this inventory here gets below 100, we're going to get a little red triangle telling us that we need to order based on this number.  And over here on the CS level, if the completed and scheduled items go below 250, we're going to get a warning saying, hey we need to Reorder. And then for the reorder level here for CSP is, as you probably guessed again a combination of all three of these. So, these three get below 500 which we are.  I'm going to get a little warning here that tells me I need to order. Plus, it tells me over here on these columns for reorder status and telling me.  Hey, I need to order and it tells me CSP right there. And if any of these other two columns for reordering hit their thresholds, it would also show those here as well. 

The reorder levels are set on the actual material item, and I'll show you that really quickly here.
I do go over this on a different video but at least giving you a little reference here. Reorder details and this is where you set those thresholds for the reordering levels for the material. 

Now the last two items that we want to go over are actually your current orders. So, this is going to represent if you have any orders placed and tracked within your SCM, it's going to show you how many pounds are on order for that product


Legacy Video