Analysis of business logic design and implementation of large. NET ERP System

According to the experience of manufacturing software development in recent years, the author gives a brief description of how the function (Feature) is designed and implemented in view of the understanding of the developer, for reference.

Depending on the architecture, the technical implementation will vary, and my experience is limited to the Windows Form program.

Overall functionality

1 The system supports multiple users.

Create a single-instance (Singleton) Session Manager SessionManager, when deployed on the server side with. NET remoting, to save the logged-in user session with a DataTable (Session:login Id,user Id,name, Login time). When the client logs in, it checks if there is a record in the DataTable and indicates that it is logged in. When the ERP client exits, the. NET remting Server-Side Delete session information (DataTable) is notified.

2 Systems support multiple companies.

Design a set of books, the database definition of the list of books is relatively simple, refer to the following company table definition.

CREATE TABLE[dbo]. [Company] ([Companycode] [nvarchar] (10)COLLATESQL_Latin1_General_CP1_CI_AS not NULL, [CompanyName] [nvarchar] (50)COLLATESQL_Latin1_General_CP1_CI_AS not NULL, [Suspended] [nvarchar] (1)COLLATESQL_Latin1_General_CP1_CI_ASNULL, [databaseserver] [nvarchar] (20)COLLATESQL_Latin1_General_CP1_CI_ASNULL, [DatabaseName] [nvarchar] (20)COLLATESQL_Latin1_General_CP1_CI_ASNULL, [databaselogin] [nvarchar] (20)COLLATESQL_Latin1_General_CP1_CI_ASNULL, [databasepassword] [nvarchar] (20)COLLATESQL_Latin1_General_CP1_CI_ASNULL,) on[PRIMARY]GOALTER TABLE[dbo]. [Company]ADD CONSTRAINT[Pk_company]PRIMARY KEY CLUSTERED([Companycode]) on[PRIMARY]GO

The billing table records the connection information for the database, and also records the industry information for the set of books to facilitate system-specific functions only for the set of accounts.

3 system supports multi-inventory organization.

Inventory organization is used to track inventory transactions, maintain inventory balances, you can establish multiple inventory organizations, each inventory organization has a book set, record items in and out of transactions.

Inventory organization is established under the operating unit, can be subdivided into different sub-warehouses.

4 system supports multi-currency.

There is a standard currency setting in the system's set of account parameters, there is no specified currency in the business document, the base currency is the accounting currency, and the value of the currency field in the business document is the value of the money fields set in the document as the accounting basis. In business documents, amount and amountlocal are generally used to record the value of the amount calculated in two currencies, and the exchange rate is based on the currency of the current business document and the exchange rate of the standard currency.

Multiple currencies need to consider the different currency conversions between documents. For example, the purchase order with HKD HKD will be paid with USD $ at the time of payment.

5 system support on-line approval.

With. NET WF as the workflow engine, you need custom activities (approval, routing messages, sending reports), Defining workflow types (batch, journal modification, scheduled Tasks), defining workflow Services, setting up a database to resolve workflow database persistence.

6 System support batch and serial number management.

Batch numbers and serial numbers are features that are added to address specific industry segments. such as pharmaceuticals, food, to track the validity of each batch of products. Serial number management for electronic products, for after-sales service.

Sales Module

7 system support taxes, deposits, discounts, other fees.

Taxes and discounts change the calculation formula for the unit price and the amount, and the deposit will affect the receivable, which is equivalent to the pre-payment of a certain contract margin. Other expenses, such as delivery costs, will affect the total amount of the sales order.

Sales Order Total Amount = Total Item amount + Add Item (delivery, packing fee, profit margin)-Deduction (Discount)

The 8 system supports multiple deliveries.

Sales of goods issued to generate general ledger vouchers, vouchers accounting as follows:

Borrowing: Accounts receivable $5,000

Loan: Sales $5,000

9 The system supports quote-to-sales orders.

When a quote is issued to a customer quotation, the customer accepts it, the sales order is generated directly from the quote, the relevant currency payment terms, and the item details are taken out of the sales order.

10 The system supports sales orders to generate purchase orders or work orders.

For trading companies, only the purchase and sale of materials, not the actual production, can be directly generated by the sales order of delivery orders, the inventory of less-than-stock sales orders directly to produce the PO. For production-oriented enterprises, such as sales of 1000 computers, by sales order 1000 computers, directly produce 1000 computer work order (production task order job Order/work Order), and then issue the material, do the finished goods receipt.

11 The system supports the sale of packaging, supporting a variety of packaging specifications.

The main solution is the allocation of packing quantity and label printing. Sales Order item sales a sells 100 quantity units, 8 quantity units per carton, and a total of 9 boxes after calculation. The four sides of the box need to print some labels, the values are customized by the user, and can take some sales order and item values to the label.

Procurement module

12 system supports vendor price and batch maintenance.

Maintain a supplier material price list, the supplier each time the supply price records can be traced, so that the next time to enter the purchase order, directly bring out the last purchase order in the same batch price. Batch management is available for different purchase batches, with discounted or discounted prices.

13 System support taxes, deposits, discounts, other fees.

Same as the sales module, taxes, deposits, discounts, other charges will affect the total amount of the order. For example, buying items from abroad requires a support premium.

13 System support purchase inspection, support MIL-105E inspection standard.

IQC is used to inspect suppliers for incoming goods and to track supplier quality. AQL is the international standard of inspection, the system supports spot inspection.

14 system support automatically generates purchase orders from MRP.

MRP-generated material requirements have two methods of processing: the procurement of raw materials for attributes, the production of purchase orders, manufacturing of semi-finished products are issued as production task orders.

Warehouse Module

15 System supports material reservation (sales order, work order).

Material reservation (Reserved) is suitable for such a scenario, for sales or production of more important customers or delivery of very strict orders, must have sufficient materials to carry out production or delivery of goods in a timely manner, so that in the case of insufficient warehouse material, this part must be in advance to be shipped by the invoice or production order material required to retain ( On-hold), which is not allowed or otherwise, is equivalent to deducting the available stock, but the actual inventory has not changed.

16 system supports standard and actual costs, real cost support FIFO, average cost.

FIFO (advanced first Out) is applicable to food and drug and other related to the shelf life of the industry.

Production and Manufacturing module

The 17 system supports a large number of engineering changes.

The two main elements of a BOM are the item list and the Operation standard. A large number of engineering changes support the bulk modification of the BOM, such as adding a new item to a set of BOMs or, as a result of a process improvement, a process that can be cut from the BOM.

The 18 system supports the Master Production plan (MPS) and the material Requirements Planning (MRP).

MRP and MPs program are different, the calculation method is consistent, the former object is the finished product, the latter is the raw material.

19 Planned orders generated by the MRP can still be modified before the order is released.

By MRP calculation Tracking material lead time, plan receipts and on-hand inventory, material class code and other information to calculate the material requirements, from the material requirements into planned orders, the planned order is issued as a purchase order or work order, can still modify the parameters to meet the actual needs.

20 The system supports material loss, consumption, return and divergence material.

PMC controls the need and use of materials, and some deviations occur during the production process. Material loss, consumption, and return are suitable for handling anomalies in the production process. For example, from the work order to produce the material requirements, after the workshop due to improper operation or other reasons, the need to re-send material, then take the divergent material (Spare Issue) way to deal with.

21 The system supports outward processing.

Outward processing is divided into process outsourcing and raw materials outside the hair. Outward processing involves cost-related accounting, similar to the nature of the procurement business, equivalent to the purchase of production services. Some ERP systems directly use purchase orders as documents for outward processing orders, and then add a small number of features.

General Ledger module

22 The system supports batch posting of vouchers delivered by the business module, tightly integrated with invoicing, warehousing and manufacturing modules.

The capital flow in the process of production and operation of an enterprise, the realization method is to generate general ledger voucher from each business module. For example, a work order item issue produces the following accounting:

Borrowing: in the work $2,000

Credit: Warehouse $2,000

Again, such as sales returns, resulting in the following accounting vouchers:

Loan: Sales return

Credit: Accounts receivable

23 system support period voucher.

For some of the daily business of the regular operating expenses, such as rent, fixed assets depreciation, these can be made to periodical vouchers, monthly processing month at the end of the system by the automatic production of accounting vouchers.

24 System support account adjustment.

The General ledger module contains three sets of accounts, accounting vouchers (Voucher) are the original basis for accounting (as opposed to the ERP system, the original basis is billing vouchers, payment vouchers and transfer vouchers), according to the billing voucher to generate a running account (Journal), General Ledger (Ledger), Currency Ledger (Currency ledger). Because the following three data is based on the accounting voucher, the account adjustment is to generate a new account adjustment voucher, after posting the updated three accounts.

Analysis of business logic design and implementation of large. NET ERP System