eWarehousing

1

e-Warehousing
Web based Inventory and Invoice Software!
D E V E L O P E D B Y
Excellone
Technologies
2
e-Warehousing Advantages
Dependable

• Data integrity with high volume of data
  and security with 3 level user authentication.

Flexible

• The software can grow as your business grows.

Advanced

• 3 tier Client-Server architecture which allows
• the User Interface, Business Rules and
• Database Accesses to be separate processes.

Open Source

• e-Warehousing is developed in Open source
• software like PHP, PostgreSQL,
• Apache and Linux.

3
e-Warehousing Features
Management Level Features

• User Security Username/Password authentication.

• Multiple Warehouse.

• Flexible Pricing and Discounts.

• Sales Analysis Reports based on Sales
  Executives/ Area/ Product/Customer.

Day-to-Day Operations

• Inventory Issues, Receipts of Finished products
  and Raw Materials.

• Order Entry.

• Batch Order Processing.

• Billing and Invoicing.

• Print Picking Tickets and Fast Printing of
  Invoices in a batch.

• Order and Historic Invoice Inquiry.

• Integration with accounting software. Eg.
  Tally.

4
e-Warehousing Features Contt..
Stock

• Stock information of products and raw materials.

• Classification of products into different
  groups/brand.

• Entry of Purchase and issue of Raw Materials
  and
• its Modification/Deletion.

5
e-Warehousing Features Contt..
Order entry-Order Processing-Invoicing

• Different customers can have of different
  pricing.

• Classification of customers based on Tax, Area,
  and Discounts!

• Different customers can have of different tax
  rates.

• Unlimited no of Order Entry.

• Order Entry has Edit/Delete/Cancel Options.

• Batch processing and partial processing of
  orders from different customers

• Batch processing and printing of invoices!

• Sales return of products

6
e-Warehousing Features Contt..
Reports

• Sales Reports based on Sales in different area,
  products, brands, customers, executives and
  Sales Tax.

• Pending orders and cancelled order reports.

• Production reports based on brand, products and
  period.

• Stock reports based on period and products!

7
e-Warehousing Features Contt..
Other features

• Unlimited users can work on the system.

• Password protection and different access levels
  for users.

• Supports multiple companies, all with separate
  customers, products and invoice data files!

• Import/Export products and customers from/
  to text files!

• Exporting of transactions and masters to other
  account software.

8
e-Warehousing Over View
Administrator-User Creation
Stock-Purchase, Issue
Managers-Reports/Analysis
Sales-Order Entry
Sales-Invoicing
9
e-Warehousing Selection of Financial Year
Selecting Financial Year
Selecting Company
Option for creating Financial Year
Option for creating company
10
e-Warehousing Login Screen
11
e-Warehousing Add New Purchase Entry
Serial No. for each purchase entry
Supplier is listed from database
Calendar for selecting date
Excise Duty Paid
Different Suppliers can be in single entry
Option for removing Item before saving
Raw Materials from database
Save This entry
Add New Raw Materials
12
e-Warehousing List/Edit/Delete Saved Purchase
Entry
Editing Each raw materials in an entry
Delete Each raw materials in an entry
13
e-Warehousing Issue of Raw Materials
Issue Date
Issue Entry No
Issue is Allowed only if the required quantity of
raw materials is in the Stock
Issue Item
14
e-Warehousing List/Edit/Delete Saved Issue
Entry(Raw Materials)
15
e-Warehousing Receipt of Products into Stock
Receipt Entry No
Check here if this is sales return
Finished Products from Database
16
e-Warehousing List/Edit/Delete Receipt of
Products
17
e-Warehousing Order Entry
Click here to view Pending Orders from selected
customer
Order No.
Customers KGST no. and CST No. from database
Adders from Database
Check this if this is direct sale
Net rate-Rate After adding Tax
Assessable rate-Rate After reducing slab
percentage
Order Qty.
Order-Slab ge
Order-Total Amount
Products from database
18
e-Warehousing List/Edit/Delete Order
19
e-Warehousing Packing Slip
Location of Customer
No. item in an order can be changed
Order Delete-Packing Slip may contain more than
one order,more than one customer
Any Item can be deleted from a packing slip
20
e-Warehousing Invoice
Excise Duty
Customer Name
Sales Tax
Additional Sales Tax
Invoice Total
21
e-Warehousing Raw Material Summary Report
Input-Any date within financial year
Selected date
22
e-Warehousing Production Report
Selected dates
Input-Any two date within financial year
Current Date
23
e-Warehousing Daily Stock Report
Input-Any date within financial year
Selected date
24
e-Warehousing Stock Register
Selected date
Input-Any date within financial year
25
e-Warehousing Stock Position
Input-Any date within financial year
Selected date
Brand name
Brand wise total
26
e-Warehousing Pending Order Report
Input-Any two date within financial year and Area
of Customer
Selected Dates
Selected Area
27
e-Warehousing Cancelled Order Report
Input-Any two date within financial year and
Sales Executive
Selected Executive
Selected Dates
28
e-Warehousing Sales Report 1
Input-Month and Sales Executive
Selected Executive
Selected Month
29
e-Warehousing Sales Report 2
Input-Any two date within financial year
Selected Dates
30
e-Warehousing Sales Report 3
Input-Any two date within financial year and
Customer
Selected Dates
Selected Customers
31
e-Warehousing Sales Report 4
Input-Any two date within financial year
Selected Dates
32
e-Warehousing Sales Report 5
Input-Any two date within financial year
Selected Dates
33
e-Warehousing Sales Tax Report 1
Input-Any two date within financial year
Selected Dates
34
e-Warehousing Sales Tax Report 2
Input-Any date within financial year
Selected date
35
e-Warehousing Entry Book of Duty Credit
Input-Month
36
Thank You!