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

Optimize Your Warehouse Replenishments with these Best Practices | LoadProof

  This best practice is about making  replenishments  inside the warehouse. It is important to stay on the top off replenishments always in your warehouse. If you have just one shift that you are running it would help a lot. If you spend extra hours in the evening and then do the topping off all your active locations it will be helpful for the pickers in the next shift. In the next morning when the pickers come after all the locations will be full and they can start picking right away without wasting time in replenishments. If you have two shifts running either choose the second shift or have a third shift if possible and keep doing the top off replenishments. There are active replenishment locations and these active locations have Min and Max. Whenever your inventory falls below min, replenishments are going to get triggered or it will get triggered if there is an order that needs a lot of picks from a particular location. This will drive the location down which will tri...

Picture Documentation for Freight Claims White Paper – Part I | LoadProof

  INTRODUCTION This document describes the benefits of an effective Picture Documentation System(PDS) that helps with getting Freight Claims Paid faster. An effective pictures documentation system helps with 1 – Get Freight Claims paid much faster by making pictures available quickly and easily, 2 – Provides visibility to the damages through pictures. The visibility gained provides insight into the handling mistakes made while the orders are fulfilled, so that the parties can determine and establish accountability boundaries and get the shipper paid. BACKGROUND What are Freight Claims? A freight claim is a legal demand by a shipper or a consignee to a carrier for financial reimbursement for a loss or a damage of a shipment. Freight Claims are claims submitted by manufacturers/suppliers/shippers to transportation vendors and or carriers, when the goods the Supplier shipped did not arrive at the destination in a pristine state. Instead it arrived as damaged, the packaging was damaged...

3PL Panacea: The Flexible Mobile Supply Chain Platform | LoadProof

  The third-party logistics (3PL) business is tough, because it covers a wide gamut of service offerings, that include some combination of: Just move my boxes and/or pallets. Move my boxes and/or pallets and store them in your warehouse. Move my boxes and/or pallets and operate my facility. Own all the labor and activities in my facility. Offer all distribution services for my product (All I will do is download my orders into your system/supply chain). I’ve even run into more complicated models of operation, including both tightly and loosely coupled models.  In a tightly-coupled model, the supply chain systems of the 3PL, including orders, inventory, transportation, advanced shipment notices, purchase orders, and more, are tightly integrated into the shipper’s supply chain systems. All this information seamlessly flows between both supply chain systems of the 3PL and the shipper. They stay in synch with each other and the parties perform the functions in their respective syst...