ERP Data Accuracy

Have you ever heard expression “garbage in, garbage out”? No doubt, if we do not put correct data into any perfect software system, we won’t get correct data out. Period. The more accurate master information is in the system, the better supply chain procurements execute and as a result the better business performance and our customers are happier. Everybody wins. The opposite is also true, poor incomplete data leads to poor planning and execution, lack of credibility.

The question arises: how on earth, in today’s rapidly changing and turbulent business environment, where everything can change overnight, we can maintain high degree of data accuracy for thousands and thousands of ERP database records? Is there a way to keep up with high standards to withstand economic storms?

 ppptmt.p b+                1.4.1 Item Master Maintenance               09/09/09
┌──────────────────────────────────────────────────────────────────────────────┐
│      Item Number: 0924218-0000         Description: w/wire .045CB 40#        │
│  Unit of Measure: LB                                                         │
└──────────────────────────────────────────────────────────────────────────────┘
┌───────────────────────────────── Item Data ──────────────────────────────────┐
│     Prod Line: 1500      Item Type: COMP         Drawing:                    │
│         Added: 01/17/01     Status: AC          Revision: 3                  │
│  Design Group:               Group: DISCRETE Drawing Loc:           Size:    │
│   Promo Group:                      Price Break Category:                    │
└──────────────────────────────────────────────────────────────────────────────┘
┌──────────────────────────── Item Inventory Data ─────────────────────────────┐
│          ABC Class: C               Average Interval: 90                     │
│ Lot/Serial Control:             Cycle Count Interval: 120                    │
│               Site: DRB                   Shelf Life:                        │
│           Location: Loc2         Allocate Single Lot: No                     │
│      Location Type:                         Key Item: No                     │
│   Auto Lot Numbers: No             PO Receipt Status:          Active: No    │
│          Lot Group:                WO Receipt Status:          Active: No    │
│     Article Number:                                                          │
└──────────────────────────────────────────────────────────────────────────────┘
┌───────────────────────────── Item Shipping Data ─────────────────────────────┐
│     Corp Comm Code: 10-450-0001-205                                          │
│        Ship Weight: 0.00                      Net Weight: 0.00               │
│      Freight Class:                               Volume: 0.00               │
└──────────────────────────────────────────────────────────────────────────────┘
┌───────────────────────────── Item Planning Data ─────────────────────────────┐
│   Mstr Sched: No         Buyer/Planner: AM              Phantom: No          │
│  Plan Orders: Yes             Supplier:           Minimum Order: 0           │
│   Time Fence: 0                PO Site: DRB       Maximum Order: 0           │
│ MRP Required: No  Purchase/Manufacture: P        Order Multiple: 0           │
│ Order Policy: POQ   Configuration Type:          Op Based Yield: No          │
│    Order Qty: 0           Inspect: No             Yield Percent: 100.00%     │
│    Batch Qty: 1.0          Ins LT: 0    Cum LT: 5      Run Time: 0.000       │
│ Order Period: 7            Mfg LT: 0    Pur LT: 5    Setup Time: 0.000       │
│ Safety Stock: 0                                        EMT Type: NON-EMT     │
│  Safety Time: 0   ATP Enforcement: NONE     Auto EMT Processing: No          │
│Reorder Point: 0        Family ATP: No       Network Code:                    │
│     Revision: 3         Run Seq 1:          Routing Code:                    │
│ Issue Policy: Yes               2:           BOM/Formula:                    │
└──────────────────────────────────────────────────────────────────────────────┘

Use of traditional QAD user interface does not allow high level of efficiency. QAD maintenance programs are designed to view and update one record at a time. To revise a thousand Item Master records, one has to pull 1000 individual records one at a time and update each one. It is time consuming, but OK if you do it once in a while. This was not a problem a few years ago, but today it is a different ball game. It must to be done quite often and most important, very fast. But, how? The recent economy slowdown companies had to downsize their staff, which caused even more workload to the remaining personnel.

Now, imagine if Item Master data were presented in excel spreadsheet. How much easier and faster you would be able to update parameters for the same thousand records? Ways faster, right? Because you are not limited to viewing and updating one record at a time, you can scroll and see them all, manipulate – filter only ones you need, re-sort, auto-fill etc, etc…

And… this is exactly what we have designed… It is an excel workbook which can communicate with QAD system via built-in macros. User clicks on “download” button to pull Item master data to the Excel module, manipulates and updates parameters on the spreadsheet and uploads the dataset back to QAD by clicking onto “Upload” button. Do you think it makes user more efficient? A few times as much! You do not need to navigate through multiple frames of QAD maintenance screens to get to a field to change it, you just step on the value and change it. And multiply it by 1000 records…

What if the changed value is incorrect? When user clicks on “Upload”, the program scans the entire spreadsheet and validates the whole dataset against genuine QAD logic, so if you would key in all of it manually to QAD maintenance program. All erroneous values are immediately highlighted, as shown here, and detailed messages are provided. Upload is not performed in this case. This gives user an ability to quickly find and fix errors, unlike in traditional CIM load solutions, where it’s close to impossible to find where error is coming from.

Here, end users can perform their job quickly, accurately without IT department to be involved. Unlike in QAD maintenance programs, here, minimum to none training is required, very fast adoption – temp workers would be able to help.

The excel tools we have developed, will boost your productivity, immediately. We have many acknowledgements from our customers. However the most important thing is that these solutions can give you a pleasant feeling of accomplishment, when you complete a lot with a tiny effort. Your PC does the hard part for you – as it’s supposed to in the first place.

Will it work for you? Some of our clients reduce the number of staff because of our programs, some others eliminate overtime. We have a few dozens of success stories in all kinds of industries, but will it work for you? The bottom line, you never know until you try it, right? Then contact us today to get a free trail. You have nothing to lose and everything to gain.

Subscribe to Our Newsletters to learn more about ways to effectively manage QAD data.

Learn more about Excel Loaders