Convert an EDI 816 to Excel CSV File

Jobisez created another translation tool.  This new tool converts an EDI 816 to CSV file.  The Organization Relationship transaction set is sent by the retailers, and it contains store location information.

The EDI 816 typically contains Store Name, Duns or GLN number, Address, City, State Zip and Country.  It may also contain Contact Name, Phone, Fax and Email Address.  As well as Effective, Opening and Closing Dates of that Store.

If you do not have a Jobisez account, you can create an account for free.  Then visit the 816 Conversion page.  If you are already signed onto Jobisez, you can "Browse" for an EDI 816 transaction set on your computer and create an Excel file by clicking "Create CSV". Then wait a couple of moments and your initial and translated files will be emailed to you. Upon the receipt of the email, you can then open the CSV file attachment using Excel. Within Excel you can then analyze the Organization Relationships data using the Excel tools you are already familiar with. Please verify that the data generated is correct. (Currently only works with one 'ISA' interchange. The EDI data cannot be more than 250 KCs.)

Visit this page to learn more about the EDI 816 transaction set.

Please respond to this blog post with any questions you may have.

Thank you.

What is the EDI 852 Product Activity Document

Drilling down and understanding the EDI 852 POS document

After posting the Tracking Sales Trends tool blog entry, we thought it would be a good idea to give a better understanding of the POS EDI document.  For the most part, retailers (pretty much) send POS in a standard format, this blog shows a typical POS document.

Wikipedia gives a pretty weak definition of the ANSI X12.852 document.  Its description is too general and does not do a good job showing how voluminous the 852 is, and how it helps manufacturers determine sales trends and outages.

Although the retailers send a typical format, they differ in what types of data quantities they supply.  Most will send Quantity Sold (QS) and Quantity Available for Shipment (QA).  Some will also send Quantity Out-of-Stock (QO), and still other retailers will send Quantity Requested (QX).

This is where the issues arise, each retailer sends different quantities.  That is why we suggested a cloud-based POS Analytics Tool.

Our next blog post will describe the EDI 830 Planning and Forecasting document.  And finally, we will wrap it up with how both the 852 and 830 EDI documents work together.

On another note, the EDI 852 data can be very large if you receive UPC/Store level information.  These transactions can cost a lot of money if you receive the data through an EDI VAN.  Here’s an opportunity to lower your EDI VAN costs.

Identify Sales Trends, Stock-outs, Missed Selling Opportunities and Historical Performance

Achieve retailing efficiency via supply chain collaboration, planning and forecast evaluation.

 

Retailers provide suppliers with a host of performance and forecast data. The challenge is how to intelligently mine this data to optimize the flow of goods through the supply chain. Analytics hosted business intelligence solutions help suppliers identify key performance indicators and facilitate effective collaboration with retailers.

 

Cloud-based, managed services collaboration solutions using a combination of sophisticated data warehouse design concepts and presentation tools to analyze forecasting, sell-through (and other supply chain data), forecasts and plans via either direct ERP extract or EDI transaction fees.

• Hosted Model – No need to acquire and maintain expensive data warehouse hardware and software.
• Microsoft Excel Driven – Utilize all of the benefits of Excel to work with the data.
• Ad-Hoc Reporting – Query, drill down, analyze voluminous data in real-time.
• Common Data View – Suppliers and retailers identify and act on opportunities to increase sales and optimize inventory levels.
• Multiple Data Feeds – Extracted data from ERP applications and EDI transactions.

Before making a decision on whether or not to invest time and money into an Analytics Tool, there is a POS Demo that can be tailored made for your needs.