Develop ERP Software using VB & SQL Server.

Book Contents >>

- 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.

- 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.