EDI – What is it exactly?
EDI (Electronic Data Interchange) is a system that enables businesses to exchange data, like purchase orders and invoices, electronically and unattended by acting as a translator between different ERP systems. It converts files from various formats (e.g., XML, .csv) into a standardized EDI X12 format and transmits them using protocols like AS2, FTP, sFTP, or a VAN.… Read More
EDI – In-house or Outsource
That is the question A few years ago, I would have had a very different and completely one-sided answer to this question. I had always been a one woman show. I ran entire EDI departments by myself. I believed … Read More
Sage 500 TranKeys Solution
Problem: One of our clients uses Sage 500 as its ERP. One shortcoming we encountered when dealing directly with the data in the tables is that when tying sales orders to invoices, sales orders to shipments, invoices to shipments, etc … Read More
API versus EDI Explained
A few years ago, I read an article that said that by the year 2020, APIs would replace approximately twenty-five percent of EDI connections. The rest of the communications between businesses would continue to be handled through legacy technologies and … Read More
Broker Bin Integration Options
BrokerBin is the premier online marketplace for buying and selling IT equipment. They currently offer two ways to get your data on their site and in front of your existing customers and potential new customers. 1. Manually upload an excel … Read More
EDI acknowledgement Transactions: What’s the difference?
In the world of EDI, there is a document for just about every type of transaction you could imagine. While these transactions aren’t specific to a particular industry/business, these are the three I most run across that cause the client … Read More
QuickBooks, CommerceHub and UPS API case study
Integrating CommerceHub with QuickBooks and UPS to automate process flow One of our customers came to us with a convoluted, 42-step process to get orders from CommerceHub (CHub) into their ERP (QuickBooks) and at the same time, integrate UPS’ Shipping … Read More
EDI Communication Protocols
Navigating the world of EDI can be pretty daunting, especially with all the acronyms and document numbers used to identify nearly all actions in EDI. An important, and often overlooked, piece to EDI is communications. EDI can only work once … Read More
SSRS Excel outputs with more than 65,536 rows
For those of us that use the SSRS SOAP API to render reports (this is the endpoint that uses ReportExecution2005.asmx), just a quick heads up about a change that we were not aware of until recently. While developing a SSRS … Read More