News - Home •
Excel import version of Jinshui interface

DATE:2016/5/30 17:41:47
Excel fast import data to the billing system for docking
General business to business more but has no financial system or distribution storage system, a lot of billing data information are only stored in Excel sheet, which can help enterprise to manage the data information, but in the face of a large number of invoice information when we need a invoice if manual to strip a copied to billing system, this is clearly very troublesome and waste of time! As the similar financial billing often encounter split / merge, 6 cents error and so on, if the traditional manual processing is obviously very troublesome and error prone, once an invoice opened after to work to increase more trouble will bring direct losses to the enterprise! In the information age we can with some auxiliary interface tool, so that we can improve the work efficiency also provides billing accuracy! Mingshuo information technology 10 years focused on the tax control interface, to help enterprises solve all financial problems!
"Mingshuo tax control interface, can help enterprises solve all the problems of the financial billing, also can help the enterprise to realize the comprehensive information management.
Schematic diagram of system flow
Functional characteristics:
Specific advantages of the scheme
(1) without additional hardware investment, enterprise ERP system will be with space anti fake tax controlled billing system to achieve seamless connection, ensure the consistency of the financial system and tax controlled billing information.
(2) without repeated input, reduce the work intensity of billing staff, simplify process, improve work efficiency.
(3) billing to billing data timely backfill to financial software, to achieve data sharing and interaction, the financial software sales documents and golden tax invoice are in one-to-one correspondence, provides an important source of data for the subsequent sales and financial reconciliation, verification and financial software statistics show.
(4) in the work of financial invoice document merging, resolution, discount treatment in solving realistic problems, change "brain judgment" for the computer automatic processing, operating trajectory tracking and operation process of "restoration" provides important information technology support.
(5) to facilitate the work at the same time, standardize the day-to-day business operations of the billing staff, really meet the enterprise high quality, low cost, high efficiency, automation, integration of the anti fake tax control invoice management requirements, the billing accuracy rate of 100%.
According to the enterprise information system, we design two schemes: the interface scheme of general database interface program and EXCEL file.
A general database interface version
The scheme for direct connection enterprise ERP database, sales records, and the sales records for merge, split, turning button operation after print out tax invoices, and invoice information automatic backfill to the ERP database.
Function introduction:
Document selection: documents and information in the ERP system, can realize the document number, date and other combination condition query
Modify the document: manual editing to modify the selected document information
Document merge: selective multiple documents issued with a copy of the invoice
Documents: the rate and split split over the invoice amount of documents, the normal documents or need to split
Invoice: return the invoice information (invoice code, invoice number) synchronization backfilled to ERP system
Invoice: according to the information query query invoice number, invoice number and other conditions of documents
Invalid invoice: the invoice has been cancelled
EXCEL or TXT file interface version two
The scheme does not need to be connected with the enterprise ERP system database, based on the ERP system is derived to excel or txt fixed format template file using the file import automatic billing.
Function introduction:
EXCEL template customization: according to the demands of the enterprises can import custom format
For the same commodity with the name and specifications of commodity automerge
Price type selection: the price in the import file types, including tax and non tax two.
Rate selection: customized products in the import file tax invoice are only a tax.
Automatically select: flexible choice of product details in the imported file is automatically select.
Invoice: according to the information query query invoice invoice code, invoice number and other conditions.
Modify the document: manual editing to modify the selected document information.
Document merge: selective multiple documents issued with a copy of the invoice.
Documents: the rate and split split over the invoice amount of documents, the normal documents or need to split.
Tencent video website: http://v.qq.com/page/j/r/7/j01793kkdr7.html (single open Tencent video network broadcast)










ABOUT
NEWS
CASES
PRODUCTS
DOWNLOAD
FOLLOW
SWEEP

 销售部  销售部  销售部  销售部  商务部  技术部
TOP
Scan the QR code

明硕金税接口

明硕金税接口