Improvements to the EDI 852 to Excel Tool

Jobisez understands the necessity of understanding the EDI 852 Product Activity (POS) document.  We have defined the importance of this document in two of our blogs, What is the EDI 852 and Identifying Sales-Trends.

With this information, we created an Online Tool last year to create a CSV spreadsheet from an EDI 852 transaction.  This tool has been very popular and used quite often.

After careful analysis of the 852s being processed, we needed to add several more LIN qualifiers to the tool so it can be helpful to more companies.

With its new release today, the tool now looks for the following qualifiers in the LIN segment...
1.  UP - U.P.C. Consumer Package Code (1-5-5-1)
2.  UB - U.P.C. / EAN Case Code (2-5-5)
3.  ND - National Drug Code 
4.  UI - U.P.C. Consumer Package Code (1-5-5)
5.  UD - U.P.C. / EAN Consumer Package Code (2-5-5)
6.  IB - International Standard Book Number (ISBN)
7.  EN - European Article Number (EAN) (2-5-5-1)
8.  EO - GTIN-8
9.  UK - GTIN: U.P.C. / EAN Shipping Container Code (1-2-5-5-1)
10. VN - Vendor's (Seller's) Item Number
11. MG - Manufacturer's Part Number
12. VP - Vendor's (Seller's) Part Number
13. VC - Vendor's (Seller's) Catalog Number
14. VA - Vendor's Style Number
15. IN - Buyer's Item Number
16. PN - Company Part Number
17. BP -  Buyer's Part Number
18. PI - Purchaser's Item Code
19. CB - Buyer's Catalog Number
20. IT - Buyer's Style Number

Please feel free to post a comment on what other features you would like to see this tool do.  For instance, would you like the CTP values on the spreadsheet, or perhaps you would also like to see the Color and Size information too.

Faster is Better (Part 2)

As mentioned in our first "Faster is Better" posting, Jobisez LLC increased its bandwidth on August 25 to make your navigation through the jobisez.com site even quicker.

Using Analytic Tools, you can see that the Jobisez site is faster than 78% of the sites and pages load in 1.6 seconds.  You may ask yourself, "why or how does this affect me?"

Jobisez is primarily a research site for EDI intelligence.  We understand that your time is essential, and you do not need to wait for pages to load when you need to find an answer quickly.

To make your experience even better, we added a search box to each page, so you can search on any EDI related term you are looking for.

Let us know how we are doing or how we may be more helpful to 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.

Online EDI Tools by Jobisez

One of the Services that Jobisez offers are EDI Tools.  These tools primarily massage EDI data and create a format that is more user-friendly.  The Tools start off in our Labs, and when they pass testing, they become Graduates.

This is a newer service that is being offered.  We currently only have a couple of them, so if you have any suggestions, drop us a line, and let us know what tools you think would be helpful to you.

Let us know what you think and how you think we should proceed.  Your input is valuable to us!