| 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.
|
|
|
|
|
|
- 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
|
|
|
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
|
|

|
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.
|
|
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'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.
|

|
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.
|
| 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.
|
|
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.
|
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.
|

|
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
|

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.
|
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"
|

|
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.
|

|
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.
|
|
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.
|

|
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.
|
|
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
|
.

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.
|
| 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. |
| 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. |
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.
|
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.
|
| 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. |
| 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 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 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.
|
|
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.
|
|
|