CN106779584A - Sales information in ERP is by the automatic method for sending client of mail batch - Google Patents
Sales information in ERP is by the automatic method for sending client of mail batch Download PDFInfo
- Publication number
- CN106779584A CN106779584A CN201611065496.6A CN201611065496A CN106779584A CN 106779584 A CN106779584 A CN 106779584A CN 201611065496 A CN201611065496 A CN 201611065496A CN 106779584 A CN106779584 A CN 106779584A
- Authority
- CN
- China
- Prior art keywords
- client
- data
- erp
- sales information
- Prior art date
- Legal status (The legal status is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the status listed.)
- Pending
Links
- 238000000034 method Methods 0.000 title claims abstract description 11
- 230000005540 biological transmission Effects 0.000 claims abstract description 6
- 230000004913 activation Effects 0.000 claims description 2
- 238000013480 data collection Methods 0.000 claims description 2
- 239000000284 extract Substances 0.000 claims description 2
- 238000004883 computer application Methods 0.000 abstract description 2
- 238000000605 extraction Methods 0.000 abstract description 2
- XEEYBQQBJWHFJM-UHFFFAOYSA-N Iron Chemical compound [Fe] XEEYBQQBJWHFJM-UHFFFAOYSA-N 0.000 description 6
- 229910000831 Steel Inorganic materials 0.000 description 4
- 238000007726 management method Methods 0.000 description 4
- 229910052742 iron Inorganic materials 0.000 description 3
- 239000010959 steel Substances 0.000 description 3
- 238000004519 manufacturing process Methods 0.000 description 2
- 230000002159 abnormal effect Effects 0.000 description 1
- 230000005611 electricity Effects 0.000 description 1
- 238000005516 engineering process Methods 0.000 description 1
- 238000012544 monitoring process Methods 0.000 description 1
- 238000012856 packing Methods 0.000 description 1
Classifications
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06Q—INFORMATION AND COMMUNICATION TECHNOLOGY [ICT] SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES; SYSTEMS OR METHODS SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES, NOT OTHERWISE PROVIDED FOR
- G06Q10/00—Administration; Management
- G06Q10/10—Office automation; Time management
- G06Q10/107—Computer-aided management of electronic mailing [e-mailing]
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06Q—INFORMATION AND COMMUNICATION TECHNOLOGY [ICT] SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES; SYSTEMS OR METHODS SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES, NOT OTHERWISE PROVIDED FOR
- G06Q50/00—Information and communication technology [ICT] specially adapted for implementation of business processes of specific business sectors, e.g. utilities or tourism
- G06Q50/04—Manufacturing
-
- Y—GENERAL TAGGING OF NEW TECHNOLOGICAL DEVELOPMENTS; GENERAL TAGGING OF CROSS-SECTIONAL TECHNOLOGIES SPANNING OVER SEVERAL SECTIONS OF THE IPC; TECHNICAL SUBJECTS COVERED BY FORMER USPC CROSS-REFERENCE ART COLLECTIONS [XRACs] AND DIGESTS
- Y02—TECHNOLOGIES OR APPLICATIONS FOR MITIGATION OR ADAPTATION AGAINST CLIMATE CHANGE
- Y02P—CLIMATE CHANGE MITIGATION TECHNOLOGIES IN THE PRODUCTION OR PROCESSING OF GOODS
- Y02P90/00—Enabling technologies with a potential contribution to greenhouse gas [GHG] emissions mitigation
- Y02P90/30—Computing systems specially adapted for manufacturing
Landscapes
- Engineering & Computer Science (AREA)
- Business, Economics & Management (AREA)
- Human Resources & Organizations (AREA)
- Strategic Management (AREA)
- Theoretical Computer Science (AREA)
- Physics & Mathematics (AREA)
- General Physics & Mathematics (AREA)
- Economics (AREA)
- Marketing (AREA)
- Entrepreneurship & Innovation (AREA)
- General Business, Economics & Management (AREA)
- Tourism & Hospitality (AREA)
- Operations Research (AREA)
- Quality & Reliability (AREA)
- Data Mining & Analysis (AREA)
- Computer Hardware Design (AREA)
- Manufacturing & Machinery (AREA)
- Health & Medical Sciences (AREA)
- General Health & Medical Sciences (AREA)
- Primary Health Care (AREA)
- Information Transfer Between Computers (AREA)
Abstract
Sales information in ERP is by the automatic method for sending client of mail batch, it is computer application field, it is to get around mail server mail according to user list configuration file to send rule, realizes that enterprises ERP sales informations are rapidly and efficiently sent to client by the data after reading, collection.The present invention realizes the timing extraction of ERP system data, the file of EXCEL forms is converted the data into again, corresponding file is sent to the mailbox of client with attachment version automatically by mail server, mail transmission program evades the security strategy of correlation, fire wall is avoided to intercept, and mail is sent once there is exception, system can immediately pass through SMS notification keeper, whole implementation procedure realizes full automatic treatment without manual intervention.
Description
Technical field
It is main to use ERP system customer sales information management present invention is mainly applied to computer application field.(ERP:Enterprise
Industry resource planning).
Background technology
Due to steel industry production capacity surplus, the production marketing of many iron and steel enterprises has met with very big predicament, such
Requirement of the client to products ＆ services has increase again under environment, therefore how to lift an important work of the service quality as sale
Make.
Many iron and steel enterprises develop the client that many scattered small lots are ordered goods, and these clients are highly desirable to simple and efficient
Obtain the contract signing between enterprise, revenue shipment, clearing, treasury trade and the testimonial information of product quality.How
Meet the demand of these small clients, improve customer satisfaction and new demand is proposed to information system.
Based on above reason, customer sales information is collected arrangement again by electricity in the existing ERP system of enterprise
Sub- lettergram mode is automatically transmitted to Client Mode to meet enterprise demand.
The content of the invention
In order to lift service quality, increase customer satisfaction degree, the present invention provides a kind of sales information by ERP and passes through postal
The method that part batch is automatically transmitted to client, BROAD SUMMARY is as follows：
（1）User's inventory is obtained from ERP to be saved in locally；
（2）User's contract signing is read according to user's inventory, revenue shipment is settled accounts, and it is entitled that funds data packing saves as file
The Excel file of ID；
（3）Mail packing program finds corresponding sales information data file and is sent to corresponding client according to user's inventory；
（4）Transmission program considers and solves the safety regulation of mailing system, prevents mail from can not correctly send or by as rubbish
Rubbish mail is fallen by other side's system mask；
（5）System journal monitoring function is realized, fault-tolerant and rapid abnormal warning function high is realized.
The present invention need not purchase new hardware and software platform in the enterprising line program exploitation of existing ERP platforms, with low
Cost, simple efficiently one integrated automatic customer information mail server of structure, are that business department realizes management innovation, are carried
Rise operating efficiency and provide a good management instrument, the information service of active is provided for small client, lift the satisfaction of client,
Customers to expanding Taiyuan Iron and Steel Co. product, increase the aspect such as occupation rate of market and lifting core competitiveness and serve positive role.
The present invention realizes the timing extraction of ERP system data, then converts the data into the file of EXCEL forms, passes through
Corresponding file is sent to mail server the mailbox of client with attachment version automatically, and mail transmission program evades correlation
Security strategy, it is to avoid fire wall is intercepted, and mail sends once appearance exception, system can immediately pass through SMS notification keeper,
Whole implementation procedure realizes full automatic treatment without manual intervention.
Specific embodiment
A kind of sales information by ERP is comprised the steps by the method that mail batch is automatically transmitted to client：
（1）Set up first in ERP with signing, revenue shipment is settled accounts, the sales information of treasury trade and electronic quality certificate
Table；
（2）The data pick-up function defined in ERP, extracts and arranges related data information from system automatically；
（3）Retell customer sales information data automatically generate client by the template file of standard can be for the Excel lattice begun the compilation of volume
Formula file；
（4）Judge whether with the record for not generating customer sales information data, if it is present generation customer sales information
Data；
（5）Client list is read in mail server circulation；
（6）According to client list information, the corresponding customer sales information data file of user is sent to client with attachment version
Mailbox, after being sent completely delete client list in customer information；
（7）If there is customer information in client list, and single linkup transmit mail number of times is no more than 15 times, then continue to send out
Send mail data；
（8）If whether also having customer information in client list, but single linkup transmit mail is more than 15 times, then again with mail
Server is retransmited after setting up connection；
（9）Judge whether client list is empty, be empty then EP (end of program)；
（10）If data is activation fails, system system error message can be issued management in the form of short message by SMS platform
Member.Facilitate keeper's very first time process problem；
（11）When there is new client to add, the client is marked, background program basis in next data collection periods
The mark automatically updates sales information.
Specific embodiment
Typing customer sales information table；
Read customer sales information table；
Whether sales data is inquired, if inquiring data, generate customer information inventory；If not inquiring data,
Then terminate；
Customer sales data are generated by Excel template；
Customer information is read from customer information inventory, if inquiring the sales information data of the client, by client's correspondence
Excel data be packaged as annex and carry out mail transmission；If not inquiring data, that is, terminate；
Mail sends successfully, deletes customer information, and client list is sky；
Mail sends there is exception, then SMS alarm notifies keeper.
Claims (2)
- The method that sales information in 1.ERP passes through the automatic transmission client of mail batch, it is characterized in thatMail server mail is got around according to user list configuration file and sends rule, realize that the data after reading, collection are quickly high Enterprises ERP sales informations are sent to client by effect.
- 2. the method that sales information according to claim 1 in ERP passes through the automatic transmission client of mail batch, including it is following Step：（1）Set up first in ERP with signing, revenue shipment is settled accounts, the sales information of treasury trade and electronic quality certificate Table；（2）The data pick-up function defined in ERP, extracts and arranges related data information from system automatically；（3）Retell customer sales information data automatically generate client by the template file of standard can be for the Excel lattice begun the compilation of volume Formula file；（4）Judge whether with the record for not generating customer sales information data, if it is present generation customer sales information Data；（5）Client list is read in mail server circulation；（6）According to client list information, the corresponding customer sales information data file of user is sent to client with attachment version Mailbox, after being sent completely delete client list in customer information；（7）If there is customer information in client list, and single linkup transmit mail number of times is no more than 15 times, then continue to send out Send mail data；（8）If whether also having customer information in client list, but single linkup transmit mail is more than 15 times, then again with mail Server is retransmited after setting up connection；（9）Judge whether client list is empty, be empty then EP (end of program)；（10）If data is activation fails, system system error message can be issued management in the form of short message by SMS platform Member,Facilitate keeper's very first time process problem；（11）When there is new client to add, the client is marked, background program basis in next data collection periods The mark automatically updates sales information.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201611065496.6A CN106779584A (en) | 2016-11-28 | 2016-11-28 | Sales information in ERP is by the automatic method for sending client of mail batch |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201611065496.6A CN106779584A (en) | 2016-11-28 | 2016-11-28 | Sales information in ERP is by the automatic method for sending client of mail batch |
Publications (1)
| Publication Number | Publication Date |
|---|---|
| CN106779584A true CN106779584A (en) | 2017-05-31 |
Family
ID=58902128
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201611065496.6A Pending CN106779584A (en) | 2016-11-28 | 2016-11-28 | Sales information in ERP is by the automatic method for sending client of mail batch |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN106779584A (en) |
Cited By (4)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN109039870A (en) * | 2018-08-20 | 2018-12-18 | 平安科技（深圳）有限公司 | E-mail sending method, system, computer equipment and storage medium |
| CN110297805A (en) * | 2019-05-24 | 2019-10-01 | 平安科技（深圳）有限公司 | Supervise case processing method, device, computer equipment and storage medium |
| CN110458258A (en) * | 2019-07-26 | 2019-11-15 | 重庆伟鼎电子科技有限公司 | The retrospect of information automation quality and rejected product management method |
| CN112448882A (en) * | 2019-09-05 | 2021-03-05 | 北京国双科技有限公司 | Mail service method and device for enterprise-level platform |
Citations (2)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN103391242A (en) * | 2013-07-17 | 2013-11-13 | 湖南智源信息网络技术开发有限公司 | Table data transmission method |
| CN103500396A (en) * | 2013-09-18 | 2014-01-08 | 北京思特奇信息技术股份有限公司 | Method and system for automatically generating files and sending mails |
-
2016
- 2016-11-28 CN CN201611065496.6A patent/CN106779584A/en active Pending
Patent Citations (2)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN103391242A (en) * | 2013-07-17 | 2013-11-13 | 湖南智源信息网络技术开发有限公司 | Table data transmission method |
| CN103500396A (en) * | 2013-09-18 | 2014-01-08 | 北京思特奇信息技术股份有限公司 | Method and system for automatically generating files and sending mails |
Non-Patent Citations (1)
| Title |
|---|
| 无: "EasySQLMAIL使用任务-使用任务向导快速创建数据发布", 《HTTP://WWW.EASYSQLMAIL.COM/DOCREADER.HTML?ID=264》 * |
Cited By (6)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN109039870A (en) * | 2018-08-20 | 2018-12-18 | 平安科技（深圳）有限公司 | E-mail sending method, system, computer equipment and storage medium |
| CN110297805A (en) * | 2019-05-24 | 2019-10-01 | 平安科技（深圳）有限公司 | Supervise case processing method, device, computer equipment and storage medium |
| CN110297805B (en) * | 2019-05-24 | 2023-06-20 | 平安科技（深圳）有限公司 | Supervision case processing method and device, computer equipment and storage medium |
| CN110458258A (en) * | 2019-07-26 | 2019-11-15 | 重庆伟鼎电子科技有限公司 | The retrospect of information automation quality and rejected product management method |
| CN112448882A (en) * | 2019-09-05 | 2021-03-05 | 北京国双科技有限公司 | Mail service method and device for enterprise-level platform |
| CN112448882B (en) * | 2019-09-05 | 2022-07-29 | 北京国双科技有限公司 | Mail service method and device for enterprise-level platform |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN106779584A (en) | Sales information in ERP is by the automatic method for sending client of mail batch | |
| CN101957927B (en) | Middleware architecture of Internet of things and SOA architecture-based middleware of Internet of things | |
| CN108665330B (en) | Method and device for monitoring order in service link | |
| KR20170099078A (en) | Management Estimating Platform System Based on Big Data Using Manufacturing Facilities-Related Information from MES | |
| CN106406826B (en) | Joint debugging task creation method, system joint debugging method and device | |
| CN103685533A (en) | Data sharing system and method among enterprises based on cloud service | |
| JP6219924B2 (en) | Track item status | |
| CN111325613B (en) | Interaction method, system, equipment and storage medium for realizing electronic face sheets | |
| CN109447472A (en) | Performance task data processing method, device, computer equipment and storage medium | |
| US20130110722A1 (en) | System and Method For Identity Chaining | |
| CN104318472A (en) | Online transaction monitoring method and system | |
| CN109951375B (en) | Method and system for triggering service function of SAP system based on mail system | |
| CN107194665A (en) | A kind of minimized office ERP system | |
| US20190057349A1 (en) | Drop shipping system | |
| CN111125785A (en) | Account checking method based on block chain, account checking device and readable storage medium | |
| JP2020509516A (en) | Method and associated device for obtaining logistics document information | |
| CN110708232A (en) | Method and system for realizing JIRA message real-time notification | |
| CN108156256B (en) | Message real-time pushing method and system based on cloud server group | |
| CN109300007A (en) | A kind of e-commerce operation system | |
| CN107742179A (en) | User reminding method, apparatus, storage medium and computer equipment in ERP system | |
| CN107481103A (en) | E-commerce order management system | |
| WO2013166764A1 (en) | Structure and method for remote sales platform | |
| CN101145912A (en) | An electronic order secure transmission method based on ebMS | |
| WO2017012427A1 (en) | Method for managing merchant by means of merchant shopping list printer and shopping list printer | |
| US20050080644A1 (en) | Self-describing business document collaboration protocols |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| PB01 | Publication | ||
| PB01 | Publication | ||
| SE01 | Entry into force of request for substantive examination | ||
| SE01 | Entry into force of request for substantive examination | ||
| RJ01 | Rejection of invention patent application after publication | ||
| RJ01 | Rejection of invention patent application after publication |
Application publication date: 20170531 |