Master Menu
Item Main Category Group
Sub Group :( In sub Group you created multiple Sub Group for One Main Group for Company Item Sub Group page )
Color In Color Page You add new color for Item (If required)
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.
Currency In Currency Page you create multiple currency require for company transaction)
Currency Exchange Rate ( In currency exchange rate you enter currency exchange rate for particular currency selected from drop down list and date.)
Status : In Status Page you enter Status that require for Transaction section example (Completed, Canel led etc.)
Quality
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.
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)
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. |