Last week I had a review of our mapping process with our lead data mapper. Ken is a man of over 20 years experience in the EDI and data mapping world. He has contributed to international EDI standards and even written a standard for the Paper industry. He knows what he is talking about. He is also a strange being who delights in the minutiae of data mapping and he enjoys nothing better than solving the problems inherent in getting one computer system to talk to another.
We were looking, as we do on a regular basis, at how we could improve the mapping process, automate more and therefore offer a better service for our customers, which of course leads to better profit. One thing we homed in on was the number of different mappings we have created for our customers and their partners.
Having looked at that number, we then looked at the number of standards available that users either are or could use. The numbers are staggering. In EDI in the UK and Europe we mainly see Tradacoms and EDIFACT. Of course there are various versions of each and in particular with EDIFACT one persons EDIFACT D96a order is not the same as another persons.
We then looked at XML, once touted as the great hope for simplifying EDI. Over 500 standards, and a lot of the standards are varied by the end user.
We then looked at ways we send and receive messages, 10 basic methods (AS2, EDI VAN, FTP, email etc) and most FTPs have slightly different requirements (e.g. do we delete the file when download or archive it) and HTTPS is different for each user we implement for.
Now we actually enjoy all this variety but we then thought about users, not our users, but users that were trying to implement EDI themselves. Don't get me wrong, we do not do anything our users could not do for themselves BUT the question is at what cost. Given the variety of message standards and comms methods around your average customer that either buys or supplies goods to and from various parties will need at least one, more likely two specialist to handle any significant EDI initiative.
If they have an IT department the skills may be present but here's the question. If you business is buying, selling, manufacturing or distributing widgets do you want your IT team spending their time trying to integrate with one of your trading partners or do you want them to concentrate on adding value to your core business activities? Integrated EDI will add to your bottom line, but not if it is diverting you and your team from your main business.
This is where the value of outsourced EDI can be found. Firstly does EDI make sense for your business. We do a simple activity based costing exercise with some of our customers to identify when EDI will add to their bottom line. Once this is done we can then look at the costs of "Do it yourself" against outsourced EDI. For any significant EDI program, outsourcing wins easily.
A friend of mine in the pub on Friday asked me why I don't do DIY at home. My answer was simple, I know what I am good at, and DIY isn't one of those things. When I did try DIY in the past I would find I would have to buy tools and materials, most of which I would never use again and then I would have to pay someone else to correct what I have done anyway, so there is no saving. The same should apply in business, do what you are good at, and leave the nasty world of EDI to someone that enjoys it, it will save you money.
Showing posts with label SaaS. Show all posts
Showing posts with label SaaS. Show all posts
Sunday, March 16, 2008
Wednesday, February 13, 2008
How hard can it be to integrate two systems?
Earlier this week I was working with a particular mapping for a client. They required to send invoices to one of their customers and we were already processing the same invoices for this client from a different (Older) system. The idea was that the client was migrating from their old system to the brand new shiny system.
Not a problem one might think, as a newer system should have better abilities to trade electronically than a system well over 10 years old. We live in the modern, integrated world.
Well it turned out not to be quite that simple. First we had an email to our mapping project system to say that the new system could not produce a particular piece of data, rather it provided a piece of data that was incorrect. We found a work around for this using our facility to treat message data as look-up data and so we were able to agree how we could process the data and produce the correct information for the recipient. All a standard part of the service.
We had the software vendors file specification and we had sample data so, on we go. Then we stopped. A quick check by the mapping engine highlighted that the sample file did not match the specification. Close but no cigar.
So we requested, and were sent, two files contains not one but two specifications. We were also sent two sample files. So we now have a quandary. If we choose, we have a 50% chance of getting the wrong specification. No problem, quick chat with the client and they point to the latest specification. Couple of hours later and we have a mapping of the input data, a mapping of the output data and we can test to make sure that the documents match business rules, add up etc.
Guess what, they don't. Well if everything worked first time there would be no need for testing. We changed some of the mapping, checked the arithmetic of the data and it just did not make sense, did not have tax totals and so was basically totally invalid.
After further discussion with the customer we find the root cause of the problem. You will remember we received two specifications and two sample files. It turns out that one of the sample files, sent by the software house, had nothing to do with the final specification and between us we had contrived to choose the wrong sample. Such is Sods Law.
This is the work of data mappers, and this is not a whinge about wrong specification etc. The work of data mapping involves detailed data analysis. Yes we at least have tools that speed that process up significantly but never the less it is detailed work and we love it. After completing the mapping, in less than 8 hours including dodgy files and specification, we had a laugh with the customer, a promise of a pint owed and a happy customer.
But here's the thing. Without the tools that we have built the data analysis and mapping process would take days, in fact we have heard competitors quote large sums of money for such work, if they do not already know the file standard, and I can understand why. Some people believe there cannot be much to sending a file of invoices from one company to another, but the devil is in the detail and that is why EDI or EIPP is becoming more and more a Software as a Service arena. Without the specialist skills and tools it is the Total Cost of Ownership of EDI or EIPP, the costs of skilled data analysts, mapping tools, testing teams and support, that more and more Financial Directors are saying is too expensive to do in house. The sending and receiving of physical files is easy, but the set-up of the variety of communication processes is not. What a lot of companies are now saying is get somebody else to cope with the messy bit, we just want to send and receive one file format and use one communications method.
After all, if you distribute building materials do you want to spend your money on making the distribution more efficient and selling more OR staffing up the IT team to have data analysts, EDI experts, XML experts, communications experts, oh and have them also run you IT systems as well?
Not a problem one might think, as a newer system should have better abilities to trade electronically than a system well over 10 years old. We live in the modern, integrated world.
Well it turned out not to be quite that simple. First we had an email to our mapping project system to say that the new system could not produce a particular piece of data, rather it provided a piece of data that was incorrect. We found a work around for this using our facility to treat message data as look-up data and so we were able to agree how we could process the data and produce the correct information for the recipient. All a standard part of the service.
We had the software vendors file specification and we had sample data so, on we go. Then we stopped. A quick check by the mapping engine highlighted that the sample file did not match the specification. Close but no cigar.
So we requested, and were sent, two files contains not one but two specifications. We were also sent two sample files. So we now have a quandary. If we choose, we have a 50% chance of getting the wrong specification. No problem, quick chat with the client and they point to the latest specification. Couple of hours later and we have a mapping of the input data, a mapping of the output data and we can test to make sure that the documents match business rules, add up etc.
Guess what, they don't. Well if everything worked first time there would be no need for testing. We changed some of the mapping, checked the arithmetic of the data and it just did not make sense, did not have tax totals and so was basically totally invalid.
After further discussion with the customer we find the root cause of the problem. You will remember we received two specifications and two sample files. It turns out that one of the sample files, sent by the software house, had nothing to do with the final specification and between us we had contrived to choose the wrong sample. Such is Sods Law.
This is the work of data mappers, and this is not a whinge about wrong specification etc. The work of data mapping involves detailed data analysis. Yes we at least have tools that speed that process up significantly but never the less it is detailed work and we love it. After completing the mapping, in less than 8 hours including dodgy files and specification, we had a laugh with the customer, a promise of a pint owed and a happy customer.
But here's the thing. Without the tools that we have built the data analysis and mapping process would take days, in fact we have heard competitors quote large sums of money for such work, if they do not already know the file standard, and I can understand why. Some people believe there cannot be much to sending a file of invoices from one company to another, but the devil is in the detail and that is why EDI or EIPP is becoming more and more a Software as a Service arena. Without the specialist skills and tools it is the Total Cost of Ownership of EDI or EIPP, the costs of skilled data analysts, mapping tools, testing teams and support, that more and more Financial Directors are saying is too expensive to do in house. The sending and receiving of physical files is easy, but the set-up of the variety of communication processes is not. What a lot of companies are now saying is get somebody else to cope with the messy bit, we just want to send and receive one file format and use one communications method.
After all, if you distribute building materials do you want to spend your money on making the distribution more efficient and selling more OR staffing up the IT team to have data analysts, EDI experts, XML experts, communications experts, oh and have them also run you IT systems as well?
Saturday, February 02, 2008
ISO 9001 can improve your business profitability
We have recently been going through the process of achieving ISO 9000 accreditation for our Software as a Service EDI/EIPP offering. It has been a fascinating process. I had always believed that one of the secrets of a successful outsourcing or SaaS offering is to reduce the number of support calls to a minimum. I know this is a statement of the blindingly obvious but you would be amazed the tales we hear from customers moving to our service from other offerings.
When we started out on the route to ISO 9001 accreditation I thought it would have some benefit in terms of seeing where we were making mistakes, correcting them and of course there is the marketing benefit, but mainly in making sure that we continued to provide a quality service for our customers. I believe we are the only SaaS EDI or EIPP provider to be accredited for ISO 9001.
But the more I, with the help of our ISO 9001 consultant, got in to the depths of understanding ISO 9001 it became clear that whilst ISO 9001 does highlight the quality of whatever systems are being measured, the major benefit is the application of the continuous improvement principle.
We have been accredited for our data mapping processes and our systems and support processes for the provision of EDI data mapping, translation and transportation. In my next blog I will discuss the application of process to data mapping and translation, but today I want to concentrate on support.
When I look at a lot of our competitors, especially in the SaaS EDI or EIPP space, I notice that whilst the are bigger than us in terms of turnover, they are typically making huge losses. Some have accumulated losses of over 26 million and yet they still have turnover that is substantially less than their costs.
Looking at it even closer you can see that whilst they increase turnover they are increasing staff, and staff costs, much faster. To me this leads to the conclusion that whatever systems and support they have are not efficient enough. And that is one of the major benefits of the ISO9001 process.
What we have found is that every time we have have a support call/system issue the ISO process of continuous improvement has helped us to eradicate that error/issue for the future. It does not mean that we never get errors but analysis shows use that over 85% of all support calls/issue we received are outside of our service. They are either errors with the data sent to us or the comms of the sender or the recipient.
By concentrating on the ISO 9001 continuous improvement process we are able to keep our support costs to a minimum, we are able to handle millions of transactions per annum with a much smaller team than any of our competitors and we are able to keep improving the experience for our customers and their trading partners.
ISO 9001 does not make you infallible, but it helps you to learn from each mistake and improve your business and profitability.
I did have a cheeky thought though, should I go to the bigger players making all the losses and offer that we do the product, service and support for them, there will of course be an element of cost for them ;-). We could then show them how to make money instead of burning it. Just a thought....
When we started out on the route to ISO 9001 accreditation I thought it would have some benefit in terms of seeing where we were making mistakes, correcting them and of course there is the marketing benefit, but mainly in making sure that we continued to provide a quality service for our customers. I believe we are the only SaaS EDI or EIPP provider to be accredited for ISO 9001.
But the more I, with the help of our ISO 9001 consultant, got in to the depths of understanding ISO 9001 it became clear that whilst ISO 9001 does highlight the quality of whatever systems are being measured, the major benefit is the application of the continuous improvement principle.
We have been accredited for our data mapping processes and our systems and support processes for the provision of EDI data mapping, translation and transportation. In my next blog I will discuss the application of process to data mapping and translation, but today I want to concentrate on support.
When I look at a lot of our competitors, especially in the SaaS EDI or EIPP space, I notice that whilst the are bigger than us in terms of turnover, they are typically making huge losses. Some have accumulated losses of over 26 million and yet they still have turnover that is substantially less than their costs.
Looking at it even closer you can see that whilst they increase turnover they are increasing staff, and staff costs, much faster. To me this leads to the conclusion that whatever systems and support they have are not efficient enough. And that is one of the major benefits of the ISO9001 process.
What we have found is that every time we have have a support call/system issue the ISO process of continuous improvement has helped us to eradicate that error/issue for the future. It does not mean that we never get errors but analysis shows use that over 85% of all support calls/issue we received are outside of our service. They are either errors with the data sent to us or the comms of the sender or the recipient.
By concentrating on the ISO 9001 continuous improvement process we are able to keep our support costs to a minimum, we are able to handle millions of transactions per annum with a much smaller team than any of our competitors and we are able to keep improving the experience for our customers and their trading partners.
ISO 9001 does not make you infallible, but it helps you to learn from each mistake and improve your business and profitability.
I did have a cheeky thought though, should I go to the bigger players making all the losses and offer that we do the product, service and support for them, there will of course be an element of cost for them ;-). We could then show them how to make money instead of burning it. Just a thought....
Tuesday, January 22, 2008
SaaS adds more value to EDI
With more and more off our customers we are happily finding ways to add value to the normal EDI processing that has been experienced with older, on-site solutions.
Firstly new acronyms are appearing, for example EIPP (Electronic Invoice Presentation and Payment). Sceptics might call this EDI invoices and BACS. I shall explore the differences in a future post.
For a lot of our users, up until about 18 months ago, traditional EDI with a hint of XML for spice, was just fine. But we have started to notice a sea change in the requirements for EDI. Obviously there is the move towards AS2 and other methods of sending and receiving data. We have been using AS2 for our customers for nearly 4 years but in the past 18 months the adoption rate has accelerated markedly. This is a great move, it reduces the costs of EDI and adds value by removing the latency built in to most EDI processes by the nature of the timed connections.
We have also seen a move to increased data requirements. This has proved difficult for some users as it was not always easy, as I am sure you will realise, to modify their ERP system to process the additional data. However they often had the additional data in "Non EDI" data, for example catalogues, or even the incoming documents such as Purchase Orders.
Because of the nature of our SaaS solution, being based around the concept that all data has value whatever the format, plus the fact that the solution is based on a repository we have been able to take these disparate data sources and merge them to create enhanced EDI messages that the recipient requires. This would be a real struggle with traditional on-site systems.
Over the next few months we intend to expand the use of such solutions to both enhance customer data, add functionality to the user experience of the service and to provide translations of product codes, units of measure, delivery points and many other requirements that are becoming the norm for the modern EDI message exchange.
By adding more value to EDI messages we believe that adoption will accelerate through the next 10 years.
Firstly new acronyms are appearing, for example EIPP (Electronic Invoice Presentation and Payment). Sceptics might call this EDI invoices and BACS. I shall explore the differences in a future post.
For a lot of our users, up until about 18 months ago, traditional EDI with a hint of XML for spice, was just fine. But we have started to notice a sea change in the requirements for EDI. Obviously there is the move towards AS2 and other methods of sending and receiving data. We have been using AS2 for our customers for nearly 4 years but in the past 18 months the adoption rate has accelerated markedly. This is a great move, it reduces the costs of EDI and adds value by removing the latency built in to most EDI processes by the nature of the timed connections.
We have also seen a move to increased data requirements. This has proved difficult for some users as it was not always easy, as I am sure you will realise, to modify their ERP system to process the additional data. However they often had the additional data in "Non EDI" data, for example catalogues, or even the incoming documents such as Purchase Orders.
Because of the nature of our SaaS solution, being based around the concept that all data has value whatever the format, plus the fact that the solution is based on a repository we have been able to take these disparate data sources and merge them to create enhanced EDI messages that the recipient requires. This would be a real struggle with traditional on-site systems.
Over the next few months we intend to expand the use of such solutions to both enhance customer data, add functionality to the user experience of the service and to provide translations of product codes, units of measure, delivery points and many other requirements that are becoming the norm for the modern EDI message exchange.
By adding more value to EDI messages we believe that adoption will accelerate through the next 10 years.
Friday, January 11, 2008
EDI as a Supplier: Brownie Points or Valuable Benefits?
A simple sum, taking the numbers of keystrokes saved through integrated EDI and multiplying them by the keystroke cost quickly determines the viability of each electronic trading relationship.
This has proven to be very useful. It makes assessing whether eBusiness is actually saving the company any money as well as showing up any benefits and what those benefits are worth.
All well and good for a giant, but how is a smaller company able to know things are moving in the right direction, if there are simply insufficient resources to measure these things for you?
What are the opportunities for improvements if you are a supplier to a customer requiring EDI?
Here are a few:
Integrated EDI improves the certainty of delivery for your invoices. You can avoid the “Haven’t received the invoice. Send a copy!” conversation when you enquire what the Devil has happened to your money!
It also improves the timing of invoice delivery, which is very helpful as:
(i) closer invoice timing to goods delivery improves the likelihood of trouble free delivery (GRN) approval
(ii) the earlier invoices are produced & delivered the earlier the “payment due date” clock starts ticking
You are doing the invoice input for the customer, which leads to better information quality going into your customer’s ERP and ensures 100% data integrity across the supply chain!
Your integrated EDI will reduce the likelihood of delayed payments because errors are flagged up earlier, on processing the invoice, rather than as a result of chasing non-payment. A faulty invoice sent via EDI is rejected by the system and you can know in seconds. A faulty paper invoice might remain undetected by you until well after the end of your agreed payment terms with the customer!
You may not have the resources for obtaining detailed measurements of the effect of EDI on your business but you can still determine if things are going in the right direction for you. All you need do is watch one or more of some easily ascertained Key Performance Indicators (KPIs)…
- Improved Process Effectiveness – watch to see if the numbers of Day Sales Outstanding are reducing.
- Improved Productivity – is the number of invoices (or detail lines) processed per fiscal period increasing?
- More Automation – is the proportion of transactions that are processed automatically increasing?
- Improved Quality 1 – check that the ratio of credit notes raised to invoices produced is decreasing!
- Improved Quality 2 – is the number of rejected invoices decreasing?
- Improved Quality 3 – is the number of queries raised also decreasing?
- Cost – is the average cost of processing a transaction decreasing?
So, even with limited time and resources available to you, a glance at any one of these can reassure you that you, as well as your customers, can benefit from integrated electronic trading.
Next time we can look at the same subject from the customer's perspective
Wednesday, January 09, 2008
A Simple Guide To Electronic Data Interchange
Over the holiday period I decided to create a "Simple" Guide to EDI for our Web Site. The idea was that, without needing to register or download, people could visit the Web Site and get a "Simple" FREE introduction to EDI, an answer to the question "What is EDI?".
I wanted to highlight to people what EDI is, what standards they can expect to find and how messages are exchanged. Six Web pages later and I have a thought. The concept of exchanging business documents electronically IS Simple.
The detail of it is convoluted, but for a good reason. Most businesses have a unique way of working. Most IT systems have a unique way of working. Certainly each industry has unique features, for example the way Paper is specified in an order is nothing like how a tin of baked beans is specified which is nothing like how a length of steel lintel for a building is specified. If a human is handling orders and invoices then their knowledge is used to "translate" between the buyers instructions and the suppliers computer system. With EDI or EIPP then the software must assume some or all of this intelligence.
The concept of EDI is easy, but as Ken Foster (One of Our Data Mappers) who has sat on many EDI committees and standards bodies says "The devil is in the detail". If people say that EDI is easy, then they are ignoring the detail or spinning a line (probably in sales ;-)). We chose to do this work because we a sad people who enjoy the detail, but it is not the standard IT software role and it is not to everyone's liking. We believe, and our customers believe, that Outsourcing EDI (SaaS) is best for most businesses because it is such a specialist area. Have a look at any "simple" Guide to EDI and if it is telling the truth you will see how complex it can be.
I wanted to highlight to people what EDI is, what standards they can expect to find and how messages are exchanged. Six Web pages later and I have a thought. The concept of exchanging business documents electronically IS Simple.
The detail of it is convoluted, but for a good reason. Most businesses have a unique way of working. Most IT systems have a unique way of working. Certainly each industry has unique features, for example the way Paper is specified in an order is nothing like how a tin of baked beans is specified which is nothing like how a length of steel lintel for a building is specified. If a human is handling orders and invoices then their knowledge is used to "translate" between the buyers instructions and the suppliers computer system. With EDI or EIPP then the software must assume some or all of this intelligence.
The concept of EDI is easy, but as Ken Foster (One of Our Data Mappers) who has sat on many EDI committees and standards bodies says "The devil is in the detail". If people say that EDI is easy, then they are ignoring the detail or spinning a line (probably in sales ;-)). We chose to do this work because we a sad people who enjoy the detail, but it is not the standard IT software role and it is not to everyone's liking. We believe, and our customers believe, that Outsourcing EDI (SaaS) is best for most businesses because it is such a specialist area. Have a look at any "simple" Guide to EDI and if it is telling the truth you will see how complex it can be.
Sunday, December 30, 2007
The World (retail at least) Keeps Spinning
Firstly, complements of the season to all.
As with all companies in the business of EDI, at least some of our customers have continued to operate throughout the holiday season. In particular in the retail sector orders for goods to be delivered on all days are being processed, and at least one of the logistics companies that use our service were actually working from 6pm on 25th December.
Of course our servers operate on a 365 days per year basis, but certain customers require the comfort of a support contact available as well, which we provide. This is seen very much as an insurance policy and we hope it never needs to be called upon. Unfortunately this year, on 26th December it was. Not a problem with any of our servers, but because we monitor customers traffic we were able to alert a particular customer to the fact that their systems had failed and they had not sent some of the transmissions we had expected. Sometimes, because EDI is integral to a business, we can actually help users to see errors in other systems, before any other alert is raised, and it is great to be able to offer such help.
One other issue that has come to our attention is the practice of some other providers in charging for messages stored on their servers. A number of new customers this year have contacted us concerned about storage charges over the festivities. It appears that some of our competitors charge for holding messages that the customer does not download within 7 days. Whilst this does not effect users such as those detailed above, this would obviously cause extra cost for users if they are shutdown over the festive period. What an outdated practice. One would almost think that this was the equivalent of an EDI "Stealth Tax". We were able to put users minds at rest as we do not charge for storage of up to one year. Some of our users are saying this will save them several hundred pounds which is great. We want our users to be happy customers for years to come and being short sited for a few hundred pounds would be ridiculous. It would also appear to be at odds with our views that EDI should be Software as a Service and AS2 must be Free of Charge.
One day all EDI will be this way.
As with all companies in the business of EDI, at least some of our customers have continued to operate throughout the holiday season. In particular in the retail sector orders for goods to be delivered on all days are being processed, and at least one of the logistics companies that use our service were actually working from 6pm on 25th December.
Of course our servers operate on a 365 days per year basis, but certain customers require the comfort of a support contact available as well, which we provide. This is seen very much as an insurance policy and we hope it never needs to be called upon. Unfortunately this year, on 26th December it was. Not a problem with any of our servers, but because we monitor customers traffic we were able to alert a particular customer to the fact that their systems had failed and they had not sent some of the transmissions we had expected. Sometimes, because EDI is integral to a business, we can actually help users to see errors in other systems, before any other alert is raised, and it is great to be able to offer such help.
One other issue that has come to our attention is the practice of some other providers in charging for messages stored on their servers. A number of new customers this year have contacted us concerned about storage charges over the festivities. It appears that some of our competitors charge for holding messages that the customer does not download within 7 days. Whilst this does not effect users such as those detailed above, this would obviously cause extra cost for users if they are shutdown over the festive period. What an outdated practice. One would almost think that this was the equivalent of an EDI "Stealth Tax". We were able to put users minds at rest as we do not charge for storage of up to one year. Some of our users are saying this will save them several hundred pounds which is great. We want our users to be happy customers for years to come and being short sited for a few hundred pounds would be ridiculous. It would also appear to be at odds with our views that EDI should be Software as a Service and AS2 must be Free of Charge.
One day all EDI will be this way.
Thursday, November 22, 2007
It's the data that matters, not how it looks
This blog could also be entitled the triumph of substance over style.
We had a new customer sign with us last week, not in itself unusual, but that fact that we were replacing an alternative solution, and at the same time becoming the partner of choice for another software house is worth mentioning. At a more technical level it gave me an insight in to the limitations of some of the older methods for EDI integration.
The client concerned required a particularly rapid turn around of one specific trading relationship and asked if we could move faster than our standard Service Level Agreement (SLA). We had a quick look at the data, the format required by the recipient and the how the missing data could be deduced. We then said yes.
However, the reason for the rush was that this particular Trading Partner (a customer of our customer) had been waiting for over six months. The reason was that whilst the previous EDI vendor had claimed that their tool was flexible and did not need rigid formats. The truth was more like "we have several different formats that we can use, but outside of these formats we will struggle or it will be a an expensive consultancy exercise".
I have a problem with this approach. I do see the benefit of standard data formats being developed, in fact I really admire the business analysis that has gone in to the development of standards such as UN EDIFACT. However these standards are rarely rigidly adhered to and that is both the problem and the beauty. Different businesses have different data requirements, sometimes based around restrictions in the ERP system, sometimes around the business process. Therefore, your EDI solutions must have the flexibility to change as the business requirements or you or your partner changes, this may involve merging data from various sources, using a message intended for one purpose to provide the data for a different message, splitting or concatenating data to provide different data and the use of look-up tables or catalogues. Sometimes we are even asked to use one message between trading partners to add data to another message between the same partners. Obviously, because our service is Software as a Service (SaaS), the idea of such data merging is easier than for software deployed at the end user site, especially when like us you can be using industry catalogues that are shared amongst many users.
One thing is certain, the format of the data (XML, EDI, csv, Fixed Width or even MS Excel) is irrelevant as long as the data that is required by the recipient is either present or can be deduced. You see the style of the message is not as important as the substance (aka content) of the message.
We had a new customer sign with us last week, not in itself unusual, but that fact that we were replacing an alternative solution, and at the same time becoming the partner of choice for another software house is worth mentioning. At a more technical level it gave me an insight in to the limitations of some of the older methods for EDI integration.
The client concerned required a particularly rapid turn around of one specific trading relationship and asked if we could move faster than our standard Service Level Agreement (SLA). We had a quick look at the data, the format required by the recipient and the how the missing data could be deduced. We then said yes.
However, the reason for the rush was that this particular Trading Partner (a customer of our customer) had been waiting for over six months. The reason was that whilst the previous EDI vendor had claimed that their tool was flexible and did not need rigid formats. The truth was more like "we have several different formats that we can use, but outside of these formats we will struggle or it will be a an expensive consultancy exercise".
I have a problem with this approach. I do see the benefit of standard data formats being developed, in fact I really admire the business analysis that has gone in to the development of standards such as UN EDIFACT. However these standards are rarely rigidly adhered to and that is both the problem and the beauty. Different businesses have different data requirements, sometimes based around restrictions in the ERP system, sometimes around the business process. Therefore, your EDI solutions must have the flexibility to change as the business requirements or you or your partner changes, this may involve merging data from various sources, using a message intended for one purpose to provide the data for a different message, splitting or concatenating data to provide different data and the use of look-up tables or catalogues. Sometimes we are even asked to use one message between trading partners to add data to another message between the same partners. Obviously, because our service is Software as a Service (SaaS), the idea of such data merging is easier than for software deployed at the end user site, especially when like us you can be using industry catalogues that are shared amongst many users.
One thing is certain, the format of the data (XML, EDI, csv, Fixed Width or even MS Excel) is irrelevant as long as the data that is required by the recipient is either present or can be deduced. You see the style of the message is not as important as the substance (aka content) of the message.
Thursday, November 08, 2007
The use of catalogue data in EDI
One of the big issues that faces companies exchanging data electronically in any industry is the alignment of the data on all trading partners systems.
As a simple example we can look at a purchase order sent from a retailer to a supplier. The purchase order contains data that has been produced from the retailers back office system that is required by the suppliers back office system in order that the order is fulfilled efficiently. This data will include information such as the delivery point and the code for each product ordered.
When the order is processed by a human, the human interprets the data they see and translates this in to the data required by the suppliers ERP system. When the data is exchanged electronically this "translation" needs to be done automatically. For a lot of suppliers ERP systems this has already been accommodated, but we still get requests from customers to help with this process.
One of the advantages of a Software as a Service (SaaS) is in the nature of having a centralised hub. We have taken the approach of hosting catalogue data on the hub which means that ALL customers that need access to this data, to enhance the data they send or receive, can use it. If our software was deployed at our customers sites then each customer would need a copy of each catalogue they use, and they would have to be regularly updated. With the SaaS approach one catalogue is shared by all relevant users, and is regularly updated in one place.
I should say that to us a catalogue is a name given to ANY look-up data which we process. This could be a list of valid delivery points, a list of product groupings and, of course, products and prices. The important thing to do is to enhance the data received by the recipient so that they can process the incoming data automatically without human intervention. After all that is what EDI is about.
Whilst we have found this approach to be some use in the retail sector, the real advantages have arisen in the construction sector, where EDI is still a maturing technology and the back office systems of both sides of a trading relationship are not a well configured for electronic message exchange as those in the retail sector. But as we are adding construction trading relationships at the rate of 20 to 30 LIVE trading relationships per month, this technique is proving its worth.
As a simple example we can look at a purchase order sent from a retailer to a supplier. The purchase order contains data that has been produced from the retailers back office system that is required by the suppliers back office system in order that the order is fulfilled efficiently. This data will include information such as the delivery point and the code for each product ordered.
When the order is processed by a human, the human interprets the data they see and translates this in to the data required by the suppliers ERP system. When the data is exchanged electronically this "translation" needs to be done automatically. For a lot of suppliers ERP systems this has already been accommodated, but we still get requests from customers to help with this process.
One of the advantages of a Software as a Service (SaaS) is in the nature of having a centralised hub. We have taken the approach of hosting catalogue data on the hub which means that ALL customers that need access to this data, to enhance the data they send or receive, can use it. If our software was deployed at our customers sites then each customer would need a copy of each catalogue they use, and they would have to be regularly updated. With the SaaS approach one catalogue is shared by all relevant users, and is regularly updated in one place.
I should say that to us a catalogue is a name given to ANY look-up data which we process. This could be a list of valid delivery points, a list of product groupings and, of course, products and prices. The important thing to do is to enhance the data received by the recipient so that they can process the incoming data automatically without human intervention. After all that is what EDI is about.
Whilst we have found this approach to be some use in the retail sector, the real advantages have arisen in the construction sector, where EDI is still a maturing technology and the back office systems of both sides of a trading relationship are not a well configured for electronic message exchange as those in the retail sector. But as we are adding construction trading relationships at the rate of 20 to 30 LIVE trading relationships per month, this technique is proving its worth.
Friday, November 02, 2007
EDI Can Make You Feel Good and Improve Your Business
When we started developing the technology for exchanging EDI messages many moons ago, we obviously wanted to develop a software solution that would provide a service businesses would want to purchase, because without that we do not have a business ourselves. But we were also determined to ensure that the product and service were such that our customers would be able to see a return on their investment, unlike a lot of software that promises great ROI, but provides non.
We determined that the way to do that was to reduce any technical input from our customers to a minimum (reduce their costs of set-up), integrate messages to our customer's ERP systems when practical (some systems just could not cope with an electronic remittance for example) and to eliminate the need for them to change their systems to cope with our integration standard (You would be amazed how many times we have heard that from other people).
People keep buying the software and people keep renewing their licence so one could assume that we are continuing to get it right. But a better test in when customers actually talk to us and recently, as part of our program to achieve ISO 9000:2000 accreditation, we have be performing customer feedback surveys.
It's great when customers tell us what they would like from us next, as it means we do not have to keep coming up with all the new ideas. But in following up on the feedback, and expanding beyond the normal survey type questions, it was even better to find customers saying things like EDI has helped us achieve strategic alliances or we don't even notice the EDI is there it just works or we have dramatically increased the amount of e-trading we conduct. It makes you feel good when you can help someone else achieve success.
We aimed to provide the best SaaS for EDI in the UK and Europe, and the customers will judge us on that, but we also wanted to actually add value to our customers businesses and this also appears to be happening. Electronic message exchange for businesses has always had the potential to drive cost out of business but it was always perceived as a bit too much of a dark art.
Now with the combination of SaaS EDI where the actually mapping is done on the SaaS, not just a Web App you have to use, plus the best levels of customer service this is coming to fruition, and even adding to strategic business alliances.
The future of Electronic Message exchange is SaaS, the old technology of a piece of software deployed on a pc or server on site cannot deliver the flexibility needed for today's EDI.
We determined that the way to do that was to reduce any technical input from our customers to a minimum (reduce their costs of set-up), integrate messages to our customer's ERP systems when practical (some systems just could not cope with an electronic remittance for example) and to eliminate the need for them to change their systems to cope with our integration standard (You would be amazed how many times we have heard that from other people).
People keep buying the software and people keep renewing their licence so one could assume that we are continuing to get it right. But a better test in when customers actually talk to us and recently, as part of our program to achieve ISO 9000:2000 accreditation, we have be performing customer feedback surveys.
It's great when customers tell us what they would like from us next, as it means we do not have to keep coming up with all the new ideas. But in following up on the feedback, and expanding beyond the normal survey type questions, it was even better to find customers saying things like EDI has helped us achieve strategic alliances or we don't even notice the EDI is there it just works or we have dramatically increased the amount of e-trading we conduct. It makes you feel good when you can help someone else achieve success.
We aimed to provide the best SaaS for EDI in the UK and Europe, and the customers will judge us on that, but we also wanted to actually add value to our customers businesses and this also appears to be happening. Electronic message exchange for businesses has always had the potential to drive cost out of business but it was always perceived as a bit too much of a dark art.
Now with the combination of SaaS EDI where the actually mapping is done on the SaaS, not just a Web App you have to use, plus the best levels of customer service this is coming to fruition, and even adding to strategic business alliances.
The future of Electronic Message exchange is SaaS, the old technology of a piece of software deployed on a pc or server on site cannot deliver the flexibility needed for today's EDI.
Monday, October 29, 2007
EDI, The ultimate Software as a Service
There are now more and more applications that are available as Software as a Service (SaaS). The highest profile is Salesforce.com, which we use internally for CRM, Customer Support and Project Management. We have partnered with another SaaS offering in Netsuite, which offers a complete ERP as SaaS, and we also use Google Docs for sharing Spreadsheets and Text Documents.
However, one of the very best applications that SaaS can be used for is EDI. The way EDI is moving at present with multiple standards (EDI, XML and Flat File) and multiple communication methods such as EDI VAN and AS2, it makes sense to outsource the technical complexity to a company that specialises in it. Whilst the importance of EDI as a way in increasing both profits and cash flow for your business are undeniable, it would be rare for the technical complexity to be a core business for any organisation other than an EDI specialist.
Since we started making our software available as SaaS in 2003, all our customers have moved to this model. They all share the same benefits of a single method of communications (to suit their requirements) and a single file format (which suits their ERP). On our customers behalf we currently have in excess of 800 different message translations and 17 different communication methodologies. Whilst some IT teams in large organisations may see this as "their territory", I am sure that the directors do not see it as core competency for the business, and would rather see them developing inventive uses for IT that affect their core business, whatever it might be.
SaaS is a growing market, even Microsoft are looking at planning to enter the market, and EDI SaaS is a natural fit.
However, one of the very best applications that SaaS can be used for is EDI. The way EDI is moving at present with multiple standards (EDI, XML and Flat File) and multiple communication methods such as EDI VAN and AS2, it makes sense to outsource the technical complexity to a company that specialises in it. Whilst the importance of EDI as a way in increasing both profits and cash flow for your business are undeniable, it would be rare for the technical complexity to be a core business for any organisation other than an EDI specialist.
Since we started making our software available as SaaS in 2003, all our customers have moved to this model. They all share the same benefits of a single method of communications (to suit their requirements) and a single file format (which suits their ERP). On our customers behalf we currently have in excess of 800 different message translations and 17 different communication methodologies. Whilst some IT teams in large organisations may see this as "their territory", I am sure that the directors do not see it as core competency for the business, and would rather see them developing inventive uses for IT that affect their core business, whatever it might be.
SaaS is a growing market, even Microsoft are looking at planning to enter the market, and EDI SaaS is a natural fit.
Friday, October 19, 2007
EDI as it was intended: To Make Savings!
Imagine you had just discovered EDI, or "B2B Messaging", or "XML" or "eBusiness", or whatever you want to call it and you were the first so to do!
Imagine that you were able to examine the pros and cons and decide for yourself just where in your business you wanted to make savings, without the distracting pressures of trading partners demanding you start doing EDI etc. their way, NOW!
Imagine you were going to come at EDI asking "What's in it for me?"
You might decide you would rather use this handy discovery of yours to make savings in areas that you have hitherto (in the real World) had to leave for another day...
Now you can have your EDI via Software as a Service (SaaS), where the service provider takes care of ALL the message formats needed by the recipients and ALL the transport methods they prefer, you can literally dump some of your problems for good. I'm on about such nasty jobs as making remittance advices, printing them off, stuffing them in envelopes, pushing them through the franking machine, burning fuel (yours or the postie's) to get them into the post... and all this at the end of the month, when your staff have plenty of other work they could be doing.
Why not simply dump the remittance advices and all the messy work they entail?
You can if you want to...
How?
Just output ("dump") them as a file into the directory that your SaaS EDI system links to. The service can then collect them ALL. The rules engine pulls out those that are destined for suppliers who can accept them as EDI, translates them to the required formats to suit each recipient and sends the messages to them via the agreed transport method...
Yes, yes that's OK for those suppliers but what about all the rest that have no EDI capable of accepting remittance advices?
It couldn't be easier. They are all translated into .pdf documents, complete with your logo and livery, and sent via email to each of the other suppliers. From start to finish, the process takes only a few minutes.
We have a customer for whom it used to take ten staff three hours (of very hard work) at the end of every month to get their remittance advices printed, folded, stuffed into envelopes, franked and ready for the post collection. Now it takes one person less than ten minutes (and the work now is very easy). It is saving our customer quite a bit and needed no months and months of delay waiting for every supplier to implement stuff in some draconian "roll-out". Those with EDI get EDI, the others simply receive their remittance advices in their emails.
The service takes full advantage of what is there. The suppliers get their remittance advices, no matter what is happening to the postal service. The customer gets valuable time back whilst saving: money, paper, envelopes, fuel. It is a very eco-friendly process in which nobody loses out.
Now isn't this the sort of thing you would like to be doing with EDI?
Imagine that you were able to examine the pros and cons and decide for yourself just where in your business you wanted to make savings, without the distracting pressures of trading partners demanding you start doing EDI etc. their way, NOW!
Imagine you were going to come at EDI asking "What's in it for me?"
You might decide you would rather use this handy discovery of yours to make savings in areas that you have hitherto (in the real World) had to leave for another day...
Now you can have your EDI via Software as a Service (SaaS), where the service provider takes care of ALL the message formats needed by the recipients and ALL the transport methods they prefer, you can literally dump some of your problems for good. I'm on about such nasty jobs as making remittance advices, printing them off, stuffing them in envelopes, pushing them through the franking machine, burning fuel (yours or the postie's) to get them into the post... and all this at the end of the month, when your staff have plenty of other work they could be doing.
Why not simply dump the remittance advices and all the messy work they entail?
You can if you want to...
How?
Just output ("dump") them as a file into the directory that your SaaS EDI system links to. The service can then collect them ALL. The rules engine pulls out those that are destined for suppliers who can accept them as EDI, translates them to the required formats to suit each recipient and sends the messages to them via the agreed transport method...
Yes, yes that's OK for those suppliers but what about all the rest that have no EDI capable of accepting remittance advices?
It couldn't be easier. They are all translated into .pdf documents, complete with your logo and livery, and sent via email to each of the other suppliers. From start to finish, the process takes only a few minutes.
We have a customer for whom it used to take ten staff three hours (of very hard work) at the end of every month to get their remittance advices printed, folded, stuffed into envelopes, franked and ready for the post collection. Now it takes one person less than ten minutes (and the work now is very easy). It is saving our customer quite a bit and needed no months and months of delay waiting for every supplier to implement stuff in some draconian "roll-out". Those with EDI get EDI, the others simply receive their remittance advices in their emails.
The service takes full advantage of what is there. The suppliers get their remittance advices, no matter what is happening to the postal service. The customer gets valuable time back whilst saving: money, paper, envelopes, fuel. It is a very eco-friendly process in which nobody loses out.
Now isn't this the sort of thing you would like to be doing with EDI?
Subscribe to:
Posts (Atom)
