Looking for breakthrough ideas for innovation challenges? Try Patsnap Eureka!

A method for exchanging erp data and excel document data

A technology of data exchange and excel, which is applied in the computer field, can solve the problems of inconvenient quality management department inspection and audit final inspection report filing operation, etc., and achieve the effect of easy promotion, high data exchange efficiency and wide application range

Active Publication Date: 2019-07-05
INSPUR COMMON SOFTWARE
View PDF4 Cites 0 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

Due to the wide variety of records that need to be recorded in the research and development of new drugs, and they are scattered, such a large number of forms is inconvenient for the inspection and audit of the quality management department and the filing of the final inspection report

Method used

the structure of the environmentally friendly knitted fabric provided by the present invention; figure 2 Flow chart of the yarn wrapping machine for environmentally friendly knitted fabrics and storage devices; image 3 Is the parameter map of the yarn covering machine
View more

Image

Smart Image Click on the blue labels to locate them in the text.
Viewing Examples
Smart Image
  • A method for exchanging erp data and excel document data
  • A method for exchanging erp data and excel document data

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0017] The present invention will be further described below in conjunction with specific examples.

[0018] A kind of method of ERP data of the present invention and Excel document data exchange, its specific implementation process is:

[0019] First, you need to define the data source of the current table area;

[0020] According to the above data source, define the configuration table of the system table area, which is used to identify the table including the area number, name information and its corresponding data source;

[0021] Select an existing EXCEL document form template in the system, and use the online editing function of the OFFICE document editor to manually set identifiable system record information for different positions of the EXCEL document form in the system, save the form and location information for future use, and jump after saving Mapping function to system table area and EXCEL table area;

[0022] Complete the mapping between the system table area a...

the structure of the environmentally friendly knitted fabric provided by the present invention; figure 2 Flow chart of the yarn wrapping machine for environmentally friendly knitted fabrics and storage devices; image 3 Is the parameter map of the yarn covering machine
Login to View More

PUM

No PUM Login to View More

Abstract

The invention discloses a method for exchanging ERP data and Excel document data. The specific implementation process is as follows: first, define the data source of the current table area; define the configuration table of the system table area according to the above data source; select the existing EXCEL document form template, use the online editing function of the OFFICE document editor to manually set identifiable system record information for different positions of the EXCEL document form in the system, save the form and location information for future use, and jump to the system form area after saving. Same as EXCEL Table area mapping function; complete the mapping between the system table area and the EXCEL table area; finally set the ERP document. Compared with the prior art, the method for exchanging ERP data and Excel document data of the present invention has the characteristics of high data exchange efficiency, strong reliability, etc., strong practicability, wide application range, and easy popularization.

Description

technical field [0001] The invention relates to the technical field of computers, in particular to a method for exchanging ERP data and Excel document data. Background technique [0002] The quality management of new drug research and development is the foundation of the entire drug quality system, and its level determines the final drug quality. Good document and record management is the basic element of R&D quality management and the basic element of drug quality system, which can ensure the orderly and standardized development of drug R&D. The documents in the new drug research and development stage include the systems, procedures, standards, operating procedures involved in the drug research and development process, and the records, reports, and maps generated during the process. The effective operation of a research and development laboratory (institution or department) should be both soft and hard. While improving the laboratory facilities, equipment hardware level an...

Claims

the structure of the environmentally friendly knitted fabric provided by the present invention; figure 2 Flow chart of the yarn wrapping machine for environmentally friendly knitted fabrics and storage devices; image 3 Is the parameter map of the yarn covering machine
Login to View More

Application Information

Patent Timeline
no application Login to View More
Patent Type & Authority Patents(China)
IPC IPC(8): G06F16/00
CPCG06F16/93
Inventor 车向明张国升
Owner INSPUR COMMON SOFTWARE
Who we serve
  • R&D Engineer
  • R&D Manager
  • IP Professional
Why Patsnap Eureka
  • Industry Leading Data Capabilities
  • Powerful AI technology
  • Patent DNA Extraction
Social media
Patsnap Eureka Blog
Learn More
PatSnap group products

Browse by: Latest US Patents, China's latest patents, Technical Efficacy Thesaurus, Application Domain, Technology Topic, Popular Technical Reports.

© 2024 PatSnap. All rights reserved.Legal|Privacy policy|Modern Slavery Act Transparency Statement|Sitemap|About US| Contact US: help@patsnap.com