The DataPull^™ application can be more loosely defined as a set of automated programs that enables data from external systems to be periodically imported into an organization's ERP system including Allscripts' (previously McKesson’s) Supply Chain and Financial Management applications, Flexi Financials, Paragon, Lawson, OmniBuyer and other applications. The DataPull family of products includes Data Converter, Importer, Invoice To SCM (specific to McKesson ERP Supply Chain Management), and Item Patient Pricing. The best part: each of these programs runs independently of one another and each promise to return double the investment in the first year!

General Benefits

• Designed to work across multiple application suites
• Automated process allows DataPull^™ jobs to be scheduled so clients can configure once and get back to business
• Protects investment in legacy applications that feed your ERP solution
• Primary and functional key validation prior to imports or updates
• Multiple error reporting options including writing to log files and SQL tables

DataConverter™

DataConverter allows users to set up and execute high-level data conversion plans using a point-and-click, drill-down interface to navigate through multiple servers. Pre-established plans for Allscripts' (previously McKesson's) family of ERP products are available and can greatly simplify Chart of Account conversions and more.

Benefits

• Simplified data conversion set up
• Performs “in-place” conversion, minimizing downtime and eliminating the need for secondary storage
• Pre-established plans allows administrators to leverage previous conversion efforts

Importer

The Importer simplifies importing large amounts of data from other systems into the Allscripts (previously McKesson) ERP Financial Management (AFM) application. Using flat files or database structures created by other systems, Importer validates and reports on the data as it imports and posts it to the general ledger. Importer reports are integrated with the standard AFM reports to create a seamless end user experience.

Benefits

• Uses simple data resources created by external disparate systems
• Performs detailed data verification, eliminating the issues around “half-imported” data sets and general ledger errors
• Processing reports appear in standard MFM sign-on window, eliminating the need for additional user training

Invoice to SCM

Invoice to SCM was built to provide an automated mechanism to integrate Non-Purchase Order invoices into McKesson's Materials Management database. The program solves a problem that has plagued many Allscripts and McKesson clients who utilize a 3rd party Accounts Payable scan and archive solution; how to load approved Non-PO invoices while validating the meta-data and updating all relevant database tables?

Benefits

• Uses simple flat file structure that can be easily created by most 3rd party AP scan systems
• Performs detailed data validation prior to updating any database tables to prevent orphan data records from being created
• Updates both primary and secondary tables without additional configuration

Item Patient Pricing

The Item Patient Pricing application is a powerful tool that can be used to update a client's charge data master (CDM) based on factors set by the client. Keeping the CDM clean and accurate is absolutely essential and DDR provides the means to do just that.