By Stefanie Uhl
Just like a house or office that has many wonderful features and supplies that are difficult to find or are broken (rendering them useless), your JDE data is much less valuable to you if it’s not 100 percent accurate and integral. JD Edwards’ database is a true gem packed with endless useful information, but it is only highly valuable if the data is “squeaky clean.” The JDE integrity programs are not 100 percent complete and often take a long time to run – making it frustrating to run them frequently.
Did you know that there is a solution available that provides high level, easy-to-use “maid service” for your JD Edwards data? Of course, the solution is called Insight and is available from InsightSoftware.com for both World and E1.
Insight can quickly and easily check the following, just to name a few areas:
- Are all companies in balance
- Are all required category codes filled in
- Are there accounts with the same code but different descriptions
- Does the Accounts Receivable account balance to the A/R system
- Does the Received but not Vouchered account balance reconcile to the PO system
- Does your PPV (purchase price variance ) tie to your GL
- Does your cycle count tie to your inventory
- Are you certain that your purchasing department is only using preferred vendors and thereby gaining significant savings
Here’s how I see it: Insight can help identify areas that require attention, but it can often also help resolve the issues easily. Years ago when I was a JD Edwards application consultant, I can distinctly recall spending several days trying to help a German JDE customer determine why their GL was out of balance by .01 “Pfennig.” Insight could have helped me resolve this issue in hours, if not minutes, and would have saved the customer a significant amount of time and money.
In another engagement a customer was extremely frustrated by a report where the numbers did not seem to accurately be reporting regional revenues and expenses. It took them days to finally determine that the category codes were not accurately complete on all business units. With Insight’s drill down feature, this would have been identified and resolved quickly. Insight also has a hierarchy feature where it is easy to be certain that all business units and accounts are included.
An InsightSoftware.com customer (Courtney Robinson, 4Front Assistant Controller) recently said, “I’ve used Insight to find missing tax codes and category codes, and I plan to do even more integrity checking with the solution.”
Let the story unfold: http://www.insightsoftware.com/jde.
