Development Of Information System For Export Debt Receivables Of Huaxi ALU

The increasing of debt receivables, will make company face found cutoff andbank charge enlarge, which will influence continuous production, even the survival ofcompany. So when company carries out selling, company should pay more attention torisk of payment collecting, amount of debt receivables and reducing of debt account.That is to say, company should care seriously debt management of selling.Huaxi Alu. is a middle scale company, with main product of30000Mt Alu foilstock and10000Mt Alu foil. Its selling channel is in civil market and foreign market.Management of debt is also divided civil debt and export debt respectively. This articleis mainly relevant to management of export debt.As per courses and key time point, Debt management of exportation includespre-control, middle control and after-control. By establishment of information system,to manage the three courses and control the whole course of debt receivables. At thesame time, to control the selling finally by debt management.In this information system, information collection of customer in advance, creditrating in the affair and status of goods, letter and payment are particularly important.All the information is inseparable from the establishment of sales managementinformation system and management information collection. This system is alsonecessary for a company to carry out exportation.This article emphatically elaborated the Huaxi Alu. collections of export salesinformation management system performance history. Introduced the systemdevelopment environment as well as the development kit, have also made thecomprehensive narration regarding the design thought and the design flow, in databasefoundation between thought as well as each data sheet aspect and so on concreteconnection has also made the specify, and specifically analyzed the system eachfunction realization process as well as the detailed design process, during plan simplesystem function module chart, makes every effort clearly to indicate the design thought as well as to the entire programming plan and the concrete realization.The purpose is according to sales management has three problems, ie delay ofcollection, much debt and long account age, are analyzed and discussed, and finally findsolutions to problems, through the internal network, establish and make the export salesinformation management system to solution of the problem. Manage the contractsigning, order execution, delivery record collection and records the comprehensiveinformation query, early warning and authorized management. In the collection of themanagement system need to be perfected3categories of information database，i.e.:1、The customer information which is the foundation of customer informationand credit information.2、The business information which information and data enters sells saves.3、The financial information, mainly refers to the accounts receivable subsidiaryof all kinds of based on information and data.According to the actual demand, the collections of export sales informationmanagement system this project uses modular the design thought, in Windows under theXP operating system environment, Using VB+ACCESS database development，Enterprise management system for the collections of export sales, the main function ofdetriment, sales and storage.Including the administrator of enterprise information management product sales, theseller of merchandising management operations; the warehouse manager administrativeoperations of commodity stocks and so on.This system has the various characteristic: System function complete, easy tooperate simple and direct, the humanized contact surface, single user mode of operationto prevent viruses or other malicious changes to data, greatly reduced the operator anduser’s works.