eApplications: APPLICATION MANAGER
ERPWEB is e-Business Operating System

Software Demo: Automatic Application Design: Create | Edit | Delete
Software Demo: Manual Application Design: Menu | Workflow | Database | Reports
Software Demo: Document: Open | Approve | Offhold | Closed | Rejected | Reports | Workflow

ERPWEB has Rapid Application Development Tool that allows you to create application totally automatic by just supplying document name & workflow. Whereas ERPWEB also provides semi-automatic application design tool. If you want a totally customized application you can still choose old, time consuming, complex, Object Oriented Approach promoted by Software Engineering Methodolgy OOAD with languages like UML, HTML, ASP, VB & JAVA.


METHODOLOGY 1: Automatically Designing an ERPWEB Application

A. Creating New Application

  1. Open Browser write application URL & Start ERPWEB.
  2. From Main menu login to Application Manager.
  3. Click on New Application Design link based menu.
  4. Give Application Document name in short form less than 10 characters.
  5. Check Master/Document Checkbox if you want to create Master/Detail type of application.
  6. Select Submodule or Procedure this Document Application will belong to.
  7. Select Users to define workflow like who will create, approve, offhold & print document.
  8. Click on Create Document & Workflow button at bottom.
  9. Now ERPWEB will create all program files, Database Tables & Views & will also enter required data in database to make application operational up, running and functional. This is a CASE (Computer Aided Software Engineering) Tool.

B. Deleting Existing Application

  1. From Main menu login to Application Manager.
  2. Click on Delete Application Design link based menu.
  3. Select Document or Application name that you want to delete.
  4. Click on Delete Document & Workflow button to delete the application.
  5. This will delete all Tables, Views, programs & dataentry pertaining to this applications.

C. Modifying Existing Application

a. Edit Document Design
  1. From Main menu loginto Application Manager.
  2. Then select the application that you want to edit or modify. e.g TestModule.
  3. Edit Document Design
  4. If you want to modify application at Document level click on edit link.
  5. This will allow you to change Document Name & Document grouping under submodule.
  6. Plus this will also allow you to change the basic SQLs used to operate your document.
  7. Edit Function Design
  8. If you want to change filter or view of different functions you can edit SQL.
  9. Edit / ADD Listbox Design
  10. In order to create or modify list box automatically attached to your form you need this.
  11. Create listbox by specifying link Table, Column from another table to this application table.
  12. DETFLAG is checked when you are specifying Listbox data for details table.
b. Edit Workflow Design
  1. If you want to change roles for users you can click on edit link.
  2. Six roles like Create/Edit/Delete, Approve, Onhold/Offhold, Print, Reject are predefined.
  3. You can add customized roles in the system also & can expand workflow of system.
c. Edit Database Design
  1. You can Add or Delete fields to Master or Details Table of your application database.
  2. You can also modify View of application Master or Details Tables of your application database.
  3. You can also modify business logic behind the application through Stored Procedures & Triggers.

d. Edit Report Design

  1. The Report Document that is automatically created by ERPWEB can be programmed using many tools mentioned in Report Manager section. The report can be in various formats depending on tools through which it was created. The reports can only be edited with specific tools through which it was created. e.g Report created using MS Excel can only be edited using MS Excel. You can only browser or execute data using ERPWEB and Internet Explorer browser.
  2. When you goto Edit mode in Application design you will see that in DADDRESS Field a report file name along with the format (*.asp, *.doc, *.xls, *.ppt, *.rpt etc..) is specified. No SQLs are stored. You can edit the file name associated with report. You can also modify user access rights for this reports.

METHODOLOGY 2: Semi-Automatically Designing an Application
A. Document Design Management
  1. This section helps you to manage functions, document, procedures & departments.
  2. Department or Modules can be added / edited or deleted using this option.
  3. Procedure or Submodules can be added /edited or deleted, which are linked to departments.
  4. Documents or Docmodules can be added / edited, which are linked to procedures.
  5. Functions can be added / edited or deleted, which are linked to Documents.
  6. Please modify linkages between above four options carefully as it will change menu of application.
B. Workflow Design Management
  1. This section helps you manage your workflow or user access rights design.
  2. You can create, edit or delete roles for each of the documents functions to users using this option.
  3. Please be careful as this will change workflow for your application.
C. Database Design Management
  1. This section helps you manage your database design. 
  2. You can view database Tables and can Add/Edit/Delete or view data from this Tables.
  3. You can view database Views/Query and can Add/Edit/Delete or view data from this Views.
  4. You can view database Stored procedures and can Add/Edit/Delete or execute this procedures.
  5. You can view database Triggers and can Add/Edit/Delete or test triggers.
  6. Remember this Tables, Views, Stored Procedures & Triggers are very well connected to applications.
  7. It is recommended to directly work with above mentioned application design managers to maintain integrity.
  8. Views, Triggers & Stored procedures contains business logic for applications.
  9. You can also access all this database management features when you login to Database manager from main menu.
  10. You can use 3rd party Database management Tools like MS SQL Server Enterprise Manager, Query Analyzer etc. to build or modify database design..

D. Report Design Management

  1. This section helps you manage your reports files & their access rights. 
  2. ERPWEB helps you to create a new report document linked to workflow, procedures & users.
  3. From Main menu login to Report Manager OR Report Manager in Application Manager.
  4. Click on New Report Design menu to enter new Report into ERPWEB.
  5. Click on Delete Report Design menu to delete old report from ERPWEB.
  6. ERPWEB provides standard report Programs. You need to provide Report Type & SQL Logic.
  7. You may use 3rd party Report Management Tools as mentioned in report manager to create complex reports. How to create reports using various tools are explained in Reports Manager. 

METHODOLOGY 3: Manually Designing an Application
You can use Microsoft Visual InterDev or Microsoft Visual Basic to design client end front end in asp or asp.net technology. You can use SQL Server 2000 Enterprise Manager to create Database Application. This approach is old, time consuming, costly and inefficient. You can use this approach if you require every document of application designed as per your specific customized design. But remember you should have high development budget, should allot large time & many people in programming such project.
ERPWEB provides best quality e-Business Infrastructure at lowest costs
This document last updated on 

© Copyright 2001 . All rights reserved. ERPWEB.COM is registered trademark of ASIC Infotech Pvt. Ltd. Home | Contact