Want to consult everybody friends, use PB development audit software, what method should be adopted to develop all kinds of financial data collection, collection into what kind of data format is the most convenient and imported into the essentially, main is to want to ask, how to do data collection, because the customer financial software, all kinds of background database is various, hope everybody can give me the development train of thought, thank you for your reply!

CodePudding user response:

As you say, the client software is varied, behind various database, you can't fit all, only a set of standard interface design, let the customer software vendors to your butt, such as medical insurance interface

CodePudding user response:

Done a year of audit software, you are the audit software, database access from others, let others butt you is impossible, only you financial software according to the customer database, write their own take data interface, into their own standard format,
Our front end access tool is five or six people in the maintenance, they don't understand the PB, but to understand the database, the database structure is familiar with finance software, take out the useful data, into the standard format of audit software, himself saved to excel file, then import the auditing system, we now seem to have eight hundred interface,
Do audit is very tired, because the operation EXCEL frequently, coupled with customer, various computer environment, various kinds of office version which is used plug-in, and so on, will always encounter all kinds of bugs,