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
benefits and prices of Developer Series of Bookstechnologies used to write erp books are .net, sql server and C#


Pack Offers

cover image of azure cloud book

Develop Azure Applications

Azure Cloud is gaining popularity and is competing with Amazon Elastic Cloud and Google Cloud for a spot in the billion dollar Cloud computing space.

With this book learn how to use - Table (an Azure Table is different from a SQL Server Table), Queue, Blob storage services, use your local machine to create an Application and a Service, how Azure splits a Table to achieve Load Balancing, Scalability based on the Partition Key, AppFabric Service Bus, Access Control Service, role of Fabric Controller, features of Azure SQL Database and Content Delivery Network.

Many have mastered Cloud Programming and are enjoying the benefits. Why not you?

View Highlights » View Contents »
cover image of foundation database programming book

Create your Own Accounting Software

A foundation book to Master Accounting Software Development, VB.Net, C# and OOPs programming. Detailed explanation of the Accounting domain for programmers is included. SQL and ADO.Net is also covered in detail.

This book gives you a strong foundation in Application Development.

A thorough understanding of the contents will enable you to grasp the topics covered in the accompanying books quite easily. This is because, the accounting domain is dealt with great detail in this book.

The ideal book to get started with application development in the .Net world.

View Highlights » View Contents »

cover image of book

Create your Own WEB ERP Software using ASP.Net

This book opens you to the Web. Using ASP.Net, C# and SQL Server as the tools, you will learn to build a Multi Tier Web Application as recommended by Microsoft. You will learn implementing inline GridView control, Transaction Management for a layered Web Application, build Data Access component and a Business Layer component.

Opens you to a world of opportunities. You will be able to develop a Web ERP application including all the five modules and learn how to use the TreeView control and GridView control to implement transactions such as Purchase Invoice, Sales Order and Sales Invoice.

View Highlights » View Contents »
cover image of entity framework book

ASP.Net MVC 5 Application Development Using Entity Framework 6 and VS 2015

Entity frameworks is the latest buzz in .Net programming and is the data access technology for Microsoft OS based hand held devices and web applications. Learn to integrate EF into an ASP.Net Application and MVC application. Create, explore and query the Entity Data Model. Learn how to use ObjectDataSource control and GridView control in an ASP.Net Application.

Also, learn to build Three-Tier ASP.Net application, create a business-class, implement methods in the class to perform CRUD operations and bind a GridView to the ObjectDataSource control. Learn how to handle concurrency and managing Transactions.

View Contents »