The Design And Implementation Of VAT Management System For Ford Automotive Finance(China)Ltd.

Ford Motor Finance(China)Co.,Ltd.has gradually established a strong and successful business foundation since it began its automotive finance business in China in 2005.At present,more than 290 Ford dealers in more than 180 cities in the country have established good personal phased business cooperation with Ford Motor Finance.At this stage,Ford Motor Finance has three specialized business systems with 22 reports to deal with the loan and installment business of dealers and individuals.Each report is differentiated for different business types,so that hundreds of trading rules will be formed.There are millions of business data per period.Therefore,it is necessary to create a VAT management system with high matching of business flow and data flow.Ford Motor Finance's VAT management system is based on the Hande MAS Web application development platform.It is an enterprise application product that uses the J2EE specification,three-tier architecture,and B/S mode.With J2EE specification,full advantage of security,powerful and platform-independent features about Java language can be taken,it is easy to choose products in the database and the middleware,and there are corresponding solutions from open source to large business products have.The system needs to provide a number of database tables such as transaction interface table,invoice header table,invoice line table,input invoice header table,input invoice line table,input certification draft and so on,and the large database SQL Server 2014 is selected to complete data storage and processing.The VAT management function proposes four modules,namely price and tax separation,input invoice management,sales invoice management,and tax declaration management.Price and tax separation has realized the functions of support for price and tax separation,manual price and tax separation,correction of transaction detail data,query of transaction detail data,and inquiry of price and tax separation.The specific businesses of input invoice management covers input invoice review,input invoice certification,input certification draft,input invoice entry,invoice cancellation deduction,payment without invoice data inquiry,matching failed invoice management,input tax transfer,and detailed inquiry of invoice.Sales invoice management includes functions of transaction flow invoicing(general ticket),transaction flow invoicing(special ticket),manual invoicing/review,invoice invalidation application/review,red word ticket application/review,red word general application/review,and invoice issuing inquiry.Tax declaration module has realized the functions of taxable provision,additional tax provision,and inquiry of tax return.The application of the system improves the management efficiency of Ford Motor Finance,while also ensuring the management process and the accuracy of billing data,and preventing the occurrence of VAT virtual invoicing.