Develop ERP Software using VB.Net & SQL Server. (2008 & 2010)

second cover image of erp book in and sql server
ISBN: 81-901331-2-8
Weight: 1.6 Pounds
Pages: 277
Price: For Prices in US $ and INR, See Book Prices Page 


The objective of this book is to teach the secrets of developing an ERP software application. The techniques of developing an ERP software using Microsoft's Visual Basic.Net are taught based on the Layer approach.

Next Book Contents >>

Chapter : 1. Introduction.

  1. Introduction
  2. Technologies for ERP software
  3. Platform suited for creating ERP software
  4. ERP software overview
  5. ERP software implementation issues
  6. Resources required for implementing ERP software
  7. Benefits of ERP software
  8. SAAS and ERP
  9. Role of softwares in an ERP system
  10. ERP software and standardization of business processes
how to design your desktop ERP application

Chapter : 2. ERP Domain

  1. Working of the Finance department
  2. Business Processes in Finance department
    • Creating a Customer Account
    • Creating a Vendor Account
    • Creating a Bank Account
    • Creating a General Ledger Account
    • Enhancing Chart of Accounts
    • Receiving Check or Cash from Customers
    • Payments to Vendors by raising Checks or through Cash
    • Journal Entries
    • Instance of occurrence
    • Data to be recorded
    • Specimen document
  3. Working of the Sales department
    • Creating Sales Order
    • Pick and Pack Sales Orders
    • Pick Ship Orders
    • Create Sales Invoice
    • Instance of occurrence
    • Data to be recorded
    • Specimen document
  4. Working of the Purchase department
    • Purchase Order
    • Picking Purchase Orders
    • Purchase Invoice
    • Purchase Returns
    • Instance of occurrence
    • Data to be recorded
    • Specimen document
  5. Working of the Inventory department
    • Creation of items
    • Issues of items
    • Physical stock adjustment
    • Instance of occurrence
    • Data to be recorded
    • Specimen document
  6. Working of the Manufacturing department
    • Creating BOM (Bill of Materials)
    • Creating Work Orders
    • WIP receipts for recording completed work orders
    • Instance of occurrence
    • Data to be recorded
    • Specimen document

Chapter : 3. ERP Application Architecture

  1. Benefits of Multi-tier Architecture
  2. Purpose of Presentation Layer
  3. Purpose of Business Layer
  4. Purpose of Data Access Layer
  5. Purpose of Data Layer
  6. Logical vs. Physical Layers
  7. Creating ERP Application Framework
    • Creating a Class Library for the Data Access Layer
    • Creating a Class Library for the Business Layer
    • Creating a Windows Application for the Presentation Layer
  8. Developing Data Layer
    • Creating the Database
    • Creating the Tables
    • Writing Stored Procedures
  9. Developing Data Access Layer
    • Constructor of the DataServer class
    • DataServer Class Methods

Chapter : 4. Developing Finance Module

  1. Business processes in Finance Module
  2. Presentation Layer of Finance Module
  3. Accounts
    1. Designing and Programming AccountForm
      • Programming the AccountForm_Load() event
      • Retrieve Accounts into DataSet
      • Format and set the datagrid and bind the grid with DataSet
      • Retrieve, Traverse the dataset and fill the List box.
      • Programming the Add Button
      • Programming the Cancel Button
      • Programming the Save Button
      • Programming the Exit Button
      • Clear the data in the Account Form
      • Programming the Delete Button
    2. Creating Business Object - Account.vb
      • Retrieve Accounts from the database
      • Retrieve Groups
      • Save an Account
      • Delete an account
  4. Creating Menu and Sub-Menus
  5. Connecting AccountForm to the menu and using the AccountForm
  6. Chart of Accounts
    1. Designing and Programming GroupForm
      • Programming the GroupForm_Load() event
      • Populating the TreeView control with Chart of accounts
      • Retrieve, Traverse the dataset and fill the List box
      • Programming the Save button
      • Checking for duplication of Group name
    2. Creating Business Object- Group.vb
      • Calculate group internal reference
      • Return accounts based on the parentID
      • Return main groups
      • Returns only sub-groups under a particular group
      • Return true if group exists and false when group does not exists
      • Save the group details
  7. Transactions
  8. Designing and programming Journal Entry Transactions
    • Implementing validations to ensure double entry in Journal Voucher
    • Programming the Save button
  9. Designing and Programming Voucher/Receipts Transactions
  10. Creating business Object- Transaction.vb
    • Return information about Cash and Bank Accounts
    • Return Accounts based on menu selection
    • Transaction Management between layers

Chapter : 5. Developing Sales and Purchase Module

  1. Business processes in Sales Module
  2. Designing and Programming Order Form
    1. Retrieve Customer/Vendor Accounts into DataSet
    2. Retrieve Items and bind the Items Combobox control with the DataSet
    3. Perform Validations in Order Form
    4. Save Sales Order /Purchase orders
  3. Designing and Programming Invoice Form
    1. Programming Purchase Invoice
    2. Programming Sale Invoice
    3. Programming the Cash Sales
    4. Programming the Cash Purchase
    5. Programming Purchase Returns
    6. Programming the Sales Returns
  4. Business Objects - Trade
    1. Retrieve Customer/Vendor Accounts
    2. Retrieve Trade Accounts from the database
    3. Retrieve Discount, Freight and Tax Accounts
    4. Saving the Transaction details

Chapter : 6. Developing Inventory Module

  1. Business processes in Inventory Module
  2. Presentation Layer of Inventory Module
  3. Designing and programming the Item Form
    1. Retrieve Stock Groups from database
    2. Retrieve Item types
    3. Save the Item details
  4. Business Layer of Inventory Module
  5. Business Objects - Issue
    1. Return information about single Work order
    2. Saving Issue details

Chapter : 7. Developing the Manufacturing Module

  1. Business processes in Manufacturing Module
  2. Presentation Layer of Manufacturing Module
    1. Designing and Programming Bill of Materials form
    2. Designing and Programming Work Order form
    3. Designing and Programming Work-in-Progress Receipt form
  3. Business Layer of Manufacturing Module
  4. Business Objects - BOM
    1. Return information about all the Items
    2. Return parent Items
    3. Return components for a parent Item
    4. Save Product Structure
  5. Business Objects - WorkOrder
    1. Return items which have Bill of Materials
    2. Return Information about components
    3. Save Work Order details

Chapter : 8. Reports

  1. Trial Balance
  2. Cash Book
  3. Bank Book
  4. General Ledger
  5. Sales Register
  6. Sales Orders Pending report
  7. Purchase Register
  8. Purchase Orders Pending
  9. Stock Ledger
  10. Bill of Materials report
  11. Work Order Report
  12. Work-In-Progress Report
  13. Material Issue Report
  14. Master Item Report
  15. P & L Statement