Integration
No piece of software can do everything, so being able and, as importantly, being willing to integrate with other systems is essential for our customers. The most fundamental piece of software used in business is Excel. Our Data Export function will create native Excel spreadsheets quickly and easily.
We have years of experience interfacing with not only Electronic Data Interchange (EDI) but also ISO 9001 repositories, paging terminals, robotic devices, and various other systems. Some of these use industry-standard REST APIs and SQL tables, while others use proprietary interfaces. Does your company have an integration need that your current software does not address?
_Sm.jpg "shutterstock_2242292891 (1)_Sm")
"It was my pleasure to work with the team at Info-Power/ABW. We have worked on a few projects, all related to MSSQL migration and data integrations, along with some custom MSSRS reports. Working with their team was an easy process; they were knowledgeable and great to work with, and allowed me to provide the solutions my customers needed. I wouldn’t hesitate to utilize their services again in the future."
Data Export to Excel
Empower yourself by eliminating the wait for a programmer to generate a report. The moment your SQL query is finalized, you can seamlessly pull the data into Excel. With your data in Excel, unleash the power of Pivot Tables for dynamic subtotaling and create compelling Bar Graphs or Pie Charts to visualize your insights with clarity and precision.
-
Simple Query Generates Excel Spreadsheet
-
Can be User-Defined and Modified
-
Our Query Builder is Available to Lead You Through the Definition Process
-
Security By User to Control Access
-
Simple Input Parameter Screens
-
Powerful SQL-Based Retrieval
-
Allows Quick Turnaround for Ad Hoc Reporting
-
SQL Functions such as Sum, Count, Average, Min and Max
-
Output from Complex Stored Procedures can be Used
-
Retains Usage Records by User and by Query with Parameter Inputs
-
Data is Exported in Native Excel Format for Use With All Excel Functions
EDI-SPS Commerce
We have used SPS Commerce for high-volume transactions. We provide specialized support for your and your trading partners' requirements. ABW transactions consume and generate commonly used X12 Transactions. If you have any additional requirements, we will be happy to work with you to address them.
-
810 - Invoices
-
850 - Orders
-
855 - Acknowledgments
-
856 - Ship Notifications
IMSXpress - ISO 9001
IMSXpress is a Microsoft SQL Server-based ISO-9001 repository with which we closely integrate. Its use of MSSQL made it possible for us to link its tables to ABW screens and views, and join them with your data to provide combined data for your users. It is an extension of our Document Management system.
-
Master Drawings
-
Change Control Notices
-
Procedural Instructions
-
Automated Rev Level Tracking
-
Purchase Order Version History
-
Work Order Release Version
-
Lot Tracking History
ABW comes with the capability to attach to the following business records and can easily be expanded.
-
Inventory Items
-
Bill of Materials
-
Shop Floor Routings
-
Quotes
-
Sales Orders
-
Shippers
-
Invoices
-
Work Orders
-
Inventory Lots
-
Purchase Orders
-
Vendor Invoices
Document Management
ABW enables the attachment of all types of documents to specific business records. Virtually any type of document that has a browser-based display mechanism can be used. Commonly used documents are:
-
Text Files
-
Microsoft Word
-
PDF
-
JPG
-
PNG
-
AutoCAD
-
Solidworks