Select JDEtips Article

Advanced Menu Security within JD Edwards World

By Jim Rubino

Size: 624 KB, Version:1.0, Publication Date:4/1/2015

World's A9x releases include new features on the technical side that make functions such as security easier to manage. This article describes how to allow/deny access to menus by user or group of users.

Using Generic Function Key Exits

By Jim Rubino

Size: 1.44 MB, Version:1.0, Publication Date:12/30/2014

World's Generic Exits functionality puts the users (and the developers) in the driver's seat. In this article, Jim Rubino steps us through several scenarios for building custom exits, starting with the most simple, and building to more complex solutions, from popping out to another World program to do some maintenance, to grabbing an item's image, to jumping to an internet URL, such as Google Maps.

Interactive and Batch Data Import and Export in World A9.1

By Kathy Adams

Size: 556 KB, Version:1, Publication Date:6/2/2008

If transferring data from JD Edwards to spreadsheets has been a drag (and not as in drag and drop), there's a new feature in World's latest release, A9.1, that's bound to make you smile. Kathy Adams demonstrates the new JD Edwards World PC Import/Export functionality that enables interactive and batch import/export of data, even with custom screens.

PC Import-Export World A9.1 Tips

By Kathy Adams

Size: 730 KB, Version:1, Publication Date:6/2/2008

Session # 36180 from Collaborate 08. See also Kathy's white paper, "Interactive and Batch Data Import and Export in World A9.1" in the Technical/World Software category.

Search Type Security in World - The Search Is ON

By Rick Snell

Size: 536 KB, Version:1, Publication Date:4/4/2008

You do a search in the Address Book, and before your eyes--a wealth of information appears. Addresses, names, account numbers--maybe even some of the most sensitive information of all--Social Security Numbers. All of it readily available, in just a few keystrokes. Think you need to lock it down? You betcha! But can you do this in such a way that you're allowing access where needed, without opening up your critical information to everyone? You might be thinking--"okay, but Search Type Security is simple and I know what it does." Prepare to be impressed as Rick Snell discusses the basics and some advanced tips that will help you automate your Search Type Security setup.

Combining IBM and JDE Data for an Audit Reporting Strategy

By Rick Snell

Size: 330 KB, Version:1, Publication Date:2/6/2008

Ah, audits. Like death and taxes, you can't avoid them. But you CAN take some steps to make life easier for both you and the auditor by combining some key security information found in both IBM iSeries and JDE World into one report. Rick Snell provides some tips that will help you pull this data together pre-audit, so that you and your auditors will be faced with a lot less paper come audit day.

Setting Up and Reporting On World Action Code Security

By Rick Snell

Size: 155 KB, Version:1, Publication Date:10/16/2007

It's a hot topic these days--security reporting. The problem is, some approaches to setting up security just don't seem to be user-friendly--especially for those tasked with monitoring the situation. Fortunately, Rick Snell has a great tip to help you cut through the clutter and get the information you need to see from the system, efficiently. His method uses a join between F0003 and F0092. He'll walk you through the setup steps, along with tips he's learned along the way to making this method smooth.

Setting Up and Using JDE World Data Base Audit Manager

By Jim Rubino, Fike Corporation

Size: 1.2 MB, Version:1.0, Publication Date:3/22/2007

Tracking what changes are being made and who's making those changes in your company's World file records is a lot easier, thanks to Data Base Audit Manager. Jim Rubino joins us to give you some tips for setting up this vital tool, which will allow you to continuously record the who, what, where, and when of data base changes. The Audit Manager records the before and after images for each change, along with user IDs and date/time stamps. We're sure the time you spend getting this process in gear now will save you a lot of time down the line when the auditors are next in town!

Supplemental Data Rules of the Road

By Cordell Kirk

Size: 270KB, Version:1.0, Publication Date:3/22/2007

In the January 2007 issue of JDEtips, Andy Klee gave us an article called "Advanced Pricing Rules of the Road". This article turned out to be so popular that we have invited some of our top writers to continue the theme. Cordell Kirk starts us off with his "RotR" for Supplemental Data. Supplemental data can be a valuable method for managing data that isn't accommodated in your standard JD Edwards World® database tables. This article guides you through their care and feeding.

How to Obsolete a Customer Address Record

By Jim Rubino, Fike Corporation

Size: 980KB, Version:1.0, Publication Date:7/18/2006

So, you and a customer are parting ways... how do you deal--at least from an accounting perspective? You need to block the ability to enter Sales Orders for this customer, but at the same time, you need to keep the sales history available for future reference. There are a number of ways to do this, but Jim Rubino has a truly win-win answer for making a customer's Address Number obsolete, without sending the prior information into cyber-space. Read on as he takes you step-by-step with his solution to this dilemma.

Third-Party Payroll Timecard Integration Simplified

By Paul Hanson

Size: 479KB, Version:1.0, Publication Date:7/18/2006

The methods may be hi-tech, but the need is the same--making sure you track employee time accurately. Integrating a third-party time tracking system (such as Kronos) with JD Edwards can be a tricky situation. In the time-honored JDEtips tradition, Paul Hanson offers his interface design and code saving you time and expense. Punch in here to learn more!

Third-Party Timecard Integration Simplified - With Code

By Paul Hanson

Size: 241KB, Version:1.0, Publication Date:7/18/2006

The methods may be hi-tech, but the need is the same: making sure you track employee time accurately. Integrating a third-party time tracking system (such as Kronos™) with JD Edwards can be a tricky situation. In the “time”-honored JDEtips tradition, Paul Hanson offers his interface design and code — saving you time and expense. Punch in here to learn more!

Generic UDC Code

By Mike Savino

Size: 187KB, Version:1.0, Publication Date:1/19/2006

The ability to create a new "custom" UDC Table in JD Edwards is cause for celebration! If you're creating custom programs, the custom UDC helps you avoid the necessity for hard-coded values in your programs, while increasing flexibility and giving the custom work a JD Edwards look and feel that your end-users have become accustomed to. This white paper includes a nice example of how this technique works, and includes all the code you need at the end!

DreamWriter Open Query File

By Marsh Narawek

Size: 199KB, Version:1.0, Publication Date:11/10/2005

Not everyone has the luxury of owning the JD Edwards World CASE Tool. Those of us who don’t normally just copy another program’s source code, strip it (leaving only the important stuff), and then move on to applying our custom code. There are, however, occasions that we miss something and it causes the program to fail. This articles gives us some tips for analyzing and correcting these failures.

Converting JDE Julian Date in Microsoft Excel - A JDEtips Tipette

By Lixin Yang

Size: 135KB, Version:1.0, Publication Date:9/10/2005

Here at JDEtips, we occasionally like to publish small, easily-digestable "tip-ettes". When this one came across our desk, we felt that with so many people exporting data from their JDE database into Microsoft Excel, and given the ongoing trials of dealing with the JDE date format, we thought this one would be an excellent one to share. Lixin Yang gives us the code to create your own Excel date conversion function. While this article is written for World, the Excel function would still work in EnterpriseOne; the difference is in how you get the data to Excel.

Displaying UDC Tables That Have Value in One of the Two Description Fields

By Jim Rubino, Fike Corporation

Size: 588KB, Version:1.0, Publication Date:9/10/2005

Have you ever needed to find where a description from a UDC is coming from? Or have you needed to find out where the same description is used in multiple UDC tables? Or have you wanted to check consistency in wording for descriptions? Or maybe you have just thought how nice it would be to see all of the UDC tables that have a value in one of the UDC description fields? Jim Rubino gives us another great tip for making life easier. Read on! This Journal article shows you the end result.

Interfacing with Non-JD Edwards Timecards

By Paul Hanson

Size: 633KB, Version:1.0, Publication Date:9/10/2005

Life would be so simple if we could accomplish everything without worrying about interfaces from/to JD Edwards. But that turns out to be the rare exception. Paul Hanson shows us how to bring payroll timecard data from "somebody else's" timecard application into your JDE Payroll system. In this article, you'll see both the business process and some of the technical specs. We also have a "long" version in the Document Library that includes the entire RPG program to finish up the process.

Displaying WorldWriter Versions That Created a File (with Code)

By Jim Rubino, Fike Corporation

Size: 278KB, Version:1.0, Publication Date:8/1/2005

Jim Rubino is at it again – yep, you guessed it – making life easier for his World user community. This time, Jim describes a utility that will give you a list of all files that were created by World Writer versions, or conversely, which World Writer created a specific file. Pretty slick, huh? Keeps people from overwriting each others files, and sure helps with housekeeping, as well. As usual, we are posting this article both with and without the code and file specs that go with it. This is the "long version", with all the code at the end.

Displaying WorldWriter Versions That Created a File

By Jim Rubino, Fike Corporation

Size: 459KB, Version:1.0, Publication Date:7/21/2005

Jim Rubino is at it again – yep, you guessed it – making life easier for his World user community. This time, Jim describes a utility that will give you a list of all files that were created by World Writer versions, or conversely, which World Writer created a specific file. Pretty slick, huh? Keeps people from overwriting each others files, and sure helps with housekeeping, as well. As usual, we are posting this article both with and without the code and file specs that go with it.

Automating iSeries FTP for World

By Paul Hanson

Size: 462KB, Version:1.0, Publication Date:5/6/2005

JDEtips Senior Technical Editor, Paul Hanson, was chosen for that role for a reason. His tips and his style for presenting them are so practical, concise, and so well-written that we hardly need to edit them first. This article shows us once again how to save lots of time and money without spending lots of time and money in the process. This relatively simple bit of customization will allow you to automate the FTP communications between your iSeries World environment and remote FTP servers. From screens to script, this article gives you everything you need to implement this time-saving device.

Displaying Menus Using a Dream Writer or World Writer Version

By Jim Rubino, Fike Corporation

Size: 287KB, Version:1.0, Publication Date:5/6/2005

Sometimes people just plain don't like it when you change their "stuff". Especially if they didn't know it was going to happen. Well, generally the person doing the changing doesn't like surprises, either, so Jim Rubino went into proactive mode and created a method to make it easier to find out who's using what before it gets changed instead of just making the change and sitting back waiting for the phone to ring. This technique can certainly also have value in monitoring your user access for audit purposes, so read on! (Our JDEtips Document Library will also have this article available as a "long version", complete with all the code.)

Displaying Menus Using a Dream Writer or World Writer Version (with Code)

By Jim Rubino, Fike Corporation

Size: 421KB, Version:1.0, Publication Date:5/6/2005

Editor's Note: Sometimes people just plain don't like it when you change their "stuff". Especially if they didn't know it was going to happen. Well, generally the person doing the changing doesn't like surprises, either, so Jim Rubino went into proactive mode and created a method to make it easier to find out who's using what before it gets changed instead of just making the change and sitting back waiting for the phone to ring. This technique can certainly also have value in monitoring your user access for audit perposes, so read on! (This version includes all the code!)

Copy Spooled Files to Output Queues

By Marsh Narawek

Size: 406KB, Version:1.0, Publication Date:3/11/2005

Our favorite thing about our JDEtips contributors is that their primary goal seems to be to make life easier for their customers – This article describes a scenario where users were clearly not having any fun, so Marsh Narewek teamed up with his co-system-supporters to develop a utility to solve the problem. Take a look at how they were able to send the same report to multiple printers at the same time – saving time from the night run and simplifying the process for the users at the same time.

Emailing Reports and Forms from World

By Jim Rubino, Fike Corporation

Size: 721KB, Version:1, Publication Date:11/9/2004

Just when we think we've found the perfect third-party product to solve our particular problem, we find that we need Jim Rubino to help us make it actually work for us. Jim shares with us here the behind-the-scenes tricks needed to email reports and documents from World using third-party emailing tools. The way he explains it, it looks pretty easy--once you know how!

Recursive Version - How It Works Plus a Unique Trouble-Shooting Tip

By Marsh Narawek

Size: 155KB, Version:1, Publication Date:11/3/2004

If you find yourself "cursing" Recursive Versions, you really need to read this article. Marsh Narawec gives us not only a succinct explanation of how Recursive Versions work, but also of how they might NOT work. Read and learn from one who has been there and done that – another example of why JDEtiPS presents articles written from the trenches.

Unlocking a DreamWriter or WorldWriter Version for Security

By Jim Rubino, Fike Corporation

Size: 744KB, Version:1.0, Publication Date:7/14/2004

Science Fiction writer, Robert Heinlein, once wrote a story about a man who was "too lazy to fail". While we are certainly NOT suggesting that Jim Rubino is lazy – hardly that! -- he tends to employ the same techniques suggested by Mr. Heinlein for inventing fairly painless methods that save tons of work! In this article, Jim shows us another of his enhancements that lets you get in, get out, and get on with whatever you were doing!

World Sleeper Enhancements

By Jim Rubino, Fike Corporation

Size: 740 KB, Version:1, Publication Date:5/5/2004

In the January/February 2004 issue of JDEtips, Jim Rubino gave us an unbiased (well, almost) assessment of the relative merits of the AS/400 Job Scheduler and the World Sleeper. If he appeared to favor the Sleeper in any way, perhaps the enhancements he created had some influence. You think? Read on for details of getting more bang for the buck on this valuable unattended job scheduling tool.

World Version A73 cum 15 - A Review

By Jean Driscoll and Jim Rubino

Size: 82 KB, Version:1, Publication Date:5/5/2004

On March 18ty, 2004, PeopleSoft announced a March 31st release of World A7.3 Cumulative Update 15. PeopleSoft graciously granted JDEtips the opportunity to share the announcement details with you, our faithful readers. We invited World experts and regular JDEtips contributors, Jean Driscoll and Jim Rubino, to give us the highlights and their assessment of this exciting and long-awaited update. For all the good news, and how to download the full writeups from PeopleSoft, read this article!

Sleeper Enhancements

By Jim Rubino, Fike Corporation

Size: 1.1 MB, Version:1.0, Publication Date:5/1/2004

In the January/February 2004 issue of JDEtips, Jim Rubino gave us an unbiased (well, almost) assessment of the relative merits of the AS/400 Job Scheduler and the World Sleeper. If he appeared to favor the Sleeper in any way, perhaps the enhancements he created had some influence. You think? Read on for details of getting more bang for the buck on this valuable unattended job scheduling tool. This version contains the custom code that Jim mentioned in the May, 2004 issue of JDEtips.

Debugging a WorldSoftware Program

By Jim Rubino, Fike Corporation

Size: 971 KB, Version:1.0, Publication Date:3/1/2004

For PeopleSoft World programmers, the major challenge is not figuring out how to write the world's greatest program...it is figuring out why that perfect program is not giving the expected results. In this article, Jim Rubino once again guides us through a true time-saver--the art of choosing which debugging tool to use to chase down a problem. He then walks us through the steps for three different debuggers.

Comparison Between JDE Sleeper and AS400 Job Scheduler

By Jim Rubino, Fike Corporation

Size: 875 KB, Version:1.0, Publication Date:1/1/2004

Decisions, decisions, decisions! If you've wondered which of the available job scheduling tools to use but haven't had time to go through step-by-step to figure out which one does what, Jim Rubino's article sums it up for you. He doesn't make the decision for you, but gives enough information to make the decision easier for you.

WorldSoftware Window Program for Finding Vertex Tax Codes

By Jim Rubino, Fike Corporation

Size: 1.7 MB, Version:1.0, Publication Date:9/1/2003

Jim Rubino is a wizard at creating helpful tools for making World Software easier to use. Included here are instructions for creating a table lookup window program. You can do these for just about any purpose imaginable. Jim says at his company they've got a lookup window for Employee Birthdays, another for looking up User IDs by name, and another to see security setup by Name and Group/Class. The example in this white paper is based on a Vertex table, but let your imagination run wild!

Adding New Hidden Selections for WorldSoftware

By Jim Rubino, Fike Corporation

Size: 470 KB, Version:1.0, Publication Date:5/1/2003

Just about everyone on WorldSoftware uses the HS command to get to Hidden Selections. Jim Rubino, master of JDE and AS/400 programming, shows how to add more commands to the HS window. Specifically, Jim shows you how to add the WRKSPLF command to the HS window. The same strategy may be used to add other AS/400 commands--thereby making them more accessible to your users.

Stop Losing Messages Using WorldSoftware

By Jim Rubino, Fike Corporation

Size: 340 KB, Version:1.0, Publication Date:5/1/2003

Jim repeatedly comes up with great technical tips for our WorldSoftware audience. This one continues that record with a series of helpful enhancements to the Send Message function on the AS/400. You know what we're talking about. It's the command that everyone uses to remind the Instructor that it's time for a class break.

Sending WorldSoftware Approval Messages to External Email

By Vasu Venkateswaran, Datamatics

Size: 150 KB, Version:1.0, Publication Date:3/1/2003

JDE introduced Approval Processing for purchasing in WorldSoftware A7.3 in 1993. Ever since, clients have wanted to know how to get the system to send email notifications to external email addresses (outside of JDE's rudimentary PPAT module). Your wait is over! An excellent explanation that has been field-proven at several clients.

Stopping Single Character Fields from Auto Advancing in WorldSoftware

By Jim Rubino, Fike Corporation

Size: 30 KB, Version:1.0, Publication Date:3/1/2003

This is one of those simple programming changes that really seems to be worth the maintenance effort. Within WorldSoftware there are several programs that use single character fields on the video screen. When a value is entered in a single character field, standard JDE functionality advances the cursor to the next field. Frequently the user has to execute multiple keystrokes to advance to the next desired input field. This simple one line modification makes the screen much more usable by preventing the auto advance. An example where this could be very useful is the screen used to setup WorldWriters.

Unable to find what you are looking for? Feel free to submit your topic as a potential article via our Request Information form.

Technical--WorldSoftware