Skip to main content

Ownership is Everything: The Data Integrous System of Record | LoadProof

 


Our actions and decisions are only as good as the data we use to rule them. That being true, when designing complicated systems, ensure the integrity of the data set involved becomes enormously important. Obviously, the data that resides in a system should be accurate. However, it also needs to have integrity, which means consistent and not unnecessarily redundant.

A good data set is invaluable. Done well, it puts all of the data elements in one place, making it easy to share, analyze, extrapolate, and use.  Which system owns the data is potentially even more important.  If you want to fundamentally alter the data based on business rule or a business logic, then it should be done in the system that owns the data—so it’s critical to track the lifecycle of the system and to refer users to the primary system for specific data.

For example, sales order (SO) information is always owned by an enterprise resource planning (ERP) system, since that is where all the aspects of the order are handled and tracked throughout the lifecycle of the sale. That same sales order might be downloaded to a warehouse management system (WMS) for fulfillment. The WMS will use the order information to fulfill the order, to optimize the fulfillment process, for packaging instructions, and more. However, this system should only allow information lookup—while changes to the data should be done in the ERP.

Let me offer a real-world example. When I was working at multinational computer company, we sold computers all over the world. We had a complicated challenge of streamlining the system integrations pertaining to shipment data from various manufacturers worldwide. These suppliers would share advance shipment notifications (ASNs) through electronic data interchange (EDI).  About 856 transactions in all, these provided all shipment information that allowed the recipient to be ready to receive the product. Our goal was to create a single consistent architecture so that the Global Supply Chain Systems Group could support it.

Click here to continue reading this article.

Comments

Popular posts from this blog

5 reasons why you should switch from using your digital camera right now | LoadProof

  Are you still using digital cameras to capture and store photos of your shipments and other processes in your warehouse?  If the answer is “yes”, then there is a better way. Initially, you may not think it’s much to address, but when you think about how many photos are taken each day in your warehouse then there is a lot of time and money that can be saved by switching to a more efficient photo process.  Using digital cameras to capture photos, and PC’s to store the photos of the loads taken during shipment might result in issues such as:  Slow uploading - your camera likely requires a hardwire plug-in through USB. Time-consuming photo tagging - adding reference numbers or labels. Slow retrieval of photos - photos are often hard to search and locate. Sharing photos manually - manually attaching JPEG files to email. Accountability - there is no accountability as you don’t know who worked on the shipment. With an efficient photo documentation system will include: Fas...

Are you still using google drive in your warehouse? | LoadProof

  Here is another interesting dynamic about  LoadProof . Apparently somebody in their organization is interested and somebody saw the value of the product – LoadProof provides.  We get to talk to them and they’re curious. They want to learn more, and in our conversation this comes up: “hey we already use Google Drive, and we store pictures in Google Drive and and it was great for us”. This was actually a very interesting story. An intern from Georgia Tech, pretty smart kid, but they don’t understand all the implications of using an enterprise system for a recognized supply chain environment. In an established supply chain network, you’re dealing with so many different partners such as vendors, customers, transportation service providers, lumpers, etc., Supply chain is a huge community.  When you spend some time in the industry you understand all these different players and how to work with them and how to maintain the data integrity and still do business maintaining ...

Improve Quality in Your Supply Chain by Increasing Visibility | LoadProof

  I would think that electronics OEMs or distributors would be leading the charge toward quality, and I’m sure many of them are. However, the first time I encountered a quality department that did extensive quality control it was in a New Hampshire distribution center (DC) that served the apparel industry. For this manufacturer, the goal was to make fairly priced clothing that delivered good quality to middle-aged women. The Director of Quality at the warehouse, along with her team, did such a good job that this retailer was known for its quality. To meet their quality goals, workers spent a lot of time measuring the tops and pants against strict criteria, checking the cut of the pieces, figuring out how the pieces would look on real people, and making sure that the colors were good for a variety of skin tones. They thought of everything. They took pictures and shared infractions with their vendors across the supply chain. Quality inspection Quality inspection is a relatively simpl...