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
More Stories
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...
VirtualBox Fails After Windows 11 Upgrade (NtCreateFile failed)
After upgrading from Windows 10 to Windows 11, VirtualBox fails to start your Virtual Machine. You receive this error: NtCreateFile...
Quick Tip: WebLogic NodeManager Fails To Start As Windows Service
If your Oracle WebLogic NodeManager starts without issue when using startNodeManager.cmd but when configuring the WebLogic NodeManager as a Windows Service, it fails to start. The nodemanager.log file has the following entry: Native version is enabled but NodeManager native library could not be loaded
Quick Tip: Determine Active Directory Account Status From The Windows Commandline
Use the following command to Determine Active Directory Account Status from the Windows Commandline without Powershell or any special software....
Average Rating