|i. Name of Item
The list of stock items are displayed which are grouped under the selected stock group. Highlight the required item and press Enter to arrive at the Movement Inward details. This gives us the details of the stock items in terms of the quantity, rate and value. You can drill down to the last level of voucher details.
ii. Closing Stock
Remember, in the section on Order Processing we first raised a Purchase Order for 5000 pcs which we then purchased. After that, we raised a Sales Order for 4000 pcs which we subsequently sold - this resulted in a closing quantity of 1000 pcs. The column next to the name of the item displays the closing quantity as per the date specified in the report.
Press Enter on the value shown under closing stock and you will get a monthly inward-outward-closing balance report of the selected stock item.
iii. Purchase Orders Pending
This quantity is arrived at on the basis of the total purchase orders pending. Remember we raised 2 Purchase Orders for 4500 pcs and 5500
pcs. The total of 10000 pcs appears in the Purchase Orders Pending column.
Press Enter on the value shown under Purchase Orders Pending and you will get a report displaying outstanding purchase orders.
iv. Sales Orders Due
This quantity is arrived at on the basis of the total sales orders due. Remember, we raised 2 Sales Orders for 3000 pcs and 4250 pcs.
The total of 7250 pcs appears in the Sales Orders Due column.
Press Enter on the value shown under Sales Orders Due and you will get a report of the outstanding sales orders.
v. Nett Available
he quantity given here is arrived at based on the formula: Closing Quan- tity + Purchase Orders Pending - Sales Orders Due i.e., 1000 +
10000 - 7250 = 3750 pcs.
vi. Reorder Level
As per our definition, if we select the greater of 4500 pcs or the level of Con- sumption over the last 5 days then the reorder level will be
displayed as 4500.
To define consumption pattern as lower, highlight the Reorder Level column and press Enter to view the Specify Reorder Level screen.
Shortfall is displayed as on 31-1-2010 with the specifications:
‡ Reorder level being 4500 pcs or consumption of last 5 days whichever is higher.
‡ Minimum order quantity of 1500 pcs or consumption of last 5 days whichever is higher.
The quantity is arrived at based on 4500 (reorder level) - 3750 (nett availa- ble) = 750 pcs shortfall. The reorder level if more than the nett available, the difference will be shown as Shortfall.