Contents
Inventory Management 
Classification of Inventory Items   
Inventory Valuation Methods   
Documents updating Inventory
Opening Stock of Inventory items   
Inventory Receipts  
Inventory Issues  
Inventory Adjustments  
Batch-wise Inventory Tracking
Stock by Warehouse 
Stock by Warehouse and Batches
Inventory Master Menu
Inventory Transaction Menu
Inventory Reports   
Opening Stocks Register   
Stock Statement   
Stock Movement
Stock Valuation   
ABC Analysis  
Batch-wise Stock Analysis 
Ageing Analysis  
Reorder Report
Fast Moving Items
Slow Moving Items  

 Inventory Management

Overview
Intraweb Solutions keeps track of the Inventory items which are received and issued. The pre-requisite for maintaining Inventory is to first create Items, whose Inventory is to be maintained, and then enter transactions involving those Items, that update Inventory. Inventory of the Items are maintained in terms of Quantity and their value.

Inventory is updated with the transactions of incoming and outgoing Inventory items. For incoming Items, the Quantity and Value of Items received are added. For outgoing Items, the Quantity and Value of Items despatched are deducted. The valuation of Available Stocks is calculated, based on the Rate at which each incoming Item is received. At the time of issue, the Balance Quantity Value is calculated on a Weighted Average or FIFO basis. We shall study the details of Weighted Average and FIFO methods of Costing a little later in this chapter.

Classification of Inventory Items
 

Inventory Valuation Methods

Intraweb Solutions allows you to maintain an online Stock Valuation on Weighted Average, FIFO or LIFO basis. Intraweb Solutions allows you to select the Valuation method for each Item created in the Inventory. Based on the selection made when the Item is created, Intraweb Solutions automatically picks up the Cost for that Item at the time of Issue from Stock.

The Valuation methods are briefly described below.
Weighted Average: The Weighted Average Cost method keeps track of the Cost for each Item on a daily basis. Each time you make a Purchase or enter an Inventory Receipt, the Average Cost is recalculated for that day. The Cost of previous dates would not be affected with this recalculation. The Weighted Average Rate is calculated as follows:

Value of Available Quantity + Incoming value
______________________________________
Available Quantity + Incoming Quantity

  

Thus, with this method, Inventory is valued at the Average Cost, as calculated above.

Example: You buy three units of an Item for $2.00 each and three for $1.00 each. If all the Items remain in the Stock till the second Purchase, the Average Cost after the second Purchase is calculated as (3*2+3*1)/6 = $1.50.

Let us assume you sold 2 out of the three Items before you make the second Purchase at $1.00. The Average Rate would then be $1.25 and not $1.50, as the calculation at the time of second Purchase would be:

{(Balance Quantity of earlier Purchase)*(Rate of earlier Purchase)+(New Quantity bought * New Rate)/Total Quantity} i.e. (1*2+3*1)/(1+3)=5/4 = $1.25.

FIFO: The FIFO method keeps track of the prices paid for each Item and when they are received. While issuing the Items from Stock, the earliest received Quantity of the Item would go out of Inventory first and the Cost of Issue would be the Cost/Rate of the earliest available Purchase/Receipt Quantity.

 Example: Let us continue with the above example of two Purchases of an Item, as shown below:
Date                        Item               Cost            Quantity
 01-1-98                     Item X                         2.00                        3
10-1-98                      Item X                         1.00                        3

If FIFO is used as the Costing method for Item X, any sale of item X on or after 10th Jan would pick the Cost of Issue as 2.00, till the first purchased Quantity is fully exhausted, before taking the Cost of next Purchase. If you sell 4 items after 10th Jan at one time, the Cost of Issue would be picked up as calculated below:
(Quantity Issued from first Purchase * Rate of first Purchase)+(Quantity Issued from next Purchase * Rate of next Purchase)/Total Issues.
The cost in the above example for issue of 4 would be (3*2+1*1)/4=7/4 = $1.75 as against $1.50, if it were calculated on Weighted Average method.

LIFO: Similar to FIFO, the LIFO method also keeps track of the prices paid for each Item and when they are received. The difference is, while issuing the Items from Stock, the last received Quantity of the Item would go out of Inventory first and the Cost of Issue would be the Cost of the latest available Purchase Quantity.

Example: If we take the same example as described in the FIFO method above, the Cost of Issue would be picked up as calculated below:
(Quantity Issued from last Purchase * Rate of last Purchase)+(Quantity Issued from previous Purchase * Rate of previous Purchase)/Total Issues.
The cost in the above example for issue of 4 would be (3*1+1*2)/4=5/4 = $1.25 as against $1.50, if it were calculated on Weighted Average method.

Documents Updating Inventory


The Transaction Entry options provided for updating Inventory records are Delivery Note under Sales; Material Receipt Note under Purchase; Opening Stock, Shortages in Stock, Excesses of Stock and Stock Transfers in Stocks; Issues and Receipts from Production and Job work Issues & Receipts under Production.

 Opening Stock of Inventory items

In Intraweb Solutions Opening Stock can be derived by 2 methods
1. Transferring of stock from one Fiscal Year to another (which can be done through automation in Intraweb Solutions)
2. User entry through the menu „\Transactions\Stock\Opening Stock.. The Opening Stock has to be entered with Unit Rate, as the Stock Valuation has to be updated with the Quantity. Intraweb Solutions calculates the Value of the Items by multiplying Rate*Quantity.
Note: Intraweb Solutions does provide maintaining Opening Stock Warehouse wise and Batch wise.

Inventory Receipts
 

The Issues of Inventory Items can be done through the documents like Sales Invoice, Delivery Note; Issues to Production, Shortages and Job work Issues. These vouchers would reduce the Quantity from the Available Stock against the Items entered. The Value of the reduced Inventory is deducted on the basis of the Cost of each Item as on the Entry Date. The Cost of the Items is arrived at using Weighted Average, LIFO or FIFO basis, whichever is selected for each Item.

Inventory Adjustments
 
The difference between the actual physical Stock on hand and the Inventory as maintained in Intraweb Solutions can be adjusted using the Adjustment Documents, available under the menu \Transactions\Stock\Stock Adjustment. These adjustments would be required for Items miscounted, damaged, lost or stolen.

There are two types of adjustment:

If the Quantity in physical Stock is more than what Intraweb Solutions shows, you need to enter positive quantity. Intraweb Solutions would pick up the Average Rate as soon as you enter the Item and Quantity to be added in Stock. The Rate would be the Average Rate as of the Date entered in the Adjust page.

If the Quantity in physical Stock is less than what is shown in Intraweb Solutions, you need to enter negative quantity. Here too, Intraweb Solutions would pick up the Average Rate at which the Stock Value would be reduced from the Inventory.

In both cases, the Financial Accounting data is affected. Select the ledger account which will get affected due to access(dedit) or shortage(credit) in the quantity

Batch-wise Inventory Tracking



A  master is provided for entering batch of inventory where you specify batch number, Expiry Date, Manufacturing Date .
Industries like Pharmaceutical manufacturers and traders require Batch-wise Inventory tracking system where the Items received are maintained in Batches. Each Batch would have a unique Number, either numeric or alphanumeric, Expiry Date, Manufacturing Date .

Batch Number: This field requires you to type the Batch Number of the items received .

Expiry Date: This field will appear in the incoming Inventory vouchers, if you select  batch number.

Manufacturing Date: The Manufacturing Date. field appears in the incoming

Inventory voucher, if you enter the Manufacturing Date  in the batch master.

Batches selection window: In all the outgoing Inventory vouchers, Intraweb Solutions gives option for selecting  batch number  after you select an  Item and , to select the Batch from which that Item is being issued from the Inventory. The drop down for batch  displays all the Available Batches that are not expired.

Stock by Warehouse
Intraweb Solutions allows you to maintain Warehouse-wise Inventory.
Internally, Intraweb Solutions maintains the Stock Balances , base upon the vouchers that update Inventory.
Intraweb Solutions allows you to check the available Stock position at each Warehouse , while making invoice reports.
Apart from maintaining Warehouse wise Stock, Intraweb Solutions does also maintain Warehouse wise Stock Valuation.
Also when the current Fiscal year is closed, Intraweb Solutions does transfer Warehouse wise stock to  the subsequent year.

Stock by Warehouse and Batches
Intraweb Solutions keeps track of Batches received at different Warehouses. Intraweb Solutions displays the Available Batches of the selected Warehouse

Inventory Master Menu

Main Group
 In Main Group Page You Create Main Group for your Company   Item

Main Group page is shown below

Sub Group

In sub Group you created multiple Sub Group for One Main Group for Company Item Sub Group page is shown below

Color

In Color Page You add new color for Item

Size

In Size Page you add new size for item

Batch
In Batch Master Page you create multiple batch. In batch Page you enter Batch Name, Mfg Date, Expire Date and   expire Date is always greater than mfg Date.

Batch page is shown below

Currency

In Currency Page you create multiple currency require for company transaction
Currency page is shown below

Currency Exchange Rate

In currency exchange rate you enter currency exchange rate for particular currency selected from drop down list and date.
Currency Exchange Rate page is shown below

Status

In Status Page you enter Status that require for Transaction section example (Completed, Canel led etc.)
Status page is shown below

Quality

In Quality page  you enter Quality details that require in Item Master
Quality page is shown below

Item Master

 Item Master Page use for created Item for transaction (e.g for Purchase and Sales)

In Item Master Select Main group, Sub group, quality, usage units, currency, color, size

Max and min Quantity, standard cost, wt avg cost etc.

Item Master page is shown below

Inventory Transaction Menu

Opening Stock
Opening Stock page can be access from Transaction /Stock/Opening Stock. It is where you can enter the opening stock of the item. You can enter date, select item name, warehouse, optional batch number. On selection of batch number expiry and manufacturing date comes automatically if you have made entry in the Batch Master. Then you specify the quantity and rate for that item and amount comes automatically and makes selection of type of the stock it is and account where opening stock effect will be coming. On click of Insert Records gets inserted into the grid.

On click of the update button records get saved into the database.

Opening stock page is shown below



Physical Count

Physical Count page  can be access from Transaction /Stock/Physical Count. It is where you can enter the actual stock quantity in the warehouse and get the variance for that item. On this page selection of the Main Group and Sub Group is provided and on selection of  this all the item related to this Main Group and Sub Group get displayed which include Item Name, Warehouse, Batch Number, Expiry Date ,Manufacturing  Date, System Count .User can enter Physical count the variance get  automatically displayed. To enter the physical count user need to press edit button and on click of edit button physical count column become editable and on click of update the row become non-editable. User can also delete the row if required.

After entering physical count quantity user can press update button to save the records in the database.

Physical Count Page is shown below


Stock Adjustment

Stock Adjustment page can be access from Transaction /Stock/Stock Adjustment. Here is where you can increased or decrease the stock quantity. To increase the stock quantity you need to enter positive quantity and to reduce the stock quantity you need to enter negative quantity. User need to select the warehouse optionally batch number and the Expiry Date and Manufacturing Date will come automatically (by default Select Warhosuse and Item Name System Stock Display). For the effect of the account you need to select the account Ledger from which the amount will get reduce or increased.

Stock Adjustment page is shown below

Stock Transfer

Stock Transfer page can be access from Transaction /Stock/Stock Transfer. This page can be used to transfer the stock from one warehouse to another(optionally from one batch in one warehouse to another batch in another warehouse).To transfer stock user need to enter Date,Inward Warehouse Name,Description,optionally Batch,Outward Warehouse,Item Name,Quantity and Rate.

Stock Transfer page is shown below



Purchase Order
Purchase Order page can be access from Transaction /Purchase Order. Here is where we can create Purchase Order. In Purchase Order the Order number come automatically. Contract date, Shipment Terms, Shipment Date, Status and Vendor Name need to be enter on Purchase Order Link. On the Description link you enter Item to  purchase ,warehouse ,optionally batch number, Quantity, Rate, Rate per unit and amount(which come automatically).On click of insert the data get display in the tabular form below. Here you can enter multiple items if required. The Total of all the item get displayed at the bottom of the page.


On the total link you need to select the currency, select the account and amount and click on insert button. Likewise if you have tax then selects the tax account

Purchase Order page is shown below

Purchase Invoice

Purchase Invoice can be access from Transaction/Purchase Invoice. Purchase Invoice Can be mabe in 3 different Method

1 ) By CreatingPurchase  Invoice Without Creating Purchase Order
2) By Creating Purchase Invoice From Particular Purchase Order
3) By Creating Multiple Purchase Invoice From One Purchase Order

1 Method

In Purchase Invoice ,  Invoice number come automatically. Contract date, Shipment Terms, Shipment Date, Status and Vendor Name need to be enter on Purchase Invoice Link. On the Description link you enter Item to  purchase ,warehouse ,optionally batch number, Quantity, Rate, Rate per unit and amount(which come automatically).On click of insert the data get display in the tabular form below. Here you can enter multiple item if required. The Total of all the item get displayed at the bottom of the page.

On the total link you need to select the currency, select the account and amount and click on insert button. Likewise if you have tax then selects the tax account

2 Method

In Purchase Invoice   Invoice number comes automatically. In Purchase Invoice link You need to select Purchase Order then automatically Contract date, Shipment Terms, Shipment Date, Status and Vendor Name display in Purchase Invoice Link. On the Description link All  Item   enter   in purchase order with warehouse, optionally batch number, Quantity, Rate, Rate per unit and amount Display in Grid View .Total of the entire item get displayed at the bottom of the page.

On the total link you need to select the currency, select the account and amount and click on insert button. Likewise if you have taxes then select the tax account

 3 Method

In Purchase Invoice   Invoice number comes automatically. In Purchase Invoice link You need to select Purchase Order then automatically Contract date, Shipment Terms, Shipment Date, Status and Vendor Name display in Purchase Invoice Link. On the Description link all  Item   enter   in purchase order with warehouse, optionally batch number, Quantity, Rate, Rate per unit and amount Display  in Grid View (Suppose In Purchase Order you enter 5 Item but you want to add only first two item then another 3 item remove from  purchase invoice grid view and then update Purchase Invoice. Now  if suppose if you want to Create New Purchase Invoice  base on  same purchase order then remaining 3 item get  display in Purchase Invoice  grid).Total of all the item get displayed at the bottom of the page.

On the total link you need to select the currency  , select the account and amount and click on insert button. Likewise if you have tax   then   selects the tax account

Stock Effect
Base on the Quantity enter in the Purchase Invoice the Inventory Stock for particular item. Get increase in the warehouse (Optionally in the Particular Batch if selected)



Purchase Return

Purchase Return page can be access from Transaction/Purchase Return Here is where we can create Purchase Return .In Purchase Return page Purchase Return number come automatically. Contract date, purchase invoice no, vender name you have selected in the Description Section you enter Item to  purchase Return ,warehouse , optionally batch number,Quantity,Rate,Rate per unit and amount(which come automatically).On click of insert the data get display in the tabular form below. Here you can enter multiple item if required.

(Note:- You Return only those item enter in Purchase Invoice with same warehouse(Optionally in the Particular Batch if selected))The Total of all the item get displayed at the bottom of the page.


in the total Section  you need to select the currency ,select the account and amount and click on insert button. Likewise if you have tax then selected the tax account

Stock Effect

Base on the Quantity enter in the Purchase Return the Inventory Stock for particular item
Get decrease in the warehouse (Optionally in the Particular Batch if selected)



Sales Order
Sales Order page can be access from Transaction / Sales Order. Here is where we can create Sales Order. In Sales Order the the Order number come automatically. Contract date, Shipment Terms, Shipment Date, Status and Customer Name need to be enter on Sales Order Link. On the Description link you enter Item to to Sales, warehouse ,optionally batch number,Quantity,Rate,Rate per unit and amount(which come automatically).On click of insert the data get display in the tabular form below.Here you can enter multiple item if required. The Total of the entire item get displayed at the bottom of the page.

On the total link you need to select the currency, select the account and amount and click on insert button. Likewise if you have tax then selects the tax account

Sales Invoice
Sales Invoice page can be access from Transaction/ Sales Invoice. Sales Invoice Can by 3 Method
1. By Creating Sales Invoice Without Creating Sales Order

2 By Creating Sales Invoice From Particular Sales Order

3. By Creating Multiple Sales Invoice From One Sales Order

1 Method

In Sales Invoice. Invoice number come automatically. Contract date ,Shipment Terms, Shipment Date, Status and Customer Name need to be enter on Sales Invoice Link. On the Description link you enter Item to to Sales, warehouse ,optionally batch number,Quantity,Rate,Rate per unit and amount(which come automatically).On click of insert the data get display in the tabular form below. Here you can enter multiple items if required. The Total of the entire item gets displayed at the bottom of the page.

On the total link you need to select the currency, select the account and amount and click on insert button. Likewise if you have taxes then select the tax account


2 Method

In Sales Invoice   Invoice numbers come automatically. In Sales Invoice link You need to select Sales Order then automatically Contract date, Shipment Terms, Shipment Date, Status and Vendor Name display in Sales Invoice Link. On the Description link All

 Item   enter   in Sales order with warehouse, optionally batch number, Quantity, Rate, Rate per unit and amount display in Grid View .Total of all the item get displayed at the bottom of the page.
On the total link you need to select the currency, select the account and amount and click on insert button. Likewise if you have taxes then select the tax account

 3 Method

In Sales Invoice, Invoice number comes automatically. In Sales Invoice link You need to select Sales Order then automatically Contract date, Shipment Terms, Shipment Date, Status and Customer Name display in Sales Invoice Link. On the Description link all
 Item   enter   in Sales order with warehouse, optionally batch number, Quantity, Rate, Rate per unit and amount display in Grid View (Suppose In Sales Order you enter 5 Item but you want to add only first two item then another 3 item remove from Sales invoice grid view and then update Sales Invoice. Now  if suppose if you want to Create New Sales Invoice  base on  same Sales order then remaining 3 item get  display in Sales Invoice  grid).Total of all the item get displayed at the bottom of the page.
On the total link you need to select the currency   , select the account and amount and click on insert button. Likewise if you have tax   then   selects the tax account

Stock Effect

Base on the Quantity enter in the Sales Invoice the Inventory Stock for particular item Get decrease   in the warehouse (Optionally in the Particular Batch if selected)

Sales Return

Sales Return page can be access from Transaction/ Sales Return Here is where we can create Sales Return .In Sales Return page Sales Return number come automatically. Contract date , Sales invoice no, Customer name you have selected
in the Description Section you enter Item to  Sales Return ,warehouse ,optionally batch number,Quantity,Rate,Rate per unit and amount(which come automatically).On click of insert the data get display in the tabular form below. Here you can enter multiple item if required.(Note:- You Return only those item enter in Sales Invoice with same warehouse(Optionally in the Particular Batch if selected))The Total of all the item get displayed at the bottom of the page.

in the total Section  you need to select the currency ,select the account and amount and click on insert button. Likewise if you have tax then select the tax account

Stock Effect
Base on the Quantity enter in the Sales Return the Inventory Stock for particular item
Get Increase in the warehouse (Optionally in the Particular Batch if selected)

Inventory Reports


 The Inventory Reports Menu is displayed when this option is selected from the Main Menu.

Intraweb Solutions has various reports available for analysis of Stock movements. Some reports give details of each incoming and outgoing Item and some are summarized reports based on various parameters.

The major Inventory Reports we would look at here are listed below.

Opening Stocks Register

. Stock Ledger
. Stock Statement
. Stock Movement
. Stock Valuation
. ABC Analysis
. Batch-wise Stock Analysis
. Ageing Analysis
. Reorder Report
. Fast Moving Items
. Slow Moving Items

 We shall study the above Reports in more detail on the following pages.
 
Opening Stocks Register

 
The Opening Stocks Register is a Report listing all the Opening Stock Balances, which are entered at the commencement of the Accounting Period or have been brought  forward from the Previous Accounting Year.

The Opening Stocks Register Parameters window is displayed when this option is selected from the Inventory Menu.

The Opening Stock Balances have to be entered at the commencement of the Accounting Period when you start using Intraweb Solutions for the first time. Thereafter, they will be automatically carried forward to the Next Accounting period, when the Current Year is “Closed”.

The Report displays the Date, Voucher Number, Product, Warehouse,Batch,Expiry Date,Mfg.Date,Quantity, Rate and Value.  

The Total Value of the Opening Stocks Register Report should tally with the Closing Stock Balance of the Previous Accounting Year. If it does not tally, recheck the Balances  brought forward with the Closing Stock Balances for the Previous Year.  

A sample Opening Stocks Register Report is displayed below.
 
Stock Ledger

 
This report displays complete details of all the Stock related Transactions over a selected  period.
The Stock Ledger Parameters window is displayed when this option is selected from the  Inventory Menu.
The Stock Ledger Report provides complete information regarding the Product related  Transactions.
It displays the Transaction Date, Voucher Number, Quantity Received, Rate at which Received, Quantity Issued, Rate at which Issued,
Quantity Balance, Average Rate, Value of Balance Quantity.

By default, the Transactions are listed in Date order for each Product.

The Report can also be filtered to view specific information, based on the criteria or  conditions you select .

Stock Statement

 
This Report displays the Daily Transactions of the Products in summary and also, the  effect of those Transactions on the Stock Balance and Value of the Products.  The Stock Statement Parameters window is displayed when this option is selected from  the Inventory Menu.  

For each  Product, it displays the incoming and outgoing transactions entered for that Product.

The report also keeps track of updating the Stock balance and Value with each transaction. Filter the report to see the Statement for a particular Warehouse.

Note that the Stock Statement differs from the Stock Ledger Report in that it does not  display the daily transactions in detail. You cannot view the Voucher Numbers of the  transactions or the individual Receipts and Issues. Rather, for each day it shows you the  Opening Stock Balance, Total Receipts, Total Issues and Closing Stock Balance for that  Day. The Receipts are added to the Opening Stock Balance and the Issues are deducted  to arrive at the Closing Stock Balance for the Day. Observe that the Closing Stock  Balance for one day is the Opening Stock Balance for the next day.

Stock Movement

The Stock Movement Report is similar to the Stock Statement Report but displays a  consolidated view of the Transactions for a Product over a given period.

The Stock Movement Parameters window is displayed when this option is selected from the Inventory Menu.

The Stock Movement Report is also sorted Product-wise. For each Product, it displays  the Opening Balance at the beginning of the Report period, the Total Quantity Received  and the Total Quantity Issued during the Report period, the Closing Stock Balance at the  end of the Report period and the Value of the Closing Stock Balance.  

You can filter the Report to view the information for a specific Warehouse

Stock Valuation

 
The Stock Valuation Report displays a list of Items with the Available Stock in hand, Unit  Cost and Value of each item.

The Stock Valuation Parameters window is displayed when you select this option from  the Inventory Menu.

The Stock Valuation Report shows you the Quantity of Stock on hand, the Unit Cost and the Value for each selected Product. Intraweb Solutions applies the method of  Valuation defined for each Product in the Product Master and displays the Value for the  Stock Quantity on hand, in the Report.

ABC Analysis

 
The “Always Better Control” (ABC) Analysis Report displays the Stock Balances in  descending order of their Value.

The ABC Analysis Parameters window is displayed when you select this option from the Inventory Menu.

The Report analyzes the values of the Inventory Items and displays the same in a  descending order, with the item having the highest value shown first. At a glance, this  Report would show you the Items  that have the highest level of investment  in your Inventory. This information would help you to take suitable decisions vis-à-vis  your Inventory management.

Batch-wise Stock Analysis


 
The Batch-wise Stock Analysis Report displays the Batch-wise Quantity on hand for each  Product. In other words, you can see the current Stock Balance of a Product broken  down Batch-wise.

The Batch-wise Stocks Parameters window is displayed when you select this option from the Inventory Menu.  you have an option to select the Batches that should be  displayed in the Report. The options are All Batches, only Good (valid) Batches or  Expired Batches,Select the appropriate and  Click OK to view the Report.

The Batch-wise Stocks Report is sorted Product-wise and displays the Batch-wise Stocks  details for each Product. These details include the Batch Number, the Quantity available  for the Batch, the Rate at which the Batch was received (Batch Rate), the Value (which is calculated as Quantity multiplied by the Batch Rate), the Expiry Date and Manufacturing Date of the Batch.

Ageing Analysis

 
The Ageing Analysis Report displays the age of the Stock Quantity on hand, grouping the  Quantity into various Ageing Slabs defined in Number of Days from the Date of entry.  The Ageing Analysis Parameters window is displayed when you select this option from  the Inventory Menu.

In the Ageing Slabs box, enter the Number of Days for the four Ageing Slabs. The  Report will use these Slabs to group the Stock on hand according to the Number of Days  elapsed since the Date of entry. Click OK to view  the report.  

For each Product  the Report displays the Total Stock Quantity on hand and it.s Value, before showing the breakup of the Total Quantity by the age of  the Stock. Essentially, the Stock ageing reflected here shows the number of days that  you have been holding these Quantities in your Inventory, irrespective of the Manufacturing or Expiry Dates for the same.
 
Reorder Report

 
The Reorder Report compares the current Stock Quantity with that defined as the  Reorder Level in the Product Master and displays all those Items where the Quantity on  hand is below the Reorder Level.

The Reorder Report Parameters window is displayed when you select this option from the Inventory Menu.

The Reorder Report checks the Reorder Level defined in the Product Master and  compares it with the  available Quantity balance. If the Quantity available is less  than the Reorder Level, Intraweb Solutions displays the Item, Quantity Balance, Reorder Level, the  Deficit Quantity to be ordered and the Deficit Value involved.  

The Report is useful to ensure timely Purchases of those Items, which fall below Reorder Levels from time to time. A periodic or regular review of this Report would help avoid  “Stock Out” situations, which otherwise disrupt Production schedules and Order Delivery  Schedules.


Fast Moving Items

The Fast Moving Items Report displays the list of Items having the highest Quantity  Issued from Inventory, in descending order of the Quantity issued by way of Sales or Consumption. Thus, the Item with the highest Issues is displayed first in the Report.

This Report is also referred to as the XYZ Analysis Report. The XYZ Analysis Parameters window is displayed when you select this option from the Inventory Menu.
The Fast Moving (XYZ) Analysis Report shows the outward movement (Issues) of Items from Inventory. The report displays the Items with highest Issue Quantity in a descending order that goes down to the Item, which has the lowest outgoing Quantity.

This report intraweb Solutionses on the Items that are fast moving in terms of Issues from Inventory, so that Stocks of those items can always be maintained.  

 
Slow Moving Items
The Slow Moving Items Analysis Report displays the list of Items having the lowest  Quantity Issued from Inventory, in ascending order of the Quantity issued by way of  Sales or Consumption. Thus, the Item with the lowest Issues is displayed first in the  Report.

The Slow Moving Items Analysis Parameters window is displayed when you select this option from the Inventory Menu.
The Slow Moving Items Analysis Report shows the outward movement (Issues) of Items from Inventory. The report displays the Items with lowest Issue Quantity in an  ascending order that goes down to the Item, which has the highest outgoing Quantity.

This report  on the Items that are slow moving in terms of Issues from Inventory,  so that Stocks of those items can be consumed or disposed off before their Expiry Dates.  
This report is required by management to analyze the inactive or non-moving Items, so  that they are not ordered again and also, to push out the slow moving Items through  promotions and schemes.

Barcode Inventory Control, Accounting and Business Management Software

We have Integrated Financial Accounting software with barcode for following user segments :

Business Houses * organizations * Traders, Dealers, Distributors or Stockists of Goods, Consumer Items, Pharmaceuticals * Wholesalers * Large Retailers * Medical Suppliers * Industries * Manufacturing Units * Automobile Dealers * Vehicle Service Stations * Garages * Petrol Pumps * Hotels, Guest Houses, Motels * Hospitals, Nursing Homes, Pathological Labs, X-Ray Labs * Newspapers, Magazine, Periodical Publishers * Commodity Brokers

Our software have features specific to the requirements of above user segments .
We offers the simplest, easiest-to-use manufacturing Bar code solutions in the industry. We offer a wide selection of quality products for creating, printing, and using bar codes. The use of bar coding in manufacturing is growing significantly. Bar codes provide fast, easy, and accurate method of data entry. The correct use of Bar codes decreases employee time required and increase an organization's efficiency.

Accurate inventory control is critical for any manufacturing company. Your enterprise needs to track receipts of goods, the movement of goods within or between locations, the sale, removal or other disposition of goods, and the precise valuation and status of goods remaining in inventory at any point in time down to the Location status, Color, Size, Style, Lot Numbers, Serial Numbers and Expiration Dates remaining in stock.

Apart from inventory bar coding is also implemented in transaction module. All transaction have unique bar code ID. Apart from that barcode is also used for identifying the customers, supplier and account heads. You can print the barcode labels from any module of the software using your laser or inkjet printers. No special barcode printers or fonts are required.

Our Accounting and Inventory Software is designed to provide you with accurate information on all aspects of your inventory and ensure you have the software tools to manage and control your inventory in the most cost-effective manner possible.
Task of Inventory Control

Fast and easy physical inventory counts
Accurate tracking of inventory
Accurate tracking of lot and serial tracked items
Bar code Inventory Module - Our Solution

Scan bar coded inventory items into the product record
Scan barcode of an item into invoice or memo to get all other information of the product filled in automatically for faster and accurate invoicing.
Print Bar coded Receiving Labels to track all incoming materials
Print Bar coded Pick Lists to track materials picked for shop orders or sales orders
Print Bar coded Shipping Labels to apply to packaged finished goods
Print Bar coded Serial number Labels to apply to finished product
To use labels to wand in physical count into Physical Inventory Module
Print Invoices, Vouchers etc. with barcodes for easy tracking of goods during shipping
Print barcodes on any laser or inkjet printer from within the the program. No special bar code printer or fonts are required.