If you have ever used the JDEdwards cross-reference facility in an attempt to find where a certain table column is used, you understand that it can be difficult, especially when the alias for your column is common. Let's say you have a custom table [F550001] that has a column [URRF], and you need to find […]
During nine years of blackguarding the J. D. Edwards date format (also known as JDate, also misnamed Julian Date), I have resisted learning to write DB/2 stored procedures because the need to use them while developing OneWorld applications is minimal and OneWorld is the only context in which I have encountered DB/2. Well, I have […]
As long as we are discussing JD Edwards running on DB/2. Here's another potentially useful function. This one converts a value from one unit of measure to another based on the F41002 table. It does this by converting the FromUOM to the primary UOM and thence to the ToUOM.
I know since we posted the JDE date to real date function, everyone has been wondering where the real date to JDE date function is. Well, "ask and you shall receive."
During an upgrade to JDE EnterpriseOne you will need to list any changes that have been made to your data dictionary, and using SQL or even a UBE, most developers would have no problem coming up with a way to compare the pristine data dictionary with the latest version. We thought, however, it might be nice […]
Every day at Deft Flux, we are mapping unique paths from problem to solution, and we like to share them with you from time to time. Today, our question is a common one -- "How can I automatically run and e-mail a Crystal Report?" Let's consider this case where you want to schedule a report […]
Let us say that your company has a production line style operation where it would be inefficient for operators to leave the line to clock onto and off of jobs. Managers would like to use labor collection to analyze efficiency and profitability, but there are enough jobs that the time spent clocking on and off […]
It just gives up, grabs the rod and reel, and walks out.