Numeric Will Never Equal Alpha
Here is a really frustrating thing about some tables or files, depending on your IT dialect, with in EnterpriseOne. After working with EnterpriseOne for awhile (10 minutes should do) you will notice that the omniscient creators of the application did not like to make things easy. Take, for instance, the issue that Alan VanNice addresses on his blog: joining the F4211 (Sales Orders) and the F4801 (Work Orders).
Our staff has talked about this a number of times. It is a strange way of relating tables. You see the RORN on the F4801 is an alpha field where the DOCO field on the F4211 is numeric. Now, this issue can be overcome fairly easily in SQL with a CAST function. However, inside of E1 the issue is a little more complicated. Alan does a great job explaining his method using the EnterpriseOne Report Design Aid.
Author
Stewart Schatz
Career: Principal CNC Consultant for Syntax Systems Limited specializing Oracle JD Edwards EnterpriseOne and the technology that supports it.
Side Hustle: Owner/Operator of E1Tips.com
Location: Lancaster, PA USA
What I like to do: Invest in Family, Explore Technology, Lead Teams, Share Knowledge/Experience, Hunt, Hike, etc.
More Stories
JDE CNC + JDE Developer ≠ 1
Recently, while scrolling on this platform, where we all strive to present our best professional selves, I came across a job posting titled JD Edwards E1 CNC/Developer. To be honest, it kind of scared me.
How to Use the rsync Command to Sync Files and Directories on Linux
The rsync command is one of the most powerful tools in the Linux toolkit for syncing files and directories. Whether...
How to Use the CMDKEY Command to Manage Stored Credentials on Windows
The cmdkey command is a Windows utility that lets you create, delete, and manage stored credentials for network authentication. This is particularly useful…
How to Use the XCOPY Command in Windows
Did you know that all versions of Windows have a limitation of 260 characters that can be in the path...
How to Clean Up Empty Directories Using the find Command in Linux
Managing files and directories in Linux often involves dealing with empty directories that can clutter your workspace. Manually finding and...
How to Print a Directory Structure Using PowerShell: Step-by-Step Guide
If you need to print out the directory structure and list the files within, this PowerShell script will help you...
Average Rating