Inventory Input Form  
Latest Forum Posts
ActiveX control
I am writing a system which accesses & updates several tables of an order-entry database...
...............................
Database connnection
Please can anyone tell me how to set a database connection with a visaul basic 6....
...............................
TreeView
My tree is on two level:
-Node1
-- SubNode1
-- SubNode2

...............................

 

Softcreek India is one of the foremost company in India, providing Software & IT enabled services across the world. Softcreek India provides Inventory management system, including warehouse management system and solution. Also providing Software maintenance services. Softcreek India offers a comprehensive range of onsite and offshore services on various technology.

 

Softcreek India's managed & controlled inventory software's, enables to benefit you especially in these key input form.

  • Consuming less time, which ultimately, benefits the business in growing, so that you can focus on sales rather than maintaining the same.

  • Managed & Controlled program on your fingertips.

  • Verifying the products, sold to the customer.

  • Verifying with purchase materials to the sold materials.

  • Stock Taking , allows you to tally your physical stock with computer stock and lets you update your purchase/sale/stock data,intelligently and with ease

  • Auto generating of Code Nos.of all the materials of the stock is collected.

  • Calculations of the taxes applied by the government for all the materials purchased.

  • Maintaining Customer relationship by keeping in touch with the customer's by wishing them on their important dates, sending regular news letters etc

  • The software helps you to maintain customer master with personal details of the custome

  • To analyze on the needs of the customer's requirements, allows you to take orders on phone/through e-mail

  • Bar-coding of your products in user defined format. Allows you to scan bar-code of different type(i.e. system generated, Bar-code,product code etc.) and lets you save on bar-code printing for the products having manufacturer bar-code.

  • Stock Ledger.

  • The software provides, Warehouse Management, which allows user to sale products for multiple Godown and Auto Transfer goods from one warehouse to another

  • Excellent quality of output for Reports, all frequently used reports at the click of a button.

  • All reports can be previewed, printed, exported to Excel/Word etc.,or can be faxed or e-mailed

  • Also you need not worry about Accounting codes / Serial no of voucher etc. since the system auto-generates the same.

  • The Data Management functions:Data Import and Export Facility ,Excellent Data Management, Simplified data back-up,auto back-up on daily basis,Send / Receive Data of your branches spread across the Country, User level/Form level screen access for improved security

  • Overall Softcreek India, also develops the user defined software, the software will be developed as per the user's requirement.


This below listed modules will be the step by step accessible managed & controlled program.

  • Master's Module
  • P O/GRN Module
  • Job Card Module
  • Issue/Receive Module
  • Replace Module
  • Report Modul


Master's Module
Category Master
Item Master
Project Master
Product Master
Vendor Master
Customer Master
Engineer Master
Location Master
Tax Master
Opening Master
Receipt Master
P O/GRN Module
Purchase Order
GRN
QC
Other Entry
Job Card Module
New Job Card
Job Issue
Job return
Issue/Receive Module
Product Issue
Product Receive
Replace Module
Issue for Replacement
Receive Replacement
Dispatch
 

 

Master's Module

 

Company Master:


Company module is the first & foremost module wherein without log gin in this module you cannot further access or even view the software. Any company or firm is always registered & when a company is registered it has some kind of data which has to be implemented in various aspects of business.

All the required data is mentioned in this module where you can keep your company's information like company's name, its codes no, address. Its contact no., Fax no., e-mail address, web, B.S.T no., C.S.T no., Assesses code no., Ecc no., Reg. No. Of Factory, all the required details needed are mentioned in this Module.

  • While entering the software, you have to select the company name under which you want to enter the transactions.
  • You can enter the required details for generating reports & tax purpose.
  • All the transaction entries will get saved under the currently logged in company id.

When you select a particular company & log in you can then add the other companies also, at the same time. You can also give your B.S.T No. and C.S.T No., which will help you while generating forms and reports.

 

 

Vendor master:

All the Vendors are also important because you try to fulfill the clients ordered product through them. In case some of the materials you cannot manufacture then we are liable to satisfy them through vendors. They supply you those Semi finish, Raw Materials & Raw Products which are required to complete the Clients product, which you could not manufacture.

This is a database form where you can keep your Vendor's information like Company name, their Codes no, Address and all the necessary details needed in this form. All the vendor's information will get stored in this module.

You can enter all the contact details about each vendor, which will be utilized while creating reports. The concern persons name and his contact details will help you to easily stay in touch.


Information about vendor's tax numbers can also be entered here

It is some times necessary to mention vendor's tax numbers like his Central Sales Tax Number, Service tax number, Bombay Sales Tax number etc. Once you have entered those details with the vendor name, you can print those values in legal reports.

Other companies you own can be linked with each vendor.

If any of your vendor is dealing with another Company you own.

You don't have to enter his details every time you log under new companies.

Once you enter the vendor in the "Vendor Master form", you cannot delete the vendor from the "Vendor Master form 's" record because the "table order master" tool includes all the related record. Just select the companies with which the vendor is working and the supplier's name will automatically listed under those companies.

 

 

Customer Master:

Customer's are the Most important persons in any of the business field. In this stock management & controlled software you will enjoy managing the business with your clients just in your fingertips. Customer Relation Management (CRM) is very important aspect of any business, which will be satisfied with this controlled program.

This is a database module where you can keep your Customer's information like company name, their codes no, address and all the necessary details needed in this form. All the Customer's information will get stored in this module. Also if these records are saved & controlled in your fingertips you are likely to get in touch with the Customer more comfortably.

# You can enter all the contact details about each Customer, which will be utilized while creating reports.

# The concern persons name and his contact details will help you to easily stay in touch.

These days for innovative business management the "Bar-code" machines are utilized. Bar-coding of your products in user defined format. Allows you to scan bar-code of different type and lets you save the bar-code printing for the products.

To enter the code is become necessary, because it not only helps to refer the record, code no. wise, but also helps in the "Bar-code" machines which refers with the bar-code system.

Information about Client's tax numbers can also be entered here.

# It is some times necessary to mention Client's tax numbers like his Central Sales Tax Number, Service tax number, Bombay Sales Tax Number etc.

# Once you have entered those details with the Client's name, you can print those values in legal reports.

Other companies you own can be linked with each Client. If any of your Client is dealing with another Company you own. You don't have to enter his details every time you logged under new companies. Just select the companies with which the Client is working and it the Client name will automatically be listed under those companies.

 

Engineer Master:

In this module you have to enter the Engineer's details. You have to appoint many engineers if your business is vast, more engineers are required if you are business is expanded in many states. Thereby to keep the record of all the Engineer's is very necessary for the businessmen. All the materials & projects record will be maintained by each engineer regarding to the state he is working.

This is a database module where you can keep your Engineer's information like the Engineer's name, their codes no, address and all the necessary details needed in this form. All the Engineer's information will get stored in this module. Also if these records are saved & controlled in your fingertips you are likely to get in touch with the Engineer as and when you require.

You can enter all the contact details about each Engineer.

The concern persons name and his contact details will help you to easily stay in touch.

To enter the code is become necessary, because it not only helps to refer the record, code no. wise, but also helps in the "Bar-code" machines which refers with the bar-code system.

 

Category Master:
Includes: Category and its Excise code

1. While defining any product, you have to mention the category name, which will be populated from this table.

2. The excise code will be printed while generating legal reports, this will avoid errors by automatically relating with category. To enter the code is become necessary, because it not only helps to refer the record, code no. wise, but also helps in the "Bar-code" machines which refers with the bar-code system.


 

Item Master:


This module is prepared to keep the record of the "Items" details, to define the Items code, Category, Rate etc. If the Item is defined properly then on the click of the button you will get all the details required, also it helps at the time of generating reports because there are many items similar, you will get confused for which items details are displayed.

The fields included in this module are:

 

Product Code:

You have to define the Items code which will help you in billing. To enter the code is become necessary, because it not only helps to refer the record, code no. wise, but also helps in the "Bar-code" machines which refers with the bar-code system.

Item Name: You have to enter the Item's defined name.

Category: While defining any product, you have to mention the category name, which will be populated from this Master Module.

Rate: You can define the rate that will help you in calculating amount of the product with the quantities.

Warranty in months: You can enter the warranty period of the item that will keep the record while providing the service.

Minimum quantity:

You can define the minimum quantity required to the client that will help you in calculating amount of the product in quantity wise.

 

Project Master:

In this master module you have to define the clients name & its projects name. Some times same client gives us various projects, thereby to keep each projects record, you have to define each project with different name.

    Customer Name : Softcreek

    Project Name: Research & Development.

 

 

Product Master:


In this module you have to enter the Item Name, Its Type & Its quantity required.

    Item Name: You can define the Item's defined name.

    Item Type: You have to enter the Item's defined type.

    Item Name & Quantity: The Item's defined name along with the required quantity has to be entered



Location Master:


Includes: "Location List" & "Location Details"

This module is prepared to keep the record of the Customer's location. All the details saved in the "Location Details" can be viewed in the "Location List".

The fields included in this module are:

    Location Name: In this field you have to enter the location of the customer

    Customer: Customer's name has to be entered in this field.

    Project: You have to define the project name.

    Address: You have to enter the address name.

    Tel No.: Telephone no. is to be entered.

    Contact Person: You can enter the contact person's name in this field.

 

 

Tax Master:
There are many taxes applied, on the purchase materials & on sales against all the purchase materials, like Service tax, Turnover tax, B.S.T, C.S.T, V.A.T, Custom duty, Clearing & Forwarding charges. Thereby these taxes applied in each of the product has been integrated in the "Goods Received Module"

 

Opening Master:


As you have to keep the opening stock report of the product to start the business. This module will give you the information of the "Semi finish " stock collected at the start of the software or the accounting year. You can thus keep the record of the current stock and thus maintain the stock accordingly.

The main feature of this software is when the stock of any materials details is entered in the product master module the ISL no. of each of them will be generated automatically. The ISL No. generated is the code of each material to differentiate all the items to each other. By the ISL no. the details of each parts issued, received or send back becomes easier & accurate, so that you do not get confused by the items which are similar.

In this module you have to enter the Item Name & the No. of Quantity, as soon as you enter the "Add" button The ISL No. of all the materials will be genrated automatically.

 

 

Receipt Master:


Includes: "View Receipt" & "Receipt Details"

All the details saved in the "Receipt Details" can be viewed in the "View Receipt".

This module gives you details of the items that you have received either from the "Vendor", from whom you purchase the materials, or the materials received from the "Engineer's" for the repairs purpose of the customers . Thereby to keep the track of the record of the materials details is very necessary. All the necessary fields required are as follows:

    Engineer Name: In this field you will select the engineer who have received the material back.

    Remark: Any remark informed have to be entered in this field.

    Receipt: The date of the receipt received is to be entered.

    Receipt No.: The receipt no. has to be entered.

    Engineer Challan No.: The challan no. has to be entered.

    Item: The item name of the received material is to be entered in this field.

    ISL No.: You have to define ISL no.

    Replaceable: You have to mention that the material is replaceable or not.

 

 

 

P O/GRN Module


Purchase Order

This module enables you to keep the record of the order given to the Vendor of the product, which further helps you to verify with the order given. This
also helps to analyze, on the comments given, the quantity, & on the amount of rate ordered etc.

Includes : "View Order", "Order Details"

View Order:
All the record saved in the "Order Details" can be viewed in the "View Order".

Order Details: Order No., Date, Comments, Product, Quantity, Rate, Amount Order No.

Vendor name: Vendors name from whom you are purchasing the product has to be mentioned.

Purchase Order Ref no: You can enter the Ref no., it helps you to keep the record of the bills while referring the bills no. wise.

Date: The Date is to be mentioned for the record of the material on which date the order has been taken.

Raised By: The employees name who is providing you the material, has to be entered in this field, to keep the record.

Remark: You can enter Particular comments, which are to be noted down, & which is to be undertaken & implemented while taking the order.

Item name: You have to mention the item name, which has been ordered to be purchased.

Quantity, Rate & Amount: You have to define Quantity, Rate & Amount which will help you to give the estimation, & to compare the purchasing cost with the selling cost.

 

 

GRN Module:



This module keeps the record of all the materials which you have received at your end for the order placed to the "Vendor". It also helps in verification with the purchase order given. For any reason the material received from the vendor against the order made may vary, thereby "Goods Received Note" (GRN) will help you to verify with the purchase order made & against it the goods received.

Also this module includes the field of the taxes applied on the all the materials according to the government rules. This helps in calculating the charges of the taxes of each material at the same time.

Includes: "View GRN","GRN Details"

View GRN:
All the record saved in the "GRN Details" can be viewed in the "View Order".

Vendor Name: The Vendors name is to be mentioned in this field.

Project Name: The name of the project should be entered in this field.

GRN No.(Goods Received Note): You have to enter the GRN no.

Date: The Date is to be mentioned for the record of the material on which date the goods are received.

Invoice No.: Invoice No.has to be entered in this field to verify with invoice no.wise.

Invoice Date: Invoice Date has to be entered in this field to verify with invoice date wise.

Quantity: You can add the no. of quantity required

Part No.: Part no. is to be defined.

Rate: The rate applied to the material has to be mentioned.


Pending Products

Item Name: The Item name of the pending product is to be mentioned, which helps to know the name of the pending products.

Quantity: You have to enter the amount of Quantity of the pending product.

Quantity Received: The Quantity Received of the pending product is to be mentioned.

Received Products

Item Name: You have to enter the Item name of the pending product.

ISL No.: ISL no. is required on the received products which will help the product to be verified by number wise.

Sub Part No.: Sub Part No. is required on the received products.

Amount: Amount has to be mentioned of the received products.

Total Amount: Total amount of the goods received is to be entered in this field.

Final Amount: Final amount of the goods received is to be mentioned.

 


Quality Checking (QC):



GRN No.: The GRN No. is to be defined to check the materials quality.

Item: You have to select the Item name you require to check the materials quality.

ISL No.: The ISL no. is to be mentioned to check the materials quality.

Pending Product List:

Item name: You have to enter the Item Name of the materials which have to be yet checked will be known as pending product.

ISL No.: The ISL No.is to be mentioned of the pending product.

Quality Checking (QC) By: You have to enter the Name of the person who is checking the quality of the pending product.

Date: The Date of the materials which are pending has to be mentioned..

Remark: Remark has to be mentioned in this field for the pending material

.

 

 

Job Card Module:


New Job Card :


This module keeps the record of all the raw materials required to complete the product. Also the materials required to complete the project may not be neccessarily required all at once, you may require the sub parts as & when needed. Also the materials required to complete the project may not be neccessarily required all at once, you may require the sub parts as & when needed. Thereby Job card helps to take the record for all the utilized & pending materials required for the particular project with its date. This will help to know all the number of parts of the "Job" utilzed with its date & also the no. of parts pending for that "Job".Thereby Job card helps to take the record for all the utilized & pending materials required for the particular project with its date. This will help to know the number of parts utilzed with its date & also the no. of parts pending.

It keeps the record of a particular Project's details, the raw materials issued for the project, the status of the production of the project, & the replacement of the materials record. Thereby there are divisions provided in this module like, "View Job card", "Job Card Info"," Issue Details", "Production", "Replacement" & each division specifies details of the materials which helps not only to keep the record but also helps in the verification of the materials.

    View Job card: All the details saved in the Job card info can be viewed in the "View Job Card" division.

    Job Card Info: In this division, Product name, its Description, Customer name, Location, Start Date, End Date etc these details are available.

    Issue Details: All the raw materials as & when you require for the particular job is issued, thereby the details of the materials like its part no. date of issue, & item name is to be mentioned in this division.

    Production: The status of the production of the materials is to be mentioned in this division.

    Replace: In this division, replacement of the materials name, issued against & its part no., its ISL no., quantity required, quantity issued, & replaced with is to be mentioned.

 

 

Job Issue:

This module specifies the details of the Materials issued, like the Item name, its ISL no., Part no., Issue date, Job no.etc which helps to verify easily.


Job Return:

This module specifies the details of the Materials returned which is not required of the particular project, like the Item name, its ISL no., Part no., the Date, Job no., Loacation name & Project name.

 

 

 

Issue/Receive Module:
This module specifies the details of the materials which are "Issued" to the customer for the materials which are not working for any reason, & "Received" from the customer for the replacement or repair purpose.



Product Issue:

This module specifies all the details of the materials which is issued to the customer. All the details will be specified as the "Customers name" from whom the product is issued, the "Project's name", the incharge "Engineer's name", the issued #FFD384"Item name" & its "ISL no.", & also any other item with its returning period is to be mentioned.


 

Product Receive:

This module specifies all the details of the materials which is received by the customer from us. All the details will be specified as the "Customers name" to whom the product is returned against the product issued, the "Project's name", the incharge "Engineer's name", the issued "Item name" & its "ISL no.", is to be mentioned.

 

 

Replace Module:
Sometimes the parts purchased from the vendor is not in the working condition for any of the reason, thereby it has to be replaced. This module specifies the details of the materials which are issued for the replacement purpose to the vendor & received for the replacement purpose from the vendor.

 

 

Issue for Replacement:
Issue for replacement includes all the details of the materials which are issued to the vendor for the replacement purpose.

Vendors Name: Vendors name has to be mentioned from whom the material is purchased & has to be issued for the replacement purpose.

Issue No.: Materials Issue no. is to be entered which helps to immediately refer the bill no. wise.

Date: The issue date which helps to know when it will be received against the date issued.

Item name: The Item name which helps to know the part of the material which is issued to be replaced.

ISL no.: The ISL no. which will help to verify the materials which are of the same name.



 

Receive Replacement
Receive replacement includes all the details of the materials which are received against issued from the vendor for the replacement purpose.

Vendors Name: Vendors name has to be mentioned from whom the material has to be received against the issued item for the replacement purpose.

Issue No.: You have to select the issue no. accordingly the items to be received will be displayed for the replacement purpose.

Date: The received date which helps to know when it will be received against the date issued.

Item name: The Item name which helps to know the part of the material which is received against the issued material for the replacement purpose.

ISL no.: The ISL no. which will help to verify the materials which are of the same name.

 

Dispatch:

There are many raw materials required to complete a "Product". All the "Products" which are completely ready to deliver to the customer is knowns as to be the "Finish Goods". These Goods you can then deliver to the customer, thereby the materials are to be dispatched to deliver to the customer. In this module you have to enter each "Finish Good" for the record purpose & also for the verifies that the customers have delivered the ordered product.

Project Name: Project name which you have completed is to be mentioned.

Customer Name: Customers name of whose the project has been completed you have to enter its name.

Location: You have to enter the Location where the product is to be delivered.

Challan No.: The Challan no. is to be mentioned.

Challan Date: The Challan Date is to be mentioned.

Dispatch Date: You have to enter the Dispatch date.

Installation Date: Installation Date may vary from the dispatch date thereby the installation date has to be entered.

Invoice No.: You have to enter the Invoice no. of each product.

Invoice Date: Invoice Date has to be entered in this field.

Description: In this field you can enter the details you require to add at the time of the delivering the product.

 
Home | Reseller
 
Software Development
What is MLM?
Free Multi-level Marketing Software
Free Network Marketing Software
Free Online MLM Software
CRM Software
Check/Cheque Printing Software
Invoice / Bill Software
Matrimonial Software
Inventory Software
Inventory Model
Inventory FAQ
Accounting Software
Payroll Software
ERP Software
Time Tracking Software
Portal Development
Payment Gateway Integration
Flash Development, Designing and Framework
 
Web Development
e-Commerce
Shopping Cart
Web Designing
Website Development
Online Sales
Offshore Flash Development
 
 
 















































Free online MLM Software
Try our online MLM Software Free

Free online MLM Software
Try our online Inventory Software Free

Home Contact Us About Us Site Map
VirtualSplat ©Copyright 2005. SoftCreekIndia. All Rights Reserved.