Develop ERP Software using VB & SQL Server.

second cover image of erp book in and sql server

Book Contents >>

what is in it for you
  • Learn and Master ERP software development with VB and SQL Server.
  • ERP software development made easy.
  • Develop all the five modules of an ERP software - Finance, Sales and Marketing, Inventory, Purchase and Manufacturing.
  • Program an ERP software for the .Net platform.
  • Master creating the Finance module including Chart of accounts, creation of Customer accounts, Vendor accounts, Banks, Cash / Check Vouchers and Cash / Check Receipts.
  • Master creating the Sales module including Sales order creation, Picking sales orders for packing and shipping, creating sales invoice, tracking back orders.
  • Master creating the Purchase module including Purchase order, receiving materials and Purchase invoice.
  • Master creating the Inventory module including creation of items and issuing materials for completing Work orders.
  • Buy the book (includes source code) and get a ready ERP system.
  • Books include source code for each layer which you can extend and customize to meet your needs.
  • Build an ERP software which is multi-layered, with a database back-end in SQL Server.
  • The database portion of the ERP software is built as separate layer called Data layer which contains database, tables and stored procedures for the ERP system.
  • The business logics of the ERP software is built as separate layer called Business Layer which contains classes to implement business logics.
  • Component based design to enable independent use of each module.
  • The data access logic is implemented as separate layer called Data Access layer which is a generalized component and can be used for any other .net application.
how to design your desktop ERP application
  • The user interface of the ERP software is implemented as separate layer called Presentation layer which contains validations, code for programming the controls and calling code of the Business layer.
  • Master programming TreeView control - display multiple relationships between groups and accounts and Bill of materials.
  • Master programming DataGridView control - for accepting multiple items in Sales orders, Sales invoice, etc.
  • Master ERP software application architecture design.
  • Learn how to use Data Access layer component in the Business layer of the ERP software.
  • Learn how to use Business Layer component in the Presentation layer of the ERP software.
  • Create menus and sub menus programmatically for the ERP software.
  • Design and program the Bill of materials feature including table structures.
  • Accepting and handling raw materials, sub assemblies, finished products and consumables.
  • Understand the difference between logical vs physical layers.
  • Optimize business objects to implement multiple business processes in an organization.
  • Optimize data entry forms (windows forms) to implement multiple business processes in an organization.
  • Implement business rules in the Business layer.
  • Format and set the datagrid and bind the grid with the Dataset.
  • Retrieve, Traverse the dataset and fill the Listbox.
  • Steps to interact with the Data Access Layer.
  • Implement double entry rules in an ERP software.
  • Transaction management between Layers using TransactionScope object.
  • Add checkbox control in the datagrid to tick the packing and shipping sales orders.
  • Place items under different item types - Raw material, Finished product, Consumable or Sub assembly.
  • Retrieve components for a parent item in the Bill of materials product structure.
  • Create reports like Stock ledger, Cash book, General ledger, Trial balance, Income statement, Pending sales orders, back orders etc.
  • Update both finance and inventory tables from sales and purchase invoice transactions.