| 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's stock management software discovers innovative
business inventory model in view to satisfy the administration management
required to all the businessmen dealing in stock keeping. Softcreek
India also aims to lessen the over burden occurred to all the
businessmen maintaining their business manually, by providing Softwares
& IT enabled services across the world.
Virtual Splat provides you, an outstanding, interactive, modular
based software, which is running successfully in the business
man's offices especially for the stock keeping requirement.
Softcreek India's stock management saves your time, effort
and organizes your resources. Easy to use software with helpful
key features, it will guide you through the whole stock control
process.
Key Features
1. Complete Inventory and Stock Management
2. Real Time Inventory Control
3. Data Management
4. Job Master
5. Goods Receive Note
6. Serial & Lot Number Tracking
7. Invoices
8. Quotation
9. Purchase Orders
10. Work Orders
11. Production control
12. Production Management
13. Stock Ledger
14. Sales Order
15. Asset Tracker
16. Order Processing
17. Auto Generating of Product Code
18. Warehouse Management
19. Barcode Management
20. Shipping Management
21. Quality Checking Of Goods
22. Advanced Tax Systems
23. Auto Generating Reports & Auditing Of Reports
24. Payment Processing:
COMPLETE INVENTORY AND STOCK MANAGEMENT:
- The Data Management functions: Data Import and Export
Facility, Excellent Data Management, Simplified data back-up,
Auto back-up on daily basis.
- Also you need not worry about Accounting codes / Serial no.
of voucher etc. since the system auto-generates the accounting
code/ serial no of voucher etc.
- Auto generating of code nos. of all the stock of the
materials is collected.
- Stock Ledger module provided wherein you can enter all
the stock related data more precisely.
- 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.
- This software provides, Warehouse Management, to keep
the record of the sold products for multiple Godown and also tracks
the record of the transfer of goods from one warehouse to another.
- 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.
- Modules available for Verifying the Products, sold to
the customer.
- Modules available for Verifying with Purchase materials
from the vendors of the sold materials.
- Adds an unlimited amount of items & categorizes items
to differentiate more precisely, create filters for grouping of
like items.
- Calculates depreciation using three different methods.
- Calculations of the taxes applied by the government for
all the materials purchased.
- Password-protection for sensitive data & ability
to back up your data for important safekeeping.
REAL TIME INVENTORY CONTROL:
This is a true Real-time Inventory Control feature and
Warehouse System. This Software combines E-commerce Systems,
Warehousing, Sales Tracking, Inventory Systems,
Customer Relationship Management, & Product
Data Management.
- Providing E-commerce website development, which offers
a variety of shopping cart solutions and online store packages
ranging from simple product catalogs and shopping carts to advanced
features like online payment, inventory management and order tracking
features.
- This software provides, Warehouse Management, to keep
the record of the sold products for multiple Godown and also tracks
the record of the transfer of goods from one warehouse to another.
- Customer Relationship Management (CRM): Putting Customers
at the Center of the Business. CRM systems can be very
effective solutions for managing sales cycles.
- Inventory Systems offers an operation where order-fulfillment
windows may be as narrow as possible, and penalties for late delivery
may be considerable.
- The ability to react quickly to operational problems
such as delays, breakdowns, last minute orders, etc. is
the solution in the Inventory Systems.
- Also allows planners to tackle this problem by replanning
optimally, thus reducing the need for over-resourcing and
spot-hire while improving service levels.
- Its user-friendly graphical interface allows fast and effective
interaction with the system through on-screen maps, reports
and editors.
DATA MANAGEMENT:
Data is the lifeblood for decision-making. Captures accurate data
and have it accessible to you, in real time and in an easy-to-read
format.
- 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.
- Scalable:available with MS-SQL Version.
JOB MASTER:
Job Master 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 necessarily 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 the number of parts utilized 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. Also the materials
required to complete the project may not be necessarily 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 the all number of parts of the "Job"
utilize with its date & also the no. of parts pending for that
"Job".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.
GOODS RECEIVE NOTE:
Goods Receive Note 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.
SERIAL & LOT NUMBER TRACKING:
In this module you need not worry about Accounting codes / Serial
no of Voucher etc. since the system auto-generates the same.
- The system controls all the products in an organized manner,
from the time you receive them into your warehouse, stock them,
sell them, you can & even track them after sale.
- It allows you to create and track an unlimited amount of
products that have lot numbers or serial numbers.
- The system integrate a barbed reader to scan items that have
serial number bar-codes. 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 all the products.
INVOICES:
An Invoice is a bill that needs to be paid by the party
related to the transaction made. Invoices are of two kinds, "Invoice
Received" these are received from the "Vendors" for
the items purchased. "Invoice Issued" these are to be
issued to the "Customers" for the items sold. Thereby
there are both the input forms provided, which enables you to keep
the record of the orders of the product, which further helps you
to verify with the status of the order of the products. This also
helps to analyze, on the comments given, the quantity, & on
the amount of rate ordered etc. Invoices that confuse the information,
incorrectly state terms or arrive incomplete can be a massive headache
for all parties. These mistakes will delay the payment process.
- Names and Addresses of both client and contractor, is to be
mentioned in its respective fields, related to the transaction.
- You have to make a clear distinction between the to
party and the from party.
- Mention the "Date" in the invoice (the day it goes
out, & not the day you write it) and You have to list the
dates of when items on the invoice were completed.
- In the terms, list the due date and penalty dates. The terms
of the invoice. At the very least, this should include when the
invoice is due; for instance, if you expect payment within thirty
days (fairly standard), simply put 30 Days.
- A clear, itemized list of services rendered. Descriptions you
mention should be short and to the point, and all delivery dates
indicated.
- The total amount owed, should be mentioned, in its field given,
bolded if needed.
QUOTATION:
Quotation module develop quotes quickly and easily! Users can quickly
quote items factoring in such costs as materials, labor, taxes,
and overhead/profit markups. Markups can be done as a percentage
or a dollar amount. Customer discounts can be included. A history
may be kept of all quote revisions as well as a complete history
of all quotes customer by customer.
PURHASE 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.
WORK ORDER:
Work Order processing is a light manufacturing solution that lets
you effectively manage the step-by-step conversion of raw materials
into finished goods inventory. The result is end-to-end module functionality
between sales/pricing and inventory/purchasing, eliminating inefficiencies
in the light manufacturing process.
- Work order comments let you define your work order procedures
step-by-step.
- Work order templates eliminate having to recreate a work order
every time a product is ordered.
- Accurately forecast when products will be ready to sell.
- Attach a work order to an item in sales order entry.
- Tracks raw material usage and availability.
- Tracks the conversion of raw material into finished goods inventory.
- Verifies whether a work order can be filled from existing stock
since on-hand availability of component items is automatically
adjusted for sales and work order commitments.
- Manages multilevel, bill-of-materials without confusion.
- Build a finished product from smaller components and automatically
reconcile the costs that accrue from activities related to building
a finished product.
- Ensure that material needing value-added processing is shipped
to the vendor at the appropriate time.
PRODUCTION CONTROL:
The software provides a fully integrated approach to planning,
management and administration of all aspects of the production process.
Producing the product is one part of being a successful job shop
or manufacturer. Administration, tracking, and paperwork is the
other part, and Job Master makes it easy. Job Master provides for
complete histories, inspection tracking, employee accountability,
password control, production status at a glance and more. Network
and multi-user ready out of the box, Job Master is the solution
to administer, control and track the production jobs which are central
to the success of your business!
PRODUCTION MANAGEMENT:
Effective production management involves understanding of the
characteristics of various types of production systems, identification
of the dynamics of the different phases of the management process,
realizing the potential of different analytical tools, learning
the nuances of the implementation of these tools, visualizing the
impact of various uncertain situations and developing the ability
to react under various scenarios to achieve consistently excellent
business results.
Numerous tools are provided for the monitoring of production and
output. At any time, the job status of a particular order can be
checked including where it is in the production cycle, and the work
remaining. Date range reports can be pulled detailing how much product
was actually shipped during a given time. Other reports detail such
things as work in production and the dollar value of that work.
Managers can also easily review missed or approaching deadlines.
Production Management tracks all aspects of manufacturing production.
It maintains historically accurate records as well as real-time
information of the production process including defect tracking
and complete product genealogy.
- A tool is provided to track the record of production of the
materials data and output of the materials data.
- Tracks the record of the availability of raw materials; pre-press,
printing, and finishing facilities; etc.
- At any time, the job status of a particular order can be checked
including where it is in the production cycle, and the work remaining.
- Date range reports can be pulled detailing how much product
was actually shipped during a given time.
- Other reports detail such things as work in production and the
dollar value of that work.
STOCK LEDGER:
Stock Ledgers are prepared to keep the track of the stock of the
materials. The Stock Register module tracks stock and stock transactions
of all the materials. Stock Ledger computes the actual cost of goods
sold and gives a view of inventory throughout the year, at the class
and department level in a variety of categories. Stock ledger also:
- Applies all costs associated with each class of merchandise
by updating the inventory value by:
- Sales/Refunds/Voids
- Receipts from Returns to Vendors
- Discounts
- Markups/Markdowns
- Inter-Store/Inter-Department Transfers
- Manual Offset Adjustments for Shrink
- Stock movement statement: Online stock information of
selected products for chosen warehouse and UOM. Lets you Track
Inter Warehouse Stock Movement.
- Online stock status with P.O generation to preferred vendor
for multiple items.
- Repackaging of products in different denomination and generate
barcode for repacked products.
- Automatically convert stock from one Units Of Measure (UOM)
to other i.e.Buy shampoo in strips and sale in pouches and system
maintains stock in strips and pounches.
- Stock Taking :Allow you to tally your physical stock with computer
stock and lets you update your purchase/sale/stock data,intelligently
and with ease.
- Creates pending entries which are applied to the stock ledger
nightly (or at end of day) as part of your reporting sequence.
- Keeps daily, month-to-date and year-to-date totals by fiscal
month.
- Automatically posts physical inventory count discrepancies as
adjustments to the pending stock ledger.
- Allows for tracking of which customers bought what goods.
- Allows for tax exempting certain classes or departments of merchandise
by customer groups.
- Expiry Management.
SALES ORDER:
A simple mouse click transforms a quote into a Sales Order.
An entire quote can become a sales order, or only certain line items
from the quote can be selected to appear in a Sales Order. As an
option, Sales Orders can be created directly without first preparing
a quote. The Sales Order Module keeps an optional history of all
revisions to each individual Sales Order, as well as a complete
history of all Sales Orders on a customer by customer basis. Generates
customer invoices & tracks opportunities, accounts,
and activities.
- Sales Order Acceptance
- Sales Invoice
- Sales Challan
- Bill Details / Summary
- Product Details
- Charges- Deductions Details
- Profitability Sales / Purchase Doc
- Interest Calculations
- Periodic Summary With Monthly
- Sales Related Reports
- Sales Tax Form tracking and reminder
- Sales Tax Wise Columns/Summary
- Sales Tax Form / Reg. No. Details
- Quarterly Total
ASSET TRACKER:
Asset Tracker for Networks is an inventory software tool intended
to audit software and hardware components installed on the computers
over the network. This asset management tool will collect your network
inventory information, provide the Network Administrator with the
detailed comprehensive reports and allow to export assets details
to external storages, such as SQL database or web site.
ORDER PROCESSING:
Order Processing Systems receive customer order information and
inventory availability from the warehouse management system and
then groups orders by customer and priority, allocates inventory
by warehouse site, and establishes delivery dates.
Orders can be tracked through the various stages of completion,
can maintain different levels of priority, or can be the driving
function for an efficient cross-dock operation. Fulfillment options
include directed stock picks, work order generation for assembled
items using the inventory module's kitting data, and order clearing
through the use of automated backorder capabilities.
Once approved, the orders automatically register on the Dashboard
of the warehouse manager. And once fulfilled, the orders automatically
become items to be billed.
- The order processing goes through a sequence of steps before
the order gets shipped out of the warehouse.
- Captures and processes orders throughout the day via the web,
phone, mail, fax, e-mail and other electronic transmission.
- Orders in process, as soon as they get completed, will be shipped
to their respective customers.
- The purchase order process is more efficient and tracked more
effectively by using digital technology.
- The system also takes care of tracking every ordered item through
all possible transaction scenarios, and automatically notifies
customers of changes in order status.
- Information on the nature of the purchase, vendors, and delivery
dates can be defined and used to prepare and issue a purchase
order.
- Order processing helps to verify the goods received are recorded
and matched with issued purchase orders to complete the workflow.
- It can process and forward credit card payments for you on behalf
of the customer.
- Supports regulatory compliance by implementing internal controls
and clear accountability.
- Service provision at the right time, right place, & with
best quality.
- Complete Audit Trail of Every Stock Movement.
AUTO GENERATING OF PRODUCT CODE:
The software generates the "Code No." automatically for
each materials. The "Code No." of each of them will be
generated automatically on the stock of all the materials collected.
The "Code No." generated is the code of each material
to differentiate all the items by each other. By the "Code
No." to differentiate each of the parts issued, received or
send back becomes easier & accurate, so that you do not make
mistakes on the items which are similar.
WAREHOUSE MANAGEMENT:
Warehousing facilities are secured and manned by skilled and
experienced team members for the best, superior service. Most orders
received get processed and shipped the same day for quick, efficient
service. Strict quality control systems and procedures in place
to check and double-check all aspects of the process to ensure quick,
accurate, and efficient order fulfillment. Each order picked is
scanned using the latest bar code technology to guarantee accuracy
before it gets packaged and shipped. Number one priority to process
orders received and ship all orders quickly, accurately, and efficiently.
Once approved, the orders automatically register on the Dashboard
of the warehouse manager. And once fulfilled, the orders automatically
become items to be billed.
- Drop shipments
- Printed packing lists
- Shipment tracking
- Serial number capturing
- Product kitting/building
- Careful packing
- Secured inventory
- Bar code labeling
- Shrink wrapping
- Skip zone shipments and more
BARCODE MANAGEMENT:
Bar-code Software can construct all common linear bar-codes using
barbed fonts. This feature enables businesses to create bar-codes
as part of the larger economic system. It can print the required
labels so they can be attached or added on to the desired product.
Barbed software utilizes machine readable symbols made of patterns
of black and white bars and stripes. Bits of information are encoded
within bar codes and are read by a bar code scanner. Bar-code software
is most often used in conjunction with databases and is utilized
on everything from shipping forms, labels, ID cards, direct mail
pieces, Tape cartridges and invoices to retail items. Bar-code software
does not require human input, can be read by automated machines
and is virtually error free.
- Bar-codes provides a quick and error free means for inputting
the data into an application running on a computer.
- By using bar codes, the potential for errors from manual data
input is eliminated.
- A typical application for bar codes is for inputting data without
having to type. For example you could encode name or address data
in a bar code on an ID badge and then scan the ID badges to input
a persons name into a computer program instead of typing the information.
- Bar-codes provide a simple and inexpensive method of encoding
text information that is easily read by inexpensive electronic
readers.
- Bar-coding also allows data to be collected rapidly and with
extreme accuracy.
- A bar-code consists of a series of parallel, adjacent bars
and spaces. Predefined bar and space patterns or "symbologies"
are used to encode small strings of character data into a printed
symbol.
- Bar-codes can be thought of as a printed type of the Morse
code with narrow bars (and spaces) representing dots, and wide
bars representing dashes.
SHIPPING MANAGEMENT:
In the shipping module, all completed items appear on a list of
product to be shipped. The shipping work screen allows selection
of quantity to be shipped, destination, and entry of the number
of boxes to be used and the weight. A packing slip and invoice are
produced with mouse clicks. If only part of an order is shipped,
the packing slip details not just what is being shipped but the
balance remaining. The invoice bills only for what is actually shipped,
and a running balance is kept of what product is owed to the customer.
- Automatically imports tracking numbers, pickup dates & shipping
charges.
- Get Delivery Confirmation Numbers from the US Postal Service
with a couple of button clicks.
- Print USPS shipping labels with Delivery Confirmation barcodes.
- Packages can be tracked from the View Orders screen in the Order
Manager.
- Tracking numbers can be used in emails to customers.
- Customer emails can be sent automatically when new tracking
numbers are imported.
- Tracking numbers can also be displayed as live links to UPS,
Fedex, USPS, etc. in the Stone Edge Order Status System
QUALITY CHECKING OF GOODS:
Quality Checking Of Goods 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
all the materials according to the government rules. This
helps in calculating the charges of the taxes of each material at
the same time.
ADVANCED TAX SYSTEM:
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
etc. Thereby these taxes applied in each of the product has been
integrated in the "Goods Received Module", so that the
reports generated have comprised all the taxes related to the transactions
of the products.
AUTO GENERATING & AUDITING OF REPORTS:
Numerous reports and printouts are contained in Job Master from
production output to sales commissions due.
Provision for extensive reports and customize reports for any specific
need. These reports can help you analyze your business, spot trends,
calculate your ROI and determine optimal promotions for future campaign
successes. Each report can be downloaded into an Excel spreadsheet
at a moments notice.
- 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 emailed.
- On Line Trial Balance and Balance sheet at the click of a button.
- On-line & Batch mode voucher & cheque printing.
- Bank Reconciliation report as per the book keeping rules.
- DOS/Fast Printing for Voucher, Invoice printing is available.
- Invoices at lightening speed. Also gives you the comfort of
managing multiple.
- Group Consolidation
AUTOGENERATES THE REPORTS LISTED BELOW:
- Current Stock Report
- Stock As On
- GRN Wise Issue
- Purchase Order Report
- Item With Outside Engineers
- Stock Valuation Report
- Consummation Of Raw Material
- Movement Of Finish Goods
- Sales and Marketing Reports
- Accounting Reports
PAYMENT PROCESSING:
We manage and process the payment processing and billing for the
majority of our clients. The main payment methods are:
- All major credit cards - We deposit the funds directly into
your merchant account.
- Checks - We deposit the checks into your local bank account.
- Purchase orders - We invoice the customer and follow-up if payment
is not received.
- Wire transfers - We manage the process and verify payment was
received in the account.
- Money orders - We deposit the money order into your local bank
account.
|
|