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

• Learn and Master ERP software development with VB and SQL Server. (works on both 2005 and 2008 versions).
• 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.